OceanBase Database allows you to query the restore progress and result in views.
CDB_OB_RESTORE_PROGRESS
CDB_OB_RESTORE_PROGRESS displays the restore progress of tenants.
| Column | Description |
|---|---|
| TENANT_ID | The ID of the tenant that performed the restore job. |
| JOB_ID | The ID of the restore job. |
| RESTORE_TENANT_NAME | The name of the tenant to be restored. |
| RESTORE_TENANT_ID | The ID of the tenant to be restored. |
| BACKUP_TENANT_NAME | The name of the backup source tenant. |
| BACKUP_TENANT_ID | The ID of the backup source tenant. |
| BACKUP_CLUSTER_NAME | The name of the backup source cluster. |
| BACKUP_DEST | The backup set paths. The value contains the data backup path and log archive path. |
| RESTORE_OPTION | The restore option specified when restore is initiated. |
| RESTORE_SCN | The restore system change number (SCN). |
| RESTORE_SCN_DISPLAY | The restore SCN displayed as a timestamp. |
| STATUS | 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:
For the target tenant:
|
| START_TIMESTAMP | The start timestamp of the restore job. |
| BACKUP_SET_LIST | 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 | The paths of log archive pieces for restore, which are separated with commas (,). For example, file:///data/nfs/backup/archive/piece_d1001r1p1,file:///data/nfs/backup/archive/piece_d1001r2p2. |
| TOTAL_BYTES | The total number of bytes to restore. |
| TOTAL_BYTES_DISPLAY | The total number of bytes to restore, in a storage capacity unit. |
| FINISH_BYTES | The number of bytes restored. |
| FINISH_BYTES_DISPLAY | The total number of bytes restored, in a storage capacity unit. |
| DESCRIPTION | The description specified in the restore statement. |
CDB_OB_RESTORE_HISTORY
CDB_OB_RESTORE_HISTORY displays the restore results of tenants.
| Column | Description |
|---|---|
| TENANT_ID | The ID of the tenant that performed the restore job. |
| JOB_ID | The ID of the restore job. |
| RESTORE_TENANT_NAME | The name of the tenant to be restored. |
| RESTORE_TENANT_ID | The ID of the tenant to be restored. |
| BACKUP_TENANT_NAME | The name of the backup source tenant. |
| BACKUP_TENANT_ID | The ID of the backup source tenant. |
| BACKUP_CLUSTER_NAME | The name of the backup source cluster. |
| BACKUP_DEST | The backup set paths. The value contains the data backup path and log archive path. |
| RESTORE_SCN | The restore system change number (SCN). |
| RESTORE_SCN_DISPLAY | The restore SCN displayed as a timestamp. |
| RESTORE_OPTION | The restore option specified when restore is initiated. |
| START_TIMESTAMP | The start timestamp of the restore job. |
| FINISH_TIMESTAMP | The end timestamp of the restore job. |
| STATUS | The restore result. Valid values:
|
| BACKUP_PIECE_LIST | The paths of log archive pieces for restore, which are separated with commas (,). For example, file:///data/nfs/backup/archive/piece_d1001r1p1,file:///data/nfs/backup/archive/piece_d1001r2p2. |
| BACKUP_SET_LIST | 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_CLUSTER_VERSION | The version number of the backup source cluster. |
| LS_COUNT | The total number of log streams to restore. |
| FINISH_LS_COUNT | The total number of log streams restored. |
| TABLET_COUNT | The total number of tablets to restore. |
| FINISH_TABLET_COUNT | The number of tablets restored. |
| TOTAL_BYTES | The total number of bytes to restore. |
| TOTAL_BYTES_DISPLAY | The total number of bytes to restore, in a storage capacity unit. |
| FINISH_BYTES | The number of bytes restored. |
| FINISH_BYTES_DISPLAY | The total number of bytes restored, in a storage capacity unit. |
| DESCRIPTION | The description specified in the restore statement. |
| COMMENT | The information about a failed restore job. |