oceanbase.DBA_OB_LOG_RESTORE_SOURCE

2024-03-05 01:54:26  Updated

Purpose

The oceanbase.DBA_OB_LOG_RESTORE_SOURCE view displays the log restore sources for physically restored tenants and standby tenants.

Note

This view is introduced since OceanBase Database V4.2.0.

Columns

Column Type Nullable? Description
TENANT_ID bigint(20) NO The ID of the tenant.
ID bigint(20) NO The ID of the log restore source.
TYPE varchar(32) NO The type of the log restore source. Valid values:
  • SERVICE: a directly connected log restore source.
  • LOCATION: an archive log restore source.
  • RAWPATH: a user-managed log restore source.
VALUE longtext NO The access URL of the log restore source.
  • For a log restore source of the SERVICE type, the value is the access URL of the primary tenant, such as IP_LIST=xxx.xxx.xxx.xxx:44803,USER=user@mysql,PASSWORD=******,TENANT_ID=1002,CLUSTER_ID=1,COMPATIBILITY_MODE=ORACLE,IS_ENCRYPTED=true.
  • For a log restore source of the LOCATION type, the value is a log archive directory, such as file:///data/1/archive/.
  • For a log restore source of the RAWPATH type, the value is a user-defined directory.
RECOVERY_UNTIL_SCN bigint(20) unsigned NO The maximum SCN for log acquisition. The value can be INT64_MAX or a finite value greater than 0.

Contact Us