Testing a Physical Standby Database in Oracle 10g
Posted by Marcelo Lopes on Jan 21, 2009
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.
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.
