How To Manually Open The Standby Database When The Primary Is Lost
By AVargas on Feb 04, 2009
This post explains how to manually convert the Physical Standby into the Primary database, when the Primary is not available anymore.
The procedure is very simple, still is convenient to have it available so that in the stress situation of a production crash we can implement it without problems.
Personally I prefer to work harder at the implementation stage and build an infrastructure strong enough to be configured using DG Broker, Observer and Fast Start Failover.
Step by Step details of manually converting the standby into the new primary can be found on this file How to open the standby when the primary is lost