Dataguard broker is used to automate monitoring and controlling standby setups. It is very much useful, when the organization has multiple standby sites.

In this article, we will see, how to enable dg broker configuration in existing standby setup.

NOTE – Before setting dgbroker, make sure standby setup is ready.

SEE ALSO – Setup physical standby setup

ENVIRONMENT DETAILS:

PRIMARY UNIQUE DB NAME – > POCDB
STANDBY UNIQUE DB NAME – > POCDSBY

1. Set dg_broker_start to true [ ON BOTH PRIMARY AND STANDBY DB]

2. Add primary db configuration [ ON PRIMARY]

3. Add standby configuration [ ON PRIMARY ]

If you are getting error as ORA-16698: member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set, then
To fix this error, disable any log_archive_dest_n parameter set on standby( excluding log_archive_dest_1)

On standby:

SQL> alter system set log_Archive_dest_2=”;

System altered.

4. Enable configuration: [ ON PRIMARY]

Now let’s troubleshoot the ORA-16792 error, We are getting error standby database.

Check the properties for inconsistency.

We can see one critical parameter StandbyFileManagement is set to MANUAL . To fix the error set it to auto and try again.

— On standby

Enable the configuration again:

Our dgbroker setup is ready and we can do switchover and failover using dgmgrl easily.