How To Move Dataguard Broker Configuration File On ASM Filesystem

Assume the below are the existing settings in Standby database:

SQL> show parameter broker
 dg_broker_config_file1           string          +DATA/STDDB/broker1.dat
dg_broker_config_file2           string          +DATA/STDDB/broker2.dat
   dg_broker_start                  boolean          TRUE

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:

   DGMGRL> disable database STDDB;

2. Stop the broker on the standby:

   SQL> alter system set dg_broker_start = FALSE;

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

   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:

   SQL> alter system set dg_broker_start = TRUE

5. From the primary, enable the standby:

   DGMGRL> enable database STDDB;

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