Embedded Files
Drop Physical Standby
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
Page updated
Google Sites
Report abuse