Description
oceanbase.CDB_OB_RESTORE_HISTORY displays the status of completed physical restoration jobs. It is a snapshot of the records in oceanbase.CDB_OB_RESTORE_PROGRESS for completed restoration jobs.
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| JOB_ID | bigint(20) | NO | The unique ID of the physical restoration job. |
| EXTERNAL_JOB_ID | bigint(20) | NO | The external ID of the physical restoration job. The value may not be unique and is transferred by the restoration command. The default value is -1. |
| TENANT_ID | bigint(20) | NO | The restored tenant ID. The default value is -1. |
| TENANT_NAME | varchar(128) | NO | The restored tenant name. 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 restoration. |
| STATUS | varchar(64) | NO | The current stage of the physical restoration 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 | * At the RESTORE_SYS_REPLICA stage: the number of to-be-restored partitions of the system table. * At the RESTORE_USER_REPLICA stage: the number of to-be-restored partitions of the user table. * This field is meaningless and is defaulted to 0 in other stages. |
| MACRO_BLOCK_COUNT | bigint(20) | NO | The number of to-be-restored macro blocks. This field has not been implemented and is meaningless at present. |
| FINISH_PARTITION_COUNT | bigint(20) | NO | * At the RESTORE_SYS_REPLICA stage: the number of partitions of the system table that have been restored at the baseline level. * At the RESTORE_USER_REPLICA stage: the number of partitions of the user table that have been restored at the baseline level. * This field is meaningless and is defaulted to 0 in other stages. |
| FINISH_MACRO_BLOCK_COUNT | bigint(20) | NO | The number of macro blocks that have been restored. This field has not been implemented, and is meaningless and defaulted to 0 at present. |
| 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 starting point for the current incremental restoration. At present, OceanBase Database does not support this field, and the value is meaningless. |
| 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. |