How to remove Data Guard Broker Configuration

Below are the steps to be followed (including those for the Data Guard Broker) to remove Data Guard Configuration from the Primary Database when the Standby Database has been deactivated or converted into a new or separate Primary.

1. Put Primary Database in Maximum Performance Mode:

   SQL> ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE;

     OR using the Data Guard Broker :

   DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXPERFORMANCE;

2. Remove Data Guard Broker Configuration:

   DGMGRL> REMOVE CONFIGURATION;

3. Remove Data Guard-specific Initialization Parameters from Spfile and pfile of the primary database.
4. Drop Standby Redologs from the Primary Database:

   Example:
   SQL> SELECT GROUP# FROM V$STANDBY_LOG;
   SQL> ALTER DATABASE DROP STANDBY LOGFILE GROUP <GROUP_NUMBER>;

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

   ===On windows
   $ORACLE_HOME/database/dr1<ORACLE_SID>.dat and
   $ORACLE_HOME/database/dr2<ORACLE_SID>.dat.
    ===On Linux
   $ORACLE_HOME/dbs/dr1<ORACLE_SID>.dat and
   $ORACLE_HOME/dbs/dr2<ORACLE_SID>.dat
    ===And  To find the location and file names of Data Guard Broker Configuration Files use:
   SQL> show parameter DG_BROKER_CONFIG;