OceanBase

A unified distributed database ready for your transactional, analytical, and AI workloads.

Product Overview

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All

BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All

PRODUCTS

OceanBase Cloud

OceanBase Database

Tools Connectors and Middleware

QUICK START

OceanBase Cloud OceanBase Database

BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Document Feedback

v$ob_standby_status

Last Updated：2023-10-24 09:23:03 Updated

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