Sun Cluster Geographic Edition Data Replication Guide for Oracle Data Guard

Displaying a Detailed Oracle Data Guard Runtime Status

One replication resource group exists for each protection group. The name of the replication resource group conforms to the following format:


ODGprotectiongroupname-odg-rep-rg

If you add an Oracle Data Guard Broker configuration to a protection group, the Sun Cluster Geographic Edition software creates a resource for that configuration. This resource monitors and displays the status of replication for the Oracle Data Guard Broker configuration. The name of each resource conforms to the following format:


ODGConfigurationName-odg-rep-rs

You can monitor the state of the replication resource to give you the overall status of replication. Use the clresource status command as follows to obtain the State and Status Message values for the replication status of the Oracle Data Guard Broker configuration:


phys-node-n# clresource status -v ODGConfigurationName-odg-rep-rs

The State is Online while the resource is online.

The following table describes the Status and Status Message values that are returned by the clresource status command when the State of the Oracle Data Guard replication resource group is Online.

Table 2–1 Status and Status Messages of an Online Oracle Data Guard Replication Resource Group

Status 

Status Message 

Possible Causes 

Faulted

Program program-name returned a nonzero exit code

 

Faulted

Protection mode "replication-mode" given for local database database does not match configured value "replication-mode"

The Oracle Data Guard Broker configuration has been changed by using the Oracle Data Guard command-line interface (dgmgrl) and has not been updated in Sun Cluster Geographic Edition.

Faulted

Database database does not exist in the configured Oracle Data Guard database list "List-of-databases"

The database has been deleted from the Oracle Data Guard Broker configuration using the Oracle Data Guard command-line interface (dgmgrl).

Faulted

Oracle errors "List-of-ORA-xxxxx-errors" were found in the Oracle Data Guard broker (dgmgrl) output when connecting by using "connect-string"

 

Faulted

Role "role" given for database database does not match role "role" configured for Oracle Data Guard

The database might have been changed from a physical standby to a logical standby, or vice versa. 

Unknown

Unexpected error - unexpected-error

 

Unknown

Oracle Data Guard broker (dgmgrl connect-string) did not complete a response to the command "command-string" within "number" seconds and was timed out.

The Oracle Data Guard command-line interface (dgmgrl) did not respond to the show configuration command within the specified time, or Oracle Data Guard Broker was busy performing a health check during this period.

Unknown

Password or connect name (connect-string) for remote cluster is incorrect

The sysdba_username, sysdba_password, local_db_service_name, or remote_db_service_name parameter does not match the information that is maintained by the Sun Cluster Geographic Edition software.

Unknown

File filename does not exist

A temporary internal file that is used by the Oracle Data Guard module was deleted before it could be read. 

Degraded

Program program-name failed to read the Cluster Configuration Repository (CCR)

One of the programs that is used to retrieve information from the CCR failed. 

Degraded

Failed to get password for sysdba user name for Oracle Data Guard configuration ODGConfigurationName in protection group ODGprotectiongroupname

The field for the sysdba_password was not found in the Cluster Configuration Repository (CCR) or was longer than expected.

Degraded

Local cluster cluster-name is not primary for Oracle Data Guard configuration ODGConfigurationName

A switchover or failover has been performed in Oracle Data Guard Broker by using a command in the Oracle Data Guard command-line interface (dgmgrl), and the Sun Cluster Geographic Edition configuration has not been updated.

Degraded

Oracle Data Guard configuration name ODGConfigurationName found does not match ODGConfigurationName

 

Degraded

Database database-name is in the disabled state

A database has been disabled in the Oracle Data Guard Broker using a command in the Oracle Data Guard command-line interface (dgmgrl), and the Sun Cluster Geographic Edition configuration has not been updated.

Degraded

Oracle Data Guard configuration ODGConfigurationName is disabled on cluster cluster-name

The standby database in the Oracle Data Guard Broker configuration has been disabled by using a command in the Oracle Data Guard command-line interface (dgmgrl), and the Sun Cluster Geographic Edition configuration has not been updated.

Degraded

Oracle Data Guard configuration ODGConfigurationName is disabled

The Oracle Data Guard Broker configuration has been disabled by using a command in the Oracle Data Guard command-line interface (dgmgrl), and the Sun Cluster Geographic Edition configuration has not been updated.

Online

Online or replicating in replication-mode mode

 

For more information about the clresource command, see the clresource(1CL) man page.