By alejandro.vargas on December 6, 2008 5:21 AM
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.
By alejandro.vargas on February 4, 2009 5:33 AM
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
By alejandro.vargas on September 11, 2009 11:29 PM
For Databases requiring normal redundancy I definitively recommend 11g instead of 10g, because the fast mirror resynchronization new feature that makes possible to reinstate a failed disk without requiring to rebuild it as is the case on 10g.
This Hands ON series move on a later lab the database to 11g to test this options. In this lab we still work with 10g.
Normal Redundancy on 10g provides protection against disk failures, but it does require for the failed disk to be reconfigured after failure.
On this lab we will simulate a disk failure and then we will restore the failed disk
Details on this document:
Normal Redundancy Resilience Test 10g
