Time for action – converting to a snapshot standby database

Perform the following steps to convert a physical standby database to a snapshot standby database:

1. To convert a physical standby database to a snapshot standby database, flashback should be enabled and the database should be brought to the MOUNT status after cancelling recovery as follows:

   SQL> select open_mode,database_role,flashback_on from v$database;
   OPEN_MODE            DATABASE_ROLE    FLASHBACK_ON
   -------------------- ---------------- ------------------
   MOUNTED              PHYSICAL STANDBY YES

2. Now process the following command to convert the physical standby database to a snapshot standby database:

   SQL> ALTER DATABASE CONVERT TO SNAPSHOT STANDBY;
   Database altered.
   SQL> 
   Wed Nov 07 20:10:27 2012
   ALTER DATABASE CONVERT TO SNAPSHOT STANDBY
   Created guaranteed restore point SNAPSHOT_STANDBY_REQUIRED_11/07/2012 20:10:27
   ........
   Standby became primary SCN: 3938237
   Wed Nov 07 20:10:29 2012
   Setting recovery target incarnation...