oceanbase.DBA_OB_SYNC_STANDBY_DEST - OceanBase 数据库 V4.4.2 | OceanBase 文档中心

文档反馈

分布式版-V4.4.2LTS

What's New
简介
快速上手
应用开发
部署
升级
数据迁移
管理数据库
AP
AI
生态集成
实践教程
参考指南
- 系统原理
- 系统管理
- 数据库对象管理
- 数据库设计规范和约束
- SQL 参考
- PL 参考
- 系统视图
  - 系统视图概述
  - 系统视图总览
  - V3.x 与 V4.x 视图变更
  - SYS 租户系统视图
    - 字典视图
      - information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS
      - information_schema.CHARACTER_SETS
      - information_schema.CHECK_CONSTRAINTS
      - information_schema.COLLATION_CHARACTER_SET_APPLICABILITY
      - information_schema.COLLATIONS
      - information_schema.COLUMN_PRIVILEGES
      - information_schema.COLUMNS
      - information_schema.ENGINES
      - information_schema.events
      - information_schema.GLOBAL_STATUS
      - information_schema.GLOBAL_VARIABLES
      - information_schema.KEY_COLUMN_USAGE
      - information_schema.PARAMETERS
      - information_schema.PARTITIONS
      - information_schema.PROCESSLIST
      - information_schema.QUERY_RESPONSE_TIME
      - information_schema.REFERENTIAL_CONSTRAINTS
      - information_schema.role_table_grants
      - information_schema.role_column_grants
      - information_schema.role_routine_grants
      - information_schema.ROUTINES
      - information_schema.SCHEMA_PRIVILEGES
      - information_schema.SCHEMATA
      - information_schema.SESSION_STATUS
      - information_schema.SESSION_VARIABLES
      - information_schema.STATISTICS
      - information_schema.ST_GEOMETRY_COLUMNS
      - information_schema.ST_SPATIAL_REFERENCE_SYSTEMS
      - information_schema.TABLE_CONSTRAINTS
      - information_schema.TABLE_PRIVILEGES
      - information_schema.TABLES
      - information_schema.TRIGGERS
      - information_schema.USER_PRIVILEGES
      - information_schema.VIEW_TABLE_USAGE
      - information_schema.VIEWS
      - mysql.columns_priv
      - mysql.db
      - mysql.default_roles
      - mysql.help_category
      - mysql.help_keyword
      - mysql.help_relation
      - mysql.help_topic
      - mysql.proc
      - mysql.procs_priv
      - mysql.role_edges
      - mysql.time_zone
      - mysql.time_zone_name
      - mysql.time_zone_transition
      - mysql.time_zone_transition_type
      - mysql.user
      - oceanbase.ALL_OB_EXTERNAL_TABLE_FILES
      - oceanbase.CDB_CKPT_HISTORY
      - oceanbase.CBA_SCHEDULER_RUNNING_JOBS
      - oceanbase.CDB_OB_DATABASE_PRIVILEGE
      - oceanbase.CDB_IND_COLUMNS
      - oceanbase.CDB_IND_PARTITIONS
      - oceanbase.CDB_IND_SUBPARTITIONS
      - oceanbase.CDB_SCHEDULER_JOBS
      - CDB_INDEX_USAGE
      - oceanbase.CDB_INDEXES
      - oceanbase.CDB_MVIEW_DEPS
      - CDB_MVIEW_LOGS
      - oceanbase.CDB_MVIEW_RUNNING_JOBS
      - CDB_MVIEWS
      - CDB_MVREF_CHANGE_STATS
      - CDB_MVREF_RUN_STATS
      - CDB_MVREF_STATS
      - CDB_MVREF_STATS_PARAMS
      - CDB_MVREF_STATS_SYS_DEFAULTS
      - CDB_MVREF_STMT_STATS
      - oceanbase.CDB_OB_ACCESS_POINT
      - oceanbase.CDB_OB_AI_MODEL_ENDPOINTS
      - oceanbase.CDB_OB_AI_MODELS
      - oceanbase.CDB_OB_LS_ARB_REPLICA_TASKS
      - oceanbase.CDB_OB_ARCHIVE_DEST
      - oceanbase.CDB_OB_ARCHIVELOG
      - oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES
      - oceanbase.CDB_OB_ARCHIVELOG_SUMMARY
      - oceanbase.CDB_OB_AUTO_INCREMENT
      - CDB_OB_AUX_STATISTICS
      - oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY
      - oceanbase.CDB_OB_BACKUP_DELETE_JOBS
      - oceanbase.CDB_OB_BACKUP_DELETE_POLICY
      - oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY
      - oceanbase.CDB_OB_BACKUP_DELETE_TASKS
      - oceanbase.CDB_OB_BACKUP_JOB_HISTORY
      - oceanbase.CDB_OB_BACKUP_JOBS
      - oceanbase.CDB_OB_BACKUP_PARAMETER
      - oceanbase.CDB_OB_BACKUP_SET_FILES
      - oceanbase.CDB_OB_BACKUP_STORAGE_INFO
      - oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY
      - oceanbase.CDB_OB_BACKUP_TASK_HISTORY
      - oceanbase.CDB_OB_BACKUP_TASKS
      - oceanbase.CDB_OB_BACKUP_VALIDATE_JOBS
      - oceanbase.CDB_OB_BACKUP_VALIDATE_JOB_HISTORY
      - oceanbase.CDB_OB_BACKUP_VALIDATE_TASKS
      - oceanbase.CDB_OB_BACKUP_VALIDATE_TASK_HISTORY
      - oceanbase.CDB_OB_BALANCE_JOB_HISTORY
      - oceanbase.CDB_OB_BALANCE_JOBS
      - oceanbase.CDB_OB_BALANCE_TASK_HISTORY
      - oceanbase.CDB_OB_BALANCE_TASKS
      - oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO
      - oceanbase.CDB_OB_CCL_RULES
      - oceanbase.CDB_OB_CS_REPLICA_STATS
      - oceanbase.CDB_OB_DATA_DICTIONARY_IN_LOG
      - oceanbase.CDB_OB_DATABASES
      - oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY
      - oceanbase.CDB_OB_DYNAMIC_PARTITION_TABLES
      - oceanbase.CDB_OB_EXTERNAL_TABLE_FILES
      - oceanbase.CDB_OB_FREEZE_INFO
      - oceanbase.CDB_OB_IMPORT_TABLE_JOB_HISTORY
      - oceanbase.CDB_OB_IMPORT_TABLE_JOBS
      - oceanbase.CDB_OB_IMPORT_TABLE_TASK_HISTORY
      - oceanbase.CDB_OB_IMPORT_TABLE_TASKS
      - oceanbase.CDB_OB_KV_TTL_TASK_HISTORY
      - oceanbase.CDB_OB_KV_TTL_TASKS
      - oceanbase.CDB_OB_LOG_RESTORE_SOURCE
      - oceanbase.CDB_OB_LS
      - oceanbase.CDB_OB_LS_ARB_REPLICA_TASK_HISTORY
      - oceanbase.CDB_OB_LS_HISTORY
      - oceanbase.CDB_OB_LS_LOCATIONS
      - oceanbase.CDB_OB_LS_LOG_ARCHIVE_PROGRESS
      - oceanbase.CDB_OB_LS_REPLICA_TASKS
      - oceanbase.CDB_OB_LS_REPLICA_TASK_HISTORY
      - oceanbase.CDB_OB_MAJOR_COMPACTION
      - oceanbase.CDB_OB_OBJECT_BALANCE_WEIGHT
      - oceanbase.CDB_OB_RECOVER_TABLE_JOB_HISTORY
      - oceanbase.CDB_OB_RECOVER_TABLE_JOBS
      - oceanbase.CDB_OB_SERVICES
      - oceanbase.CDB_OB_RESTORE_HISTORY
      - oceanbase.CDB_OB_RESTORE_PROGRESS
      - oceanbase.CDB_OB_RSRC_DIRECTIVES
      - oceanbase.CDB_OB_SENSITIVE_COLUMNS
      - oceanbase.CDB_OB_SENSITIVE_RULE_PLAINACCESS_USERS
      - oceanbase.CDB_OB_SENSITIVE_RULES
      - oceanbase.CDB_OB_SERVER_SPACE_USAGE
      - oceanbase.CDB_OB_SPACE_USAGE
      - oceanbase.CDB_OB_SYS_VARIABLES
      - oceanbase.CDB_OB_STORAGE_IO_USAGE
      - oceanbase.CDB_OB_SPM_EVO_RESULT
      - oceanbase.CDB_OB_SYNC_STANDBY_DEST
      - oceanbase.CDB_OB_TABLE_LOCATIONS
      - oceanbase.CDB_OB_TABLEGROUP_PARTITIONS
      - oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS
      - oceanbase.CDB_OB_TABLEGROUP_TABLES
      - oceanbase.CDB_OB_TABLEGROUPS
      - oceanbase.CDB_OB_TABLET_CHECKSUM_ERROR_INFO
      - oceanbase.CDB_OB_TABLET_REPLICAS
      - oceanbase.CDB_OB_TABLET_TO_LS
      - oceanbase.CDB_OB_TABLE_SPACE_USAGE
      - oceanbase.CDB_OB_TEMP_FILES
      - oceanbase.CDB_OB_TENANT_EVENT_HISTORY
      - oceanbase.CDB_OB_TENANT_FLASHBACK_LOG_SCN
      - oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS
      - oceanbase.CDB_OB_TRANSFER_PARTITION_TASK_HISTORY
      - oceanbase.CDB_OB_TRANSFER_TASK_HISTORY
      - oceanbase.CDB_OB_TRANSFER_TASKS
      - oceanbase.CDB_OB_USERS
      - oceanbase.CDB_OB_VECTOR_INDEX_TASKS
      - oceanbase.CDB_OB_VECTOR_INDEX_TASK_HISTORY
      - oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION
      - oceanbase.CDB_OBJECTS
      - oceanbase.CDB_PART_INDEXES
      - oceanbase.CDB_PART_KEY_COLUMNS
      - oceanbase.CDB_PART_TABLES
      - oceanbase.CDB_SCHEDULER_JOB_RUN_DETAILS
      - oceanbase.CDB_SUBPART_KEY_COLUMNS
      - oceanbase.CDB_SUBPARTITION_TEMPLATES
      - oceanbase.CDB_TAB_COL_STATISTICS
      - oceanbase.CDB_TAB_COLS
      - oceanbase.CDB_TAB_COLS_V$
      - oceanbase.CDB_TAB_PARTITIONS
      - oceanbase.CDB_TAB_SUBPARTITIONS
      - oceanbase.CDB_TABLES
      - oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY
      - oceanbase.CDB_WR_CONTROL
      - oceanbase.CDB_WR_EVENT_NAME
      - oceanbase.CDB_WR_RES_MGR_SYSSTAT
      - oceanbase.CDB_WR_SNAPSHOT
      - oceanbase.CDB_WR_SQL_PLAN
      - oceanbase.CDB_WR_SQLSTAT
      - oceanbase.CDB_WR_SQLTEXT
      - oceanbase.CDB_WR_STATNAME
      - oceanbase.CDB_WR_SYS_TIME_MODEL
      - oceanbase.CDB_WR_SYSSTAT
      - oceanbase.CDB_WR_SYSTEM_EVENT
      - oceanbase.CDB_OB_EXTERNAL_RESOURCES
      - oceanbase.DBA_DB_LINKS
      - oceanbase.DBA_IND_PARTITIONS
      - oceanbase.DBA_IND_STATISTICS
      - oceanbase.DBA_IND_SUBPARTITIONS
      - oceanbase.DBA_INDEX_USAGE
      - oceanbase.DBA_MVIEW_DEPS
      - oceanbase.DBA_JAVA_POLICY
      - oceanbase.DBA_MVIEW_LOGS
      - oceanbase.DBA_MVIEW_RUNNING_JOBS
      - oceanbase.DBA_MVIEWS
      - oceanbase.DBA_MVREF_CHANGE_STATS
      - oceanbase.DBA_MVREF_RUN_STATS
      - oceanbase.DBA_MVREF_STATS
      - oceanbase.DBA_MVREF_STATS_PARAMS
      - oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS
      - oceanbase.DBA_MVREF_STMT_STATS
      - oceanbase.DBA_OB_ACCESS_POINT
      - oceanbase.DBA_OB_AI_MODEL_ENDPOINTS
      - oceanbase.DBA_OB_AI_MODELS
      - oceanbase.DBA_OB_ARBITRATION_SERVICE
      - oceanbase.DBA_OB_ARCHIVE_DEST
      - oceanbase.DBA_OB_ARCHIVELOG
      - oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES
      - oceanbase.DBA_OB_ARCHIVELOG_SUMMARY
      - oceanbase.DBA_OB_AUTO_INCREMENT
      - DBA_OB_AUX_STATISTICS
      - oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY
      - oceanbase.DBA_OB_BACKUP_DELETE_JOBS
      - oceanbase.DBA_OB_BACKUP_DELETE_POLICY
      - oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY
      - oceanbase.DBA_OB_BACKUP_DELETE_TASKS
      - oceanbase.DBA_OB_BACKUP_JOB_HISTORY
      - oceanbase.DBA_OB_BACKUP_JOBS
      - oceanbase.DBA_OB_BACKUP_PARAMETER
      - oceanbase.DBA_OB_BACKUP_SET_FILES
      - oceanbase.DBA_OB_BACKUP_STORAGE_INFO
      - oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY
      - oceanbase.DBA_OB_BACKUP_TASK_HISTORY
      - oceanbase.DBA_OB_BACKUP_TASKS
      - oceanbase.DBA_OB_BACKUP_VALIDATE_JOBS
      - oceanbase.DBA_OB_BACKUP_VALIDATE_JOB_HISTORY
      - oceanbase.DBA_OB_BACKUP_VALIDATE_TASKS
      - oceanbase.DBA_OB_BACKUP_VALIDATE_TASK_HISTORY
      - oceanbase.DBA_OB_BALANCE_JOB_HISTORY
      - oceanbase.DBA_OB_BALANCE_JOBS
      - oceanbase.DBA_OB_BALANCE_TASK_HISTORY
      - oceanbase.DBA_OB_BALANCE_TASKS
      - oceanbase.DBA_OB_CLUSTER_EVENT_HISTORY
      - oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL
      - oceanbase.DBA_OB_CCL_RULES
      - oceanbase.DBA_OB_CS_REPLICA_STATS
      - oceanbase.DBA_OB_DATA_DICTIONARY_IN_LOG
      - oceanbase.DBA_OB_DATABASE_PRIVILEGE
      - oceanbase.DBA_OB_DATABASES
      - oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY
      - oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES
      - oceanbase.DBA_OB_EXTERNAL_TABLE_FILES
      - oceanbase.DBA_OB_EXTERNAL_RESOURCES
      - DBA_OB_FORMAT_OUTLINES
      - oceanbase.DBA_OB_FREEZE_INFO
      - oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY
      - oceanbase.DBA_OB_IMPORT_TABLE_JOBS
      - oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY
      - oceanbase.DBA_OB_IMPORT_TABLE_TASKS
      - oceanbase.DBA_OB_KV_TTL_TASK_HISTORY
      - oceanbase.DBA_OB_KV_TTL_TASKS
      - oceanbase.DBA_OB_LOG_RESTORE_SOURCE
      - oceanbase.DBA_OB_LS
      - oceanbase.DBA_OB_LS_ARB_REPLICA_TASKS
      - oceanbase.DBA_OB_LS_ARB_REPLICA_TASK_HISTORY
      - oceanbase.DBA_OB_LS_HISTORY
      - oceanbase.DBA_OB_LS_LOCATIONS
      - oceanbase.DBA_OB_LS_LOG_ARCHIVE_PROGRESS
      - oceanbase.DBA_OB_LS_REPLICA_TASKS
      - oceanbase.DBA_OB_LS_REPLICA_TASK_HISTORY
      - oceanbase.DBA_OB_MAJOR_COMPACTION
      - oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY
      - oceanbase.DBA_OB_OUTLINES
      - oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY
      - oceanbase.DBA_OB_SERVICES
      - oceanbase.DBA_OB_RECOVER_TABLE_JOBS
      - oceanbase.DBA_OB_RESOURCE_POOLS
      - oceanbase.DBA_OB_RESTORE_HISTORY
      - oceanbase.DBA_OB_RESTORE_PROGRESS
      - oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY
      - oceanbase.DBA_OB_RSRC_IO_DIRECTIVES
      - oceanbase.DBA_OB_RSRC_DIRECTIVES
      - oceanbase.DBA_OB_SEQUENCE_OBJECTS
      - oceanbase.DBA_OB_SERVER_EVENT_HISTORY
      - oceanbase.DBA_OB_SERVER_JOBS
      - oceanbase.DBA_SCHEDULER_RUNNING_JOBS
      - oceanbase.DBA_OB_SERVERS
      - oceanbase.DBA_OB_STORAGE_IO_USAGE
      - oceanbase.DBA_OB_SYNC_STANDBY_DEST
      - oceanbase.DBA_OB_SYS_VARIABLES
      - oceanbase.DBA_OB_SPM_EVO_RESULT
      - oceanbase.DBA_OB_TABLE_LOCATIONS
      - oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY
      - oceanbase.DBA_OB_TABLE_STAT_STALE_INFO
      - oceanbase.DBA_OB_TABLEGROUP_PARTITIONS
      - oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS
      - oceanbase.DBA_OB_TABLEGROUP_TABLES
      - oceanbase.DBA_OB_TABLEGROUPS
      - oceanbase.DBA_OB_TABLET_REPLICAS
      - oceanbase.DBA_OB_TABLET_TO_LS
      - oceanbase.DBA_OB_TASK_OPT_STAT_GATHER_HISTORY
      - oceanbase.DBA_OB_TEMP_FILES
      - oceanbase.DBA_OB_TENANT_EVENT_HISTORY
      - oceanbase.DBA_OB_TENANT_FLASHBACK_LOG_SCN
      - oceanbase.DBA_OB_TENANT_JOBS
      - oceanbase.DBA_OB_TENANTS
      - oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS
      - oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY
      - oceanbase.DBA_OB_TRANSFER_TASK_HISTORY
      - oceanbase.DBA_OB_TRANSFER_TASKS
      - DBA_OB_TRUSTED_ROOT_CERTIFICATE
      - oceanbase.DBA_OB_UNIT_CONFIGS
      - oceanbase.DBA_OB_UNIT_JOBS
      - oceanbase.DBA_OB_UNITS
      - oceanbase.DBA_OB_USER_DEFINED_RULES
      - oceanbase.DBA_OB_USERS
      - oceanbase.DBA_OB_VECTOR_INDEX_TASKS
      - oceanbase.DBA_OB_VECTOR_INDEX_TASK_HISTORY
      - oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION
      - oceanbase.DBA_OB_ZONES
      - oceanbase.DBA_OBJECTS
      - oceanbase.DBA_PART_COL_STATISTICS
      - oceanbase.DBA_PART_HISTOGRAMS
      - oceanbase.DBA_PART_INDEXES
      - oceanbase.DBA_PART_KEY_COLUMNS
      - oceanbase.DBA_PART_TABLES
      - oceanbase.DBA_RECYCLEBIN
      - oceanbase.DBA_RSRC_CONSUMER_GROUPS
      - oceanbase.DBA_RSRC_GROUP_MAPPINGS
      - oceanbase.DBA_RSRC_PLAN_DIRECTIVES
      - oceanbase.DBA_RSRC_PLANS
      - oceanbase.DBA_SCHEDULER_JOBS
      - oceanbase.DBA_SCHEDULER_JOB_RUN_DETAILS
      - oceanbase.DBA_SCHEDULER_WINDOWS
      - oceanbase.DBA_SEQUENCES
      - oceanbase.DBA_SQL_MANAGEMENT_CONFIG
      - oceanbase.DBA_SQL_PLAN_BASELINES
      - oceanbase.DBA_SUBPART_COL_STATISTICS
      - oceanbase.DBA_SUBPART_HISTOGRAMS
      - oceanbase.DBA_SUBPART_KEY_COLUMNS
      - oceanbase.DBA_SUBPARTITION_TEMPLATES
      - oceanbase.DBA_TAB_COL_STATISTICS
      - oceanbase.DBA_TAB_HISTOGRAMS
      - oceanbase.DBA_TAB_MODIFICATIONS
      - oceanbase.DBA_TAB_PARTITIONS
      - oceanbase.DBA_TAB_STATISTICS
      - oceanbase.DBA_TAB_STATS_HISTORY
      - oceanbase.DBA_TAB_SUBPARTITIONS
      - oceanbase.DBA_TABLES
      - oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY
      - oceanbase.DBA_WR_CONTROL
      - oceanbase.DBA_WR_EVENT_NAME
      - oceanbase.DBA_WR_RES_MGR_SYSSTAT
      - oceanbase.DBA_WR_SNAPSHOT
      - oceanbase.DBA_WR_SQL_PLAN
      - oceanbase.DBA_WR_SQLSTAT
      - oceanbase.DBA_WR_SQLTEXT
      - oceanbase.DBA_WR_STATNAME
      - oceanbase.DBA_WR_SYS_TIME_MODEL
      - oceanbase.DBA_WR_SYSSTAT
      - oceanbase.DBA_WR_SYSTEM_EVENT
      - oceanbase.USER_JAVA_POLICY
      - oceanbase.DBA_OB_LICENSE
    - 性能视图
  - MySQL 租户系统视图
  - Oracle 租户系统视图
  - 监控项总览
  - 常见等待事件说明
- 配置项和系统变量
- 错误码
- 性能调优
- 性能测试
- 数据库代理
- 驱动
- 平台产品
- 组件 & 工具
- 数据库插件
常见问题
版本发布记录
术语

oceanbase.DBA_OB_SYNC_STANDBY_DEST

更新时间：2026-07-13 20:58:52

分享

说明

对于 V4.4.2 版本，该视图从 V4.4.2 BP1 版本开始引入。

功能描述

视图 DBA_OB_SYNC_STANDBY_DEST 用于展示本租户的强同步下游信息。

字段说明

字段名称	类型	是否可以为 NULL	描述
TENANT_ID	bigint(20)	NO	租户 ID
DEST_ID	bigint(20)	NO	强同步备租户的 ID，当前限制一个主租户只能有一个 ID 为 0 的强同步备租户
VALUE	longtext	NO	强同步的备租户的信息，包含 ip_list、登录名、密码、cluster_id 等

相关视图或文档

系统租户下查询所有租户的强同步下游信息，参见 CDB_OB_SYNC_STANDBY_DEST。

有帮助

无帮助