in case your databa uard setup is RAC then make sure broker file are on ASM so that it is accesible from all RAC instances in both prod and standby
otherwise you may see this error
DGMGRL> show configuration
Configuration - ICR05DMA_DR
Protection Mode: MaxPerformance
Members:
ICR05DMA - Primary database
Warning: ORA-16532: Oracle Data Guard broker configuration does not exist
ICC05DMA - Physical standby database
Error: ORA-16810: multiple errors or warnings detected for the member
Fast-Start Failover: Disabled
Configuration Status:
ERROR (status updated 49 seconds ago)
you can see that broker config files are on filesystem
SQL> sho parameter broke
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
connection_brokers string ((TYPE=DEDICATED)(BROKERS=1)),
((TYPE=EMON)(BROKERS=1))
dg_broker_config_file1 string /u01/oracle/product/19C/db_1/d
bs/dr1ICR05DMA.dat
dg_broker_config_file2 string /u01/oracle/product/19C/db_1/d
bs/dr2ICR05DMA.dat
dg_broker_start boolean FALSE
use_dedicated_broker boolean FALSE
lets’s change the location to ASM
SQL> ALTER SYSTEM SET DG_BROKER_START=FALSE scope=both sid='*';
System altered.
SQL> ALTER SYSTEM SET dg_broker_config_file1 = '+DATA/ICR05DMA/dr1ICR05DMA.dat' scope=both sid='*';
System altered.
SQL> ALTER SYSTEM SET dg_broker_config_file2 = '+DATA/ICR05DMA/dr2ICR05DMA.dat' scope=both sid='*';
System altered.
SQL> sho parameter broke
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
connection_brokers string ((TYPE=DEDICATED)(BROKERS=1)),
((TYPE=EMON)(BROKERS=1))
dg_broker_config_file1 string +DATA/ICR05DMA/dr1ICR05DMA.dat
dg_broker_config_file2 string +DATA/ICR05DMA/dr2ICR05DMA.dat
dg_broker_start boolean FALSE
use_dedicated_broker boolean FALSE
similarly in standby
SQL> sho parameter broke
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
connection_brokers string ((TYPE=DEDICATED)(BROKERS=1)),
((TYPE=EMON)(BROKERS=1))
dg_broker_config_file1 string /u01/oracle/product/19C/db_1/d
bs/dr1ICC05DMA.dat
dg_broker_config_file2 string /u01/oracle/product/19C/db_1/d
bs/dr2ICC05DMA.dat
dg_broker_start boolean FALSE
use_dedicated_broker boolean FALSE
ALTER SYSTEM SET dg_broker_config_file1 = '+DATA/ICC05DMA/dr1ICC05DMA.dat' scope=both sid='*';
ALTER SYSTEM SET dg_broker_config_file2 = '+DATA/ICC05DMA/dr2ICC05DMA.dat' scope=both sid='*';
SQL> sho parameter broke
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
connection_brokers string ((TYPE=DEDICATED)(BROKERS=1)),
((TYPE=EMON)(BROKERS=1))
dg_broker_config_file1 string +DATA/ICC05DMA/dr1ICC05DMA.dat
dg_broker_config_file2 string +DATA/ICC05DMA/dr2ICC05DMA.dat
dg_broker_start boolean FALSE
use_dedicated_broker boolean FALSE