Description
For a primary cluster, v$ob_standby_status displays the states and configurations of all standby clusters. For a standby cluster, this view is empty.
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| cluster_id | bigint(20) | NO | The unique ID of the cluster. |
| cluster_name | varchar(4096) | NO | The name of the cluster. |
| cluster_role | varchar(4096) | NO | The role of 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: * SYNC * ASYNC * NET_TIMEOUT |
| protection_level | varchar(4096) | NO | The protection mode of the cluster. Valid values: * MAXIMUM PROTECTION * MAXIMUM AVAILABILITY * RESYNCHRONIZATION * MAXIMUM 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. |