While using dataguard broker is optional with Dataguard, using it adds some complexity and flexibility – expect a little learning curve.
A prerequisite for using DGMGRL is that a primary database and any standby databases must already exist.
The DG_BROKER_START initialization parameter must be set to TRUE for all databases in the configuration. You must use a server parameter file (SPFILE) to use the Dataguard broker.
Another two initialization parameters will also be set when a broker configuration file is defined pointing to redundant configuration files:
The following query will show whether or not Dataguard Broker is enabled plus some other important info:
select dataguard_broker, db_unique_name, name, open_mode, log_mode, database_role
If you are SSH’d into the primary or standby – the following are some simple show configuration commands:
show configuration verbose
show database ‘PRIM’
show database ‘STDBY’
Here’s a nice write up for using DG Broker by Julian Dyke – although his listener configuration confused me a bit.