移除Data Guard Broker
要Remove and deactive Data Guard Broker configuration可以通过以下步骤彻底删除：
1) Remove the Data Guard Broker Configurationa)
DGMGRL> remove configuration;
已移去配置
DGMGRL>
2) 在 primary database 设置 dg_broker_start=false
SQL> show parameter dg_broker
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1 string data/oracle/product/11.2.0.2/
dbs/dr1oms.dat
dg_broker_config_file2 string data/oracle/product/11.2.0.2/
dbs/dr2oms.dat
dg_broker_start boolean TRUE
SQL> alter system set dg_broker_start=false scope=both;
系统已更改。
SQL> show parameter dg_broker;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1 string /data/oracle/product/11.2.0.2/
dbs/dr1oms.dat
dg_broker_config_file2 string /data/oracle/product/11.2.0.2/
dbs/dr2oms.dat
dg_broker_start boolean FALSE
SQL>
3) primary disable any archive destinations that are archiving to the standby
SQL>select dest_id,destination,status from v$archive_dest where
target='STANDBY';
SQL> alter system set log_archive_dest_state_2=defer scope=both;
系统已更改。
SQL>
4) 在 standby database设置dg_broker_start= false
SQL> show parameter dg_broker;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1 string /data/oracle/product/11.2.0.2/
dg_broker_config_file2 string /data/oracle/product/11.2.0.2/
dg_broker_start boolean TRUE
SQL> alter system set dg_broker_start=false scope=both;
System altered.
SQL>
5) 在主备库上delete或rename metadata files (如果文件存在)
这个文件就是DG_BROKER_CONFIG_FILEn的设置，默认在$ORACLE_HOME/dbs目录两个默认的文件名dr1*.dat和dr2*.dat。
[@oms dbs]$ mv dr1oms.dat dr1oms.dat.back
[@oms dbs]$ mv dr2oms.dat dr2oms.dat.back
[@stoms dbs]$ mv dr1stoms.dat dr1stoms.dat.back
[@stoms dbs]$ mv dr2stoms.dat dr2stoms.dat.back
