DBA_OB_LOG_RESTORE_SOURCE|V4.3.1|OceanBase Database| docs|Distributed Database

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

This view is introduced since OceanBase Database V4.2.0.

Column	Type	Nullable?	Description
TENANT_ID	NUMBER(38)	NO	The ID of the tenant.
ID	NUMBER(38)	NO	The ID of the log restore source.
TYPE	VARCHAR2(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	CLOB	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	NUMBER(38)	NO	The maximum SCN for log acquisition. The value can be INT64_MAX or a finite value greater than 0.

DBA_OB_LOG_RESTORE_SOURCE