Convert Physical standby to Snap shot standby database

Snap Shot Standby database ( 11gR2 Feature ):

-- A physical standby database which is in OPEN ( READ WRITE ) mode is called as Snap Shot Standby datase.

-- We can convert the physical standby to Snap shot standby database.

-- Advantage of Snap shot standby is that We don't require an another server to create a clone database. Some standby database can be used as a clone database by converting it into Snap shot standby database.


STANDBY DB SERVER:

sql>select open_mode, protection_mode, database_role from v$database;

sql>!

$ps -ef | grep mrp

$exit

sql>recover managed standby database cancel;    ( STOP MRP )

sql>!

$ps -ef | grep mrp

$exit

sql>alter database convert to snapshot standby;

sql>select open_mode, protection_mode, database_role from v$database;

sql>alter database open;

sql>select open_mode, protection_mode, database_role from v$database;

sql>recover managed standby database disconnect from session using current logfile;     (START MRP)


--- Now we can perform all DDL & DML operations on this database.

Convert Snapshot standby to Physical standby database

sql>select open_mode, protection_mode, database_role from v$database;


sql>shut immediate

sql>startup mount

sql>recover managed standby database disconnect from session using current logfile;


sql>select open_mode, protection_mode, database_role from v$database;