How To Move Dataguard Broker Configuration File On ASM Filesystem

Assume the below are the existing settings in Standby database:

To rename the broker configuration files in STANDBY to +FRA/STDDB/broker1.dat and +FRA/STDDB/broker2.dat,
Follow the below steps:

1. Disable the standby database from within the broker configuration:

   1	DGMGRL> disable database STDDB;

2. Stop the broker on the standby:

   1	SQL> alter system set dg_broker_start = FALSE;

3. Set the dg_broker_config_file1 & 2 parameters on the standby to the appropriate location:

   1 2	SQL> alter system set dg_broker_config_file1='+FRA/STDDB/broker1.dat'; SQL> alter system set dg_broker_config_file2='+FRA/STDDB/broker2.dat'

4. Restart the broker on the standby:

   1	SQL> alter system set dg_broker_start = TRUE

5. From the primary, enable the standby:

   1	DGMGRL> enable database STDDB;

6. Finally Broker configuration files will be created in the new ASM location.