remove dataguard configuration from primary

admin

1. Put Primary Database in Maximum Performance Mode

On the Primary database, put the Database in Maximum Performance Mode (if not already):
SQL> select PROTECTION_MODE,PROTECTION_LEVEL from v$database;
SQL> ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE;

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>;


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.      

To find the location and file names of Data Guard Broker Configuration Files use:

SQL> show parameter DG_BROKER_CONFIG;