Strategies for testing Data Guard failover?
646641Aug 19 2008 — edited Aug 19 2008We are running Oracle 10g in a Data Guard environment with one primary database and one physical standby. Our system is getting ready to go into production and we would like to test a failover (we have already successfully tested switchover).
The caveats are that the test needs to be done via Oracle Grid Control, and we will need to be able to switchover back to the original primary database at the end of the test.
Are there any strategies for how to test failover in this manner?
TIA