Note: Technical Talk being moved to:
www.nazimcricket.com/wiki


Wednesday, 18 April 2012

Convert Physical Standby to Snapshot Standby

Just some high level steps for converting a 11g Physical Standby Database to a Standby Snapshot Database and back again.

PHYSICAL STANDBY TO SNAPSHOT STANDBY

Turn on Flashback SQL> ALTER DATABASE FLASHBACK ON;

Stop Redo Log Apply SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

Convert Physical Standby to Snapshot Standby SQL> ALTER DATABASE CONVERT TO SNAPSHOT STANDBY;

Open the Database in Read/Write Mode SQL> ALTER DATABASE OPEN;

Take a note of the Snapshot if you wish SQL> SELECT name, scn, time FROM v$restore_point;

SNAPSHOT STANDBY TO PHYSICAL STANDBY

Shutdown the Database SQL> SHUTDOWN IMMEDIATE;

Mount the Database SQL> STARTUP MOUNT;

Convert Snapshot Standby to Physical Standby SQL> ALTER DATABASE CONVERT TO PHYSICAL STANDBY;

Shutdown the Database SQL> SHUTDOWN IMMEDIATE;

Startup in Nomount mode SQL> STARTUP NOMOUNT;

Mount the Physical Standby Database SQL> ALTER DATABASE MOUNT STANDBY DATABASE;

Start Redo Log Apply SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE THROUGH ALL SWITCHOVER DISCONNECT USING CURRENT LOGFILE;

SQL>exit