In the previous post, we convert Physical Standby to Snapshot Standby . In this post, we can convert Snapshot Standby to Physical Standby.

Prerequisites : Snapshot database is already exists

Primary Database Snapshot Standby database
mgr mgr

Step 1 : Check Primary Database Information :

Step 2 : Check Snapshot Database Information :

Step 3 : Shut down standby database  :

Step 4 : Start standby database in mount state :

Step 5 : Convert database to physical standby database :

Step 6 : View information of physical standby database :

Stay tuned for More articles on Oracle DataGuard

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.