dr scenarios dataguard

on October 10, 2008 at 1:58 pm
Posted In: Oracle Data Guard Notes (Cat)

LIVE DATABASES
==============

alter system switch logfile;
alter system switch logfile;
Shutdown all but 1 instance on all databases.
SELECT switchover_status FROM v$database;
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;
srvctl stop database -d
srvctl start instance -d -i -o mount
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=DEFER;
SELECT open_mode, database_role FROM    v$database;

STANDBY DATABASES
=================

RECOVER MANAGED STANDBY DATABASE NODELAY DISCONNECT;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN;
srvctl stop database -d
srvctl start instance -d -i -o open
SELECT open_mode, database_role FROM    v$database;
ON OLD LIVE – ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE;
ALTER SYSTEM SWITCH LOGFILE;
Restart the rest of the standby instances.

Ensure the services start up; if not then: dba/scripts/services