Purpose
oceanbase.CDB_OB_RESTORE_PROGRESS displays the progress of physical restore jobs.
Fields
| Parameter | Type | Nullable? | Description |
|---|---|---|---|
| JOB_ID | bigint(20) | NO | The unique ID of the physical restore job. |
| EXTERNAL_JOB_ID | bigint(20) | NO | The external ID of the physical restore job. The value may not be unique and is passed in by the restore command. The default value is -1. |
| TENANT_ID | bigint(20) | NO | The ID of the restored tenant. The default value is -1. |
| TENANT_NAME | varchar(128) | NO | The name of the restored tenant. The default value is empty. |
| BACKUP_TENANT_ID | bigint(20) | NO | The ID of the tenant whose data was originally backed up. |
| BACKUP_TENANT_NAME | varchar(128) | NO | The name of the tenant whose data was originally backed up. |
| BACKUP_CLUSTER_ID | bigint(20) | NO | The ID of the cluster whose data was originally backed up. |
| BACKUP_CLUSTER_NAME | varchar(128) | NO | The name of the cluster whose data was originally backed up. |
| WHITE_LIST | longtext | YES | A non-null value indicates that a whitelist is used in the physical restore. |
| STATUS | varchar(64) | NO | The current stage of the physical restore task. Valid values: CREATE_TENANT: The stage of creating the tenant.RESTORE_SYS_REPLICA: The stage of restoring the system table of the tenant.MODIFY_SCHEMA: The stage of correcting the metadata of the tenant.CREATE_USER_PARTITIONS: The stage of creating a user table for the tenant.RESTORE_USER_REPLICA: The stage of restoring data to the user table of the tenant.REBUILD_INDEX: The stage of rebuilding the index.POST_CHECK: The stage of performing the validation.RESTORE_SUCCESS: The restoration succeeded.RESTORE_FAIL: The restoration failed. |
| START_TIME | timestamp(6) | YES | The time when the restoration task started. |
| COMPLETION_TIME | timestamp(6) | YES | The time when the restoration task is completed. |
| PARTITION_COUNT | bigint(20) | NO | RESTORE_SYS_REPLICA stage: the number of to-be-restored partitions of the system table.RESTORE_USER_REPLICA stage: the number of to-be-restored partitions of the user table.0 in other stages. |
| MACRO_BLOCK_COUNT | bigint(20) | NO | The number of to-be-restored macro blocks. This field is not supported and the value is meaningless at present. |
| FINISH_PARTITION_COUNT | bigint(20) | NO | RESTORE_SYS_REPLICA stage: the number of partitions of the system table that have been restored at the baseline level.RESTORE_USER_REPLICA stage: the number of partitions of the user table that have been restored at the baseline level.0 in other stages. |
| FINISH_MACRO_BLOCK_COUNT | bigint(20) | NO | The number of macro blocks that have been restored. This field is not supported and the value is meaningless at present. The default value is 0. |
| RESTORE_START_TIMESTAMP | timestamp(6) | YES | The start point of incremental restoration, which is determined by the backup data. |
| RESTORE_FINISH_TIMESTAMP | timestamp(6) | YES | The end point of incremental restoration, which is specified by the restoration command. |
| RESTORE_CURRENT_TIMESTAMP | timestamp(6) | YES | The start point for the current incremental restoration. This field is not supported and the value is meaningless at present. |
| BACKUP_SET_LIST | longtext | YES | The list of backup sets specified for restoration. |
| BACKUP_PIECE_LIST | longtext | YES | The list of backup pieces specified for restoration. |
| INFO | varchar(4096) | NO | The execution information during restoration, which contains the name of the module on which the error occurred and the error code when the restoration failed. The default value is empty. |