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:
ODG-protection-group-odg-rep-rg
If you add an Oracle Data Guard broker configuration to a protection group, the 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:
ODG-configuration-name-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 ODG-configuration-name-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 3 Status and Status Messages of an Online Oracle Data Guard Replication Resource Group
|
|
|
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 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 snapshot standby.
|
Unknown
|
Unexpected error - unexpected-error
|
|
Unknown
|
The 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 the 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 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.
|
Unknown
|
A switchover is in progress
|
Self-explanatory.
|
Unknown
|
A failover is in progress
|
Self-explanatory.
|
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 ODG-configuration-name in protection group
ODG-protection-group
|
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 ODG-configuration-name
|
A switchover or failover has been performed in the Oracle Data Guard broker by using a command in the
Oracle Data Guard command-line interface (dgmgrl), and the Geographic Edition configuration
has not been updated.
|
Degraded
|
Oracle Data Guard configuration name ODG-configuration-name found does not
match ODG-configuration-name
|
|
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 Geographic Edition configuration has not been
updated.
|
Degraded
|
Oracle Data Guard configuration ODG-configuration-name 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 Geographic Edition
configuration has not been updated.
|
Degraded
|
Oracle Data Guard configuration ODG-configuration-name 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 Geographic Edition configuration has not been
updated.
|
Degraded
|
The BystandersFollowRoleChange property for the Oracle Data Guard broker
configuration Broker_Config_Name_Variable must be set to 'NONE'
|
The Oracle Data Guard broker property is not set to 'NONE'.
|
Degraded
|
Fast-start failover must be disabled for the Oracle Data Guard broker configuration
Broker_Config_Name_Variable
|
Fast-start failover is enabled.
|
Online
|
Online or replicating in replication-mode mode
|
|
|
For more information about the clresource command, see the clresource(1CL) man page.