How to Safely Remove a Data Guard Broker Configuration [ID 261336.1]

How to Safely Remove a Data Guard Broker Configuration [ID 261336.1]
	Modified 20-OCT-2010Type REFERENCEStatus PUBLISHED

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 Database

DGMGRL> connect sys/<Password>@<Primary Database>

- 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> alter system set dg_broker_start=false scope=both;

System altered.

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

2 from v$archive_dest

3 where target='STANDBY';

DEST_ID

----------

DESTINATION

--------------------------------------------------------------------------------

STATUS

---------

2

(DESCRIPTION=(ADDRESS_LIST = (ADDRESS=(PROTOCOL=tcp)(HOST=hasunclu2.us.oracle.co

m)(PORT=1521)))(CONNECT_DATA=(SID=DG920phy)(ORACLE_HOME=/u03/oracle/9.2.0)(SERVE

R=DEDICATED)))

VALID

SQL> 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_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> alter system set dg_broker_start=false scope=both;

System altered.

SQL>

5) On both system rename the metadata files (if they exist):

oracle@hasunclu1:/u03/oracle/9.2.0/dbs> mv dr1DG920.dat dr1DG920.back

oracle@hasunclu1:/u03/oracle/9.2.0/dbs> mv dr2DG920.dat dr2DG920.back

RELATED DOCUMENTS

--------------------

Oracle® Data Guard Broker Guide

Related

---

------------------------------------------------------------------------------

Blog： http://blog.csdn.net/tianlesoftware

网上资源： http://tianlesoftware.download.csdn.net

相关视频：http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx

DBA1 群：62697716(满); DBA2 群：62697977(满)

DBA3 群：62697850 DBA 超级群：63306533;

聊天 群：40132017

--加群需要在备注说明Oracle表空间和数据文件的关系，否则拒绝申请