Data Guard for Manual Failover, Step by Step
By AVargas on Nov 14, 2010
In this post I'm showing the steps used to implement a manual failover scenario. My customer did not want to enable fast start failover but to leave the decision to failover in case of a major crash to the management team.
In the example I'm providing here I did configure flashback database with a one hour retention time so that the OS team can have this time to solve any issues on the primary, if they succeed to solve the problem in this time then the old primary can be easily reinstated as the new standby, other wise it will need to be recreated from a backup taken from the new primary
All details of this experience can be found on this document "Step by Step Configuration of a Physical Standby Database for Manual Failover"