In the previous post, we can read about Snapshot Standby Overview. In this post, we can convert to Snapshot Standby.

Prerequisites :

Physical Standby Database is already created and synchronized with Primary Database .

Database Details :

Step 1: Check Primary database :

Step 2 : Check Standby Database :

Step 3 : Stop recovery.

Step 4 : Convert physical standby to snapshot standby using following command:

check alert log

View Snapshot Database Information :

Step 5 : Check role of snapshot 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.