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:
DATA GUARD FSFO AND SWITCHOVER REFERENCE CONFIGURATION
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.
Comments (1)
Alejandro,
This doc references another doc, "Data Guard Broker and FSFO implementation, step-by-step". Where can I find that?
Jeff
Posted by Jeff Cena | January 15, 2009 8:56 AM
Posted on January 15, 2009 08:56