ODG Physical Standby Drop

Drop Physical Standby

dgmgrl /

EDIT CONFIGURATION SET PROTECTION MODE AS MAXPERFORMANCE;

REMOVE CONFIGURATION;

If you are not using the Broker, use...ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE;

  • 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

  • Drop Standby Redo Logs from Primary database...

sqlplus / as sysdba

SELECT GROUP# FROM V$STANDBY_LOG;

ALTER DATABASE DROP STANDBY LOGFILE GROUP &group#;

Remove Broker Configuration files...

sqlplus / as sysdba

SHOW PARAMETER dg_broker_config;

exit

rm $ORACLE_HOME/dbs/dr1ORCL1.dat


The default Values for DG_BROKER_CONFIG_FILE1 and DG_BROKER_CONFIG_FILE2 are:$ORACLE_HOME/dbs/dr1<ORACLE_SID>.dat$ORACLE_HOME/dbs/dr2<ORACLE_SID>.datOr, for Windows... $ORACLE_HOME/database/dr1<ORACLE_SID>.dat$ORACLE_HOME/database/dr2<ORACLE_SID>.dat