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;