By default, the broker configuration files of Oracle Data Guard are created onto local filesystem. In GI environment, we’d like those files are located in ASM filesystem.
Check Current Configurations
SQL> show parameter dg_broker_config
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1 string /u02/app/oracle/product/19.0.0.0/dbhome_1/dbs/dr1TESTDB.dat
dg_broker_config_file2 string /u02/app/oracle/product/19.0.0.0/dbhome_1/dbs/dr2TESTDB.dat
Stop the Broker
SQL> alter system set dg_broker_start = FALSE;
Set the dg_broker_config_file1 & 2 parameters to the appropriate location required
SQL> alter system set dg_broker_config_file1 = '+DATAC1/TESTDB/dr1TESTDB.dat'; SQL> alter system set dg_broker_config_file2 = '+DATAC1/TESTDB/dr2TESTDB.dat';
Restart the Broker
SQL> alter system set dg_broker_start = TRUE
Finally, the broker configuration files will be created in the new ASM location.
ASMCMD> pwd
+DATAC1/TESTDB
ASMCMD> ls -l dr*
Type Redund Striped Time Sys Name
DATAGUARDCONFIG HIGH COARSE JAN 13 11:00:00 N dr1testdb.dat => +DATAC1/TESTDB/DATAGUARDCONFIG/TESTDB.979.1126004761
DATAGUARDCONFIG HIGH COARSE JAN 13 11:00:00 N dr2testdb.dat => +DATAC1/TESTDB/DATAGUARDCONFIG/TESTDB.980.1126004761
ASMCMD>
Make DBA Life Easy 