How to Convert a Snapshot Standby back to Physical Standby with SQL Plus ?

The Redo data received while the database was a snapshot standby database will be automatically applied when Redo Apply is started.
Note:
A snapshot standby database must be opened at least once in read-write mode before it can be converted into a physical standby database.

Connect to the Stanbdy DB, shut it down and mount it:

SQL> shutdown immediate;

SQL> startup mount;

Convert the DB.

SQL>  ALTER DATABASE CONVERT TO PHYSICAL STANDBY;

Shutdown and mount it again:

SQL> shutdown immediate;

SQL> startup mount;

Finally, enable recovery mode:

SQL>  ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;

Tweet

Related Posts You might be Interested:

Do you like this post? Please share this article.

HTML Link Code:

<a href="https://marthadba.blogspot.com/2016/03/how-to-convert-snapshot-standby-back-to.html">How to Convert a Snapshot Standby back to Physical Standby with SQL Plus ?</a>

• email
• facebook
• linkedin
• twitter
• reddit
• google+