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-1 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
|
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 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 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
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 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.