本文共 2148 字,大约阅读时间需要 7 分钟。
PURPOSE
How to safely remove a Data Guard Broker configuration.
SCOPE & APPLICATION This applies to all DBAs who wish to remove and deactive a
Data Guard Broker configuration.Removing the Configuration 1) Remove the Data Guard Broker Configuration
a) Using the Commandline DGMGRL:
- Connect to the Primary DatabaseDGMGRL> connect sys/<Password>@<Primary Database>
- Remove the Data Guard Broker ConfigurationDGMGRL> 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_brokerNAME TYPE VALUE
dg_broker_config_file1 string ?/dbs/dr1@.dat
dg_broker_config_file2 string ?/dbs/dr2@.datdg_broker_start boolean TRUESQL>SQL> alter system set dg_broker_start=false scope=both;System altered.SQL> show parameter dg_brokerNAME TYPE VALUE
dg_broker_config_file1 string ?/dbs/dr1@.dat
dg_broker_config_file2 string ?/dbs/dr2@.datdg_broker_start boolean FALSESQL>3) On the primary disable any archive destinations that are archiving to the standby:SQL> select dest_id,destination,status2 from v$archive_dest3 where 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)))
VALIDSQL> alter system set log_archive_dest_state_2=defer scope=both;System altered.SQL>4) on the standby set the dg_broker_start parameter to false:SQL> show parameter dg_brokerNAME TYPE VALUE
dg_broker_config_file1 string ?/dbs/dr1@.dat
dg_broker_config_file2 string ?/dbs/dr2@.datdg_broker_start boolean TRUESQL> alter system set dg_broker_start=false scope=both;System altered.SQL>5) On both system rename the metadata files (if they exist):oracle@bjsrv:/u03/oracle/9.2.0/dbs> mv dr1DG920.dat dr1bjdb.bakoracle@bjsrv:/u03/oracle/9.2.0/dbs> mv dr2DG920.dat dr2bjdb.backRELATED DOCUMENTS Oracle Data Guard Broker Guide
转自:
转载于:https://blog.51cto.com/lyzbg/2090691