My Oracle Support Banner

Understanding the Limitations while Implementing Oracle Fail Safe (OFS) & Data Guard (DG) (Doc ID 2437037.1)

Last updated on APRIL 03, 2020

Applies to:

Oracle Fail Safe - Version 3.4.1 and later
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 18.3.0.0.0 [Release 10.2 to 18]
Information in this document applies to any platform.

Goal

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample schema(s),
Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual environments, actual persons, living or dead, is
purely coincidental and not intended in any manner.

For the purposes of this document, the following fictitious environment is used as an example to describe the procedure:

Database Name: ORCL
Node Names:  Prim-Node1, Prim-Node2, DR-Node1, DR-Node2
Cluster Names:  PRI-Cluster, DR-Cluster 

****************

Understanding the known issues while implementing Data Guard (DG) in Oracle Fail Safe (OFS) environment.

 

Oracle Fail Safe (OFS):

         OFS run on windows cluster and takes responsibility to perform cold failover of register resources to another cluster node along with Microsoft cluster. OFS does polling frequently
to check the resource availability and its state to bring the resource to the desired state if necessary.

   Fail Safe document:
       https://docs.oracle.com/cd/E59133_01/doc.411/e57057/ofs_db.htm#OFSCN213

Oracle Data Guard (DG):

         Oracle data guard is used to maintain the copy of oracle database in other site for disaster recovery purpose. If the primary database unavailable due to issues, then standby database
can be brought up for the business.

   Standby documentation:
       https://docs.oracle.com/database/121/SBYDB/concepts.htm#SBYDB00010

Important Note:

Both Oracle Data Guard and Oracle Fail Safe have the ability to change the state of the database (start, stop and alter the database).

While Fail Safe shuts down the database Data Guard would not know that it is planned shutdown and vice versa (while Data Guard shuts down the database, Fail Safe would not know
that it is planned activity).

When performing the planned activity in Fail Safe it is better to disable the features of Oracle Data Guard and vice versa, this will eliminate many issues will arrive due to product limitations.

  1. When Data Guard stops the database which is being managed by Oracle Fail Safe, OFS starts the database back to online mode because OFS will not be aware that it
    is maintenance activity started from Data Guard.
  2. When Fail Safe manager moves the resources to next available node of the same cluster Broker will not be intimated by OFS so Broker may take an action to perform
    failover if FSFO enabled

So, due to communication limitation, it will lead to an issue.

      Below is the sample configuration model.   

     The database configured in PRI-Cluster will run in Prim-Node1 OR Prim-Node2 in a given point of time and database can be failed over to next available server(within cluster)
using Fail Safe and same applies for another cluster (DR-Cluster) as well.

     Precautions to be taken to minimize the issues during maintenance activity in Fail Safe or Data Guard.

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 Situation 1: Planned switchover/failover through DGMGRL OR Manual switchover
 Situation 2: If there is FSFO enabled in DGMGRL & Databases are being managed in OFS
 Situation 3: If there is FSFO enabled in Data Guard and manually we need to move the resources to next available node in the same cluster
 Situation 4: Switchover when one or mode nodes are down
 Conclusion:
 Suggested configuration:
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.