如何完整的去除ORACLE DG环境

How to remove a Data Guard Configuration from Primary Database (Doc ID 733794.1)

In this Document

Goal

Solution

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2]

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]

Oracle Database Cloud Schema Service - Version N/A and later

Oracle Database Exadata Express Cloud Service - Version N/A and later

Oracle Database Exadata Cloud Machine - Version N/A and later

Information in this document applies to any platform.

Goal

How to remove a Data Guard Configuration from the Primary Database after Standby Database is no longer present or activated to work as new/separate Primary (including the Steps for the Data Guard Broker).

Solution

1. Put Primary Database in Maximum Performance Mode

On the Primary database, put the Database in Maximum Performance Mode (if not already):

SQL> ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE;

or if using the Data Guard Broker:

DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXPERFORMANCE;

2. Remove Data Guard Broker Configuration

If you are using the Data Guard Broker, remove the Data Guard Broker Configuration:

DGMGRL> REMOVE CONFIGURATION;

3. Unset Data Guard-specific Initialization Parameters

Unset/Remove following Initialization Parameters from the (S)PFILE of the Primary Database:

LOG_ARCHIVE_CONFIG

DB_FILE_NAME_CONVERT

LOG_FILE_NAME_CONVERT

LOG_ARCHIVE_DEST_n pointing to the Standby Database and valid for STANDBY_LOGFILES

LOG_ARCHIVE_DEST_STATE_n

DG_BROKER_START

DG_BROKER_CONFIG_FILE1

DG_BROKER_CONFIG_FILE2

STANDBY_ARCHIVE_DEST

STANDBY_FILE_MANAGEMENT

FAL_SERVER

FAL_CLIENT

4. Drop Standby Redologs from the Primary Database

Use following Query to check for Standby Redolog Groups:

SQL> SELECT GROUP# FROM V$STANDBY_LOG;

Use following Command to Drop the Standby Redo logs:

SQL> ALTER DATABASE DROP STANDBY LOGFILE GROUP <GROUP_NUMBER>;

e.g.

SQL> alter database drop standby logfile group 3;

Drop all Standby Redolog Groups using above Command.

5. Drop the Data Guard Broker Configuration Files if used.

DG_BROKER_CONFIG_FILE1 and DG_BROKER_CONFIG_FILE2 Parameters define the Name and Location of the Data Guard Broker Configuration Files.

In Unix the default Values for DG_BROKER_CONFIG_FILE1 and DG_BROKER_CONFIG_FILE2 are:

$ORACLE_HOME/dbs/dr1<ORACLE_SID>.dat and

$ORACLE_HOME/dbs/dr2<ORACLE_SID>.dat

In Windows the default Values for DG_BROKER_CONFIG_FILE1 and DG_BROKER_CONFIG_FILE2 are:

$ORACLE_HOME/database/dr1<ORACLE_SID>.dat and

$ORACLE_HOME/database/dr2<ORACLE_SID>.dat.                                                                                                                                                                                                                          Or you could find the location and file names of Data Guard Broker Configuration Files by

SQL> show parameter DG_BROKER_CONFIG;

ocp认证培训