Solaris Cluster HA-Oracle with Oracle Database using DataGuard Starts the Database Incorrectly (Doc ID 2153276.1)

Last updated on MAY 07, 2024

Applies to:

Symptoms

In a Solaris Cluster HA-Oracle configuration one can set Standby_mode and Dataguard_role according to the desired Database and Dataguard operation mode. However after a resource group switchover or a failover the Database is started in a  incorrect mode.

For example when  Dataguard_role=STANDBY and there is a switch or fail over  then the database maybe started "mounted".

To check:

Here we expect that the Database is READ ONLY.

Standby_mode

Type string. Default is LOGICAL. This property specifies the mode of the standby database. This property is used by Oracle Solaris Cluster HA
for Oracle data service only when the Dataguard_role property is set to STANDBY to determine the type of standby database. The permitted values for
this property are as follows:

• LOGICAL -> Specifies a logical standby database.
• PHYSICAL -> Specifies a physical standby database.
• SNAPSHOT -> Beginning with Oracle 11g, specifies a snapshot standby database.

Documentation: How to Change the Role of an Oracle Data Guard Instance and Oracle Solaris Cluster 4.3 Data Services Reference Manual - oracle_server(5)

Changes

There were enhancements in Oracle Datguard in newer releases with Oracle Active Data Guard, it is now possible to perform redo log applies from a Primary to a Physical Standby database and open the database for READ ONLY.

Cause