oceanbase.DBA_OB_RESTORE_PROGRESS|V4.2.2|OceanBase Database|docs|OceanBase Documentations

Column	Type	Nullable?	Description
JOB_ID	bigint(20)	NO	The ID of the restore job.
RESTORE_TENANT_NAME	longtext	NO	The name of the tenant to be restored.
RESTORE_TENANT_ID	longtext	NO	The ID of the tenant to be restored.
BACKUP_TENANT_NAME	longtext	NO	The name of the backup source tenant.
BACKUP_TENANT_ID	longtext	NO	The ID of the backup source tenant.
BACKUP_CLUSTER_NAME	longtext	NO	The name of the backup source cluster.
BACKUP_DEST	longtext	NO	The backup set paths. The value contains the data backup path and log archive path.
RESTORE_OPTION	longtext	NO	The restore option specified when restore is initiated.
RESTORE_SCN	bigint(20) unsigned	NO	The restore system change number (SCN).
RESTORE_SCN_DISPLAY	datetime(6)	NO	The restore SCN displayed as a timestamp.
STATUS	longtext	NO	The restore status. The possible states of a restore job in the sys tenant are inconsistent with those in the restored tenant. For the sys tenant: `CREATE_TENANT`: The sys tenant is creating the target tenant to be restored. `WAIT_TENANT_RESTORE_FINISH`: The system is waiting for the restore of the target tenant to complete. `RESTORE_SUCCESS`: The tenant is restored. `RESTORE_FAIL`: The restore of the tenant failed. For the target tenant: `RESTORE_PRE`: Preparations are being made for the restore. If encryption is enabled, the system will set encryption information in this phase. `RESTORE_CREATE_INIT_LS`: The system is creating log streams. `RESTORE_WAIT_LS`: The system is waiting for the restore of the log streams to complete. `POST_CHECK`: The system is checking the role of the tenant and restoring the tenant as a standby database. `UPGRADE`: The tenant is being upgraded. For restore across versions, an upgrade will be performed for the tenant. `RESTORE_SUCCESS`: The restore succeeded. `RESTORE_FAIL`: The restore failed.
START_TIMESTAMP	datetime(6)	NO	The start timestamp of the restore job.
BACKUP_SET_LIST	longtext	NO	The backup set paths for restore, which are separated with commas (`,`). For example, `file:///data/nfs/backup/data/backup_set_1_full,file:///data/nfs/backup/data/backup_set_2_inc`.
BACKUP_PIECE_LIST	longtext	NO	The paths of log archive pieces for restore, which are separated with commas (,). For example, `file:///data/nfs/backup/data/backup_set_1_full,file:///data/nfs/backup/data/backup_set_2_inc`.
TOTAL_BYTES	bigint(20)	NO	The total number of bytes to restore.
TOTAL_BYTES_DISPLAY	varchar(27)	NO	The total number of bytes to restore, in a storage capacity unit.
FINISH_BYTES	bigint(20)	NO	The number of bytes restored.
FINISH_BYTES_DISPLAY	varchar(27)	NO	The total number of bytes restored, in a storage capacity unit.
DESCRIPTION	longtext	NO	The description specified in the restore statement.

JOB_ID

bigint(20)

NO

The ID of the restore job.

RESTORE_TENANT_NAME

longtext

NO

The name of the tenant to be restored.

RESTORE_TENANT_ID

longtext

NO

The ID of the tenant to be restored.

BACKUP_TENANT_NAME

longtext

NO

The name of the backup source tenant.

BACKUP_TENANT_ID

longtext

NO

The ID of the backup source tenant.

BACKUP_CLUSTER_NAME

longtext

NO

The name of the backup source cluster.

BACKUP_DEST

longtext

NO

The backup set paths. The value contains the data backup path and log archive path.

RESTORE_OPTION

longtext

NO

The restore option specified when restore is initiated.

RESTORE_SCN

bigint(20) unsigned

NO

The restore system change number (SCN).

RESTORE_SCN_DISPLAY

datetime(6)

NO

The restore SCN displayed as a timestamp.

STATUS

longtext

NO

The restore status. The possible states of a restore job in the sys tenant are inconsistent with those in the restored tenant.
For the sys tenant:

CREATE_TENANT: The sys tenant is creating the target tenant to be restored.
WAIT_TENANT_RESTORE_FINISH: The system is waiting for the restore of the target tenant to complete.
RESTORE_SUCCESS: The tenant is restored.
RESTORE_FAIL: The restore of the tenant failed.

For the target tenant:

RESTORE_PRE: Preparations are being made for the restore. If encryption is enabled, the system will set encryption information in this phase.
RESTORE_CREATE_INIT_LS: The system is creating log streams.
RESTORE_WAIT_LS: The system is waiting for the restore of the log streams to complete.
POST_CHECK: The system is checking the role of the tenant and restoring the tenant as a standby database.
UPGRADE: The tenant is being upgraded. For restore across versions, an upgrade will be performed for the tenant.
RESTORE_SUCCESS: The restore succeeded.
RESTORE_FAIL: The restore failed.

START_TIMESTAMP

datetime(6)

NO

The start timestamp of the restore job.

BACKUP_SET_LIST

longtext

NO

The backup set paths for restore, which are separated with commas (,). For example, file:///data/nfs/backup/data/backup_set_1_full,file:///data/nfs/backup/data/backup_set_2_inc.

BACKUP_PIECE_LIST

longtext

NO

The paths of log archive pieces for restore, which are separated with commas (,). For example, file:///data/nfs/backup/data/backup_set_1_full,file:///data/nfs/backup/data/backup_set_2_inc.

TOTAL_BYTES

bigint(20)

NO

The total number of bytes to restore.

TOTAL_BYTES_DISPLAY

varchar(27)

NO

The total number of bytes to restore, in a storage capacity unit.

FINISH_BYTES

bigint(20)

NO

The number of bytes restored.

FINISH_BYTES_DISPLAY

varchar(27)

NO

The total number of bytes restored, in a storage capacity unit.

DESCRIPTION

longtext

NO

The description specified in the restore statement.

oceanbase.DBA_OB_RESTORE_PROGRESS

Purpose

Note

Columns