Oracle DG 之-- Remove DG Broker
Remove the Data Guard Broker Configuration DGMGRL> remove configuration;b) Using Data Guard Manager or Grid Control:
Follow the Wizard as mentioned in the Chapter
'Scenarios Using Oracle Enterprise Manager'
of the Data Guard Broker Guide of each Database Version.
2) On the primary database set dg_broker_start=false:
SQL> show parameter dg_broker
NAME TYPE VALUE
dg_broker_config_file1 string ?/dbs/dr1@.dat
dg_broker_config_file2 string ?/dbs/dr2@.dat
dg_broker_start boolean TRUE
SQL>
SQL>>
System> SQL>show parameter dg_broker
NAME TYPE VALUE
dg_broker_config_file1 string ?/dbs/dr1@.dat
dg_broker_config_file2 string ?/dbs/dr2@.dat
dg_broker_start boolean FALSE
SQL>
3) On the primary disable any archive destinations that are archiving to the standby:
SQL> select dest_id,destination,status
2from v$archive_dest
3where target='STANDBY';
DEST_ID
DESTINATION
STATUS
2
(DESCRIPTION=(ADDRESS_LIST = (ADDRESS=(PROTOCOL=tcp)(HOST=bjsrv)(PORT=1521)))(CONNECT_DATA=(SID=TestDB12)(ORACLE_HOME=/u01/app/oracle/11.2.0/dbhome_1)(SERVER=DEDICATED)))
VALID
SQL>>
System> SQL>
4) on the standby set the dg_broker_start parameter to false:
SQL> show parameter dg_broker
NAME TYPE VALUE
dg_broker_config_file1 string ?/dbs/dr1@.dat
dg_broker_config_file2 string ?/dbs/dr2@.dat
dg_broker_start boolean TRUE
SQL>>
System> SQL>
5) On both system rename the metadata files (if they exist):
oracle@bjsrv:/u03/oracle/9.2.0/dbs> mv dr1DG920.dat dr1bjdb.bak
oracle@bjsrv:/u03/oracle/9.2.0/dbs> mv dr2DG920.dat dr2bjdb.back
RELATED DOCUMENTS
Oracle Data Guard Broker Guide
页:
[1]