![]() If you don’t want to deal with missteps, I recommend that you test your standby database to facilitate the failover or switchover process. This procedure is very useful when you have physical standby databases for testing and other purposes that require read-write access to the standby database. Also, it improves your checklist in the event of an error or disaster. Dec 20, 2012. Snapshot standby database is new Oracle 11g feature that turns a physical standby database to an open and functional database. Before this feature, in 10G, you should accomplish many steps with success. ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; 3. T his chapter steps you through the process of creating a physical standby database. SQL> ALTER DATABASE ADD STANDBY. 1 16 NO ACTIVE. ![]() By using Snapshot standby databases, redo data is not applied until you convert the snapshot standby database back into a physical standby database, and after all local updates to the snapshot standby database are discarded. Requirements The following requirements need to be met in order to create a snapshot standby. • The Data Guard environment (a primary and a physical standby) needs to be Oracle 10.2.0.1 version or higher. • The Primary and Standby databases need to be in archivelog mode (this is a default requirement for Data Guard). • Force logging should be set to TRUE (to avoid no-logging operations). • Flash Recovery Area (FRA) is required on the standby database to implement a Flashback database. • The Primary and standby are in sync at the time of the test, or the gap between primary and physical standby is nominal. Hi Sanhay and Martin. Both options are valid for 11G and later. Just keep in mind that they require Enterprise Edition version. “A snapshot standby database is a fully update-able standby database that is created by converting a physical standby database into a snapshot standby database. A snapshot Standby is open in the read-write mode and hence it is possible to process transactions independently of the primary database. At the same time, it maintains protection by continuing to receive data from the production database, archiving it for later use. Using a single command changes made while read-write mode can be discarded and quickly resynchronize the standby with the primary database.” Met.note [ID 443720.1] I haven’t tested the snapshot standby. Will do and consider creating a blog about it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2018
Categories |