X

Alejandro Vargas' Blog

Data Guard Fast Start Failover Reference Implementation

Alejandro Vargas
Technical Leader, ACS Global Delivery, Infrastructure & BigData

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.

Join the discussion

Comments ( 1 )
  • Jeff Cena Thursday, January 15, 2009
    Alejandro,
    This doc references another doc, "Data Guard Broker and FSFO implementation, step-by-step". Where can I find that?
    Jeff
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha