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:
https://communities.oracle.com/portal/server.pt/community/high_availability_data_guard/302
SOLUTION
1. Put Primary Database in Maximum Performance Mode
On the Primary database, put the Database in Maximum Performance Mode (if not already):
or if using the Data Guard Broker:
2. Remove Data Guard Broker Configuration
If you are using the Data Guard Broker, remove the Data Guard Broker Configuration:
3. Unset Data Guard-specific Initialization Parameters
Unset/Remove following Initialization Parameters from the (S)PFILE of the Primary Database:
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:
Use following Command to Drop the Standby Redo logs:
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.
$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