Recreate a DG broker configuratinon without having to remove the configuration .dat files
edited May 8, 2015 1:49PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 2 commentsAnswered ✓
Hello
Is there a command that I can run from the DGMGRL prompt to remove the DG broker configuration so that I don't have to manually remove the configuration files. In other words can I avoid implementing this step (from Doc ID 808783.1)
Step 2. Drop old broker configuration files from both primary and standby:
Check the location of files using : "show parameter dg_broker_config_file"
By default the broker configuration files will be in "$ORACLE_HOME/dbs" in Unix and "$ORACLE_HOME/database" in Windows.
SQL> show parameter dg_broker_config_file
NAME TYPE VALUE
---------------------- ------ ----------------------------------------
dg_broker_config_file1 string \oracle\product\10.2.0\dbs\dr1PROD10G.dat
0