Converting Physical Standby to Snapshot using DGMRL

In this post, I talk about converting a physical standby tp Snapshot, for those who are not aware of what is snapshot, it is a fully updateable database, for this to happen flashback should have been enabled. Though redo transport does happens from primary to snapshot, redo is not applied until it is concerted back to physical.

DGMGRL> convert database 'mobpro_collab2' to snapshot standby;

Converting database "mobpro_collab2" to a Snapshot Standby database, please wait...
Database "mobpro_collab2" converted successfully

The snapshot is totally updateable as hown below.

SQL> select * from t;

N
---------
9999
9999
9999
9999
SQL> insert into  t values(100);
1 row created.
SQL> commit;
Commit complete.

Let us also see the entries of the alert log at the standby site
Mon Oct 26 13:14:35 2009

Setting recovery target incarnation to 3
CONVERT TO SNAPSHOT STANDBY: Complete - Database mounted as snapshot standby
Completed: alter database convert to snapshot standby
ALTER DATABASE OPEN
Data Guard Broker initializing...
Data Guard Broker initialization complete
Mon Oct 26 13:14:38 2009


We will again convert snapshot to physical.

DGMGRL> convert database 'mobpro_collab2' to physical standby;

Converting database "mobpro_collab2" to a Physical Standby database, please wait...
Operation requires shutdown of instance "mobpro" on database "mobpro_collab2"
Shutting down instance "mobpro"...
Database closed.
Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "mobpro" on database "mobpro_collab2"
Starting instance "mobpro"...
ORACLE instance started.
Database mounted.
Continuing to convert database "mobpro_collab2" ...
Operation requires shutdown of instance "mobpro" on database "mobpro_collab2"
Shutting down instance "mobpro"...
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "mobpro" on database "mobpro_collab2"
Starting instance "mobpro"...
ORACLE instance started.
Database mounted.
Database "mobpro_collab2" converted successfully