Purpose
v$ob_standby_status displays the status and configurations of all standby clusters for the primary cluster, and is empty for a standby cluster.
Fields
| Field |
Type |
Nullable? |
Description |
| cluster_id |
bigint(20) |
NO |
The unique ID of the cluster. |
| cluster_name |
varchar(4096) |
NO |
Cluster name |
| cluster_role |
varchar(4096) |
NO |
The role of the tenant in the cluster. Valid values: PRIMARY: indicates a primary cluster.PHYSICAL STANDBY: indicates a standby cluster. |
| cluster_status |
varchar(4096) |
NO |
The state of the cluster. Valid values: VALID: The cluster is valid.DISABLED: Data synchronization is disabled for the cluster. |
| current_scn |
bigint(20) |
NO |
The current system change number (SCN) of the cluster. |
| rootservice_list |
varchar(4096) |
NO |
The list of RootServers in the cluster. |
| redo_transport_options |
varchar(4096) |
NO |
The transmission mode of redo logs of the current standby cluster. Valid values: SYNCASYNCNET_TIMEOUT |
| protection_level |
varchar(4096) |
NO |
The protection mode of the cluster. Valid values: MAXIMUM PROTECTIONMAXIMUM AVAILABILITYRESYNCHRONIZATIONMAXIMUM PERFORMANCE |
| synchronization_status |
varchar(4096) |
NO |
The synchronization status of the standby cluster and the cause of asynchronization. Valid values: OK: indicates that the standby cluster is synchronous with the primary cluster.NOT AVAILABLE: indicates that the synchronization status cannot be confirmed.CLUSTER VERSION NOT MATCH: indicates that the versions of the primary and standby clusters do not match.SYS SCHEMA NOT SYNC: indicates that the schemas of the system tenant are asynchronous.PARTITION LOG NOT SYNC: indicates that some partition logs are asynchronous.REPLICA NOT ENOUGH: indicates that some partitions do not have enough replicas to meet the majority condition.FAILOVER INFO NOT LATEST: indicates that the FAILOVER INFO is asynchronous.ALL CLUSTER INFO NOT SYNC: indicates that the cluster information is asynchronous.REPLICA IN RESTORE: indicates that one or more replicas are just created and being restored.CHECK USER SCHEMA SYNC STATUS: indicates that the schemas of the user tenant are asynchronous.CHECK FREEZE INFO SYNC STATUS: indicates that the freeze information is asynchronous.CHECK MERGE STATUS: indicates that the status of the daily major compaction is not correct.CHECK ALL SCHEMA EFFECTIVE: indicates that not all schemas synchronized from the standby cluster have taken effect. |
