Posts

Showing posts from November, 2022

Convert physical standby database to snapshot standby database

Image
               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;