Snapshot Standby Database: Snapshot standby database receives and archives redo data but do not apply it from a primary database. Redo data received from the primary database is applied when a snapshot standby database is converted back to a physical standby database. |
Restrictions on Snapshot Standby database:
|
I have already configured physical standby database in my test environment. Operating System: OEL 6.3 64-Bit Database : Oracle Single Instance 11g R2 RDBMS Version: 11.2.0.4 Step 1: Cancel the media recovery on physical standby database. SQL> recover managed standby database cancel; Media recovery complete. Note: You can convert first and then open the database OR you can open first and then convert. It will not be an issue. Step 2: Open the physical standby database and check the database role. SQL> alter database open; Database altered. SQL> @rd NAME DB_UNIQUE_NAME DATABASE_ROLE OPEN_MODE CONTROL SWITCHOVER_STATUS ----- -------------- ---------------- ---------- --------- ----------------- DC DR PHYSICAL STANDBY MOUNTED STANDBY RECOVERY NEEDED Now convert the physical standby database to snapshot standby database and check the database role. SQL> alter database convert to snapshot standby; Database altered. SQL> @rd NAME DB_UNIQUE_NAME DATABASE_ROLE OPEN_MODE CONTROL SWITCHOVER_STATUS ----- -------------- ---------------- ---------- --------- ----------------- DC DR SNAPSHOT STANDBY READ WRITE CURRENT NOT ALLOWED Q: But what does exactly happen when we run above command of converting physical standby into snapshot standby?. SQL> alter database convert to snapshot standby; Ans: It performs below tasks:
Data Guard implicitly flashes the database back to the guaranteed restore point and automatically applies the primary database redo that was archived by the snapshot standby database since it was created. The guaranteed restore point is dropped after this process is completed. |
Thanks for reading this post ! Please comment if you like this post ! Click on FOLLOW to get future blog updates !

