Data Guard Fast Start Failover Reference Implementation
By AVargas-Oracle on Dec 06, 2008
This post contains a reference of parameter files and database parameters used on a healthy Data Guard Physical Standby implementation, configured with FSFO in Max Availability protection mode. This environment consistently succeeded to complete Switchover or FSFO, in case of crash, and reinstate the failed primary as soon it become available again.
The details can be found in this document:
I was motivated to write this down after I spent several hours implementing a Data Guard FSFO environment on Windows. Switchover succeeded but the broker failed to start the databases with error ORA-12514.
After some rounds of review, I was able to notice that there is a huge number of Service Requests opened with Oracle Support for the same or similar issues.
This reference of a healthy configuration may help to quickly find errors on the parameter files or broker related parameters.