Convert physical standby database to snapshot standby database

            Convert physical standby database to snapshot standby database steps


1.alter database recover managed standby database cancel;
2.shutdown immediate;
3.startup mount;
4.alter database convert to snapshot standby;
5.shutdown immediate;
6.startup;







Steps to revert from Snapshot standby to physical standby database 

1.shutdown immediate;
2.startup mount;
3.alter database convert to physical standby;
4.shutdown immediate;
5.startup mount;
6.alter database recover managed standby database disconnect from session;