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]

Information in this document applies to any platform.

***Checked for relevance on 10-Dec-2015*** 

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).

In case you may want or need more about your current topic - please also access the Data Guard Community of Customers and Oracle Specialists directly via:

 

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;