Purpose
The oceanbase.CDB_OB_RECOVER_TABLE_JOB_HISTORY view displays the results of table-level restore jobs.
Note
This view is introduced since OceanBase Database V4.2.1.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| JOB_ID | bigint(20) | NO | The job ID. |
| INITIATOR_TENANT_ID | bigint(20) | NO | The tenant ID of the parent job. |
| INITIATOR_JOB_ID | bigint(20) | NO | The ID of the parent job. |
| START_TIMESTAMP | timestamp(6) | NO | The time on the tenant when the job started. |
| FINISH_TIMESTAMP | timestamp(6) | NO | The time on the tenant when the job was completed. |
| STATUS | varchar(64) | NO | The status of the job. Valid values:
|
| AUX_TENANT_NAME | varchar(64) | NO | The name of the auxiliary tenant. |
| TARGET_TENANT_NAME | varchar(64) | NO | The name of the target tenant. |
| IMPORT_ALL | tinyint(4) | NO | Indicates whether to import all tables in the tenant. The value is 1 if RECOVER TABLE *.* is specified, and is 0 in other scenarios. |
| DB_LIST | longtext | YES | The database to restore. |
| TABLE_LIST | longtext | YES | The tables to restore. |
| 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. |
| RESTORE_OPTION | varchar(4096) | NO | The restore options that the auxiliary tenant depends on. |
| BACKUP_DEST | varchar(4096) | NO | The data backup and log archive paths. |
| BACKUP_SET_LIST | longtext | NO | The data backup path. |
| BACKUP_PIECE_LIST | longtext | NO | The log archive path. |
| BACKUP_PASSWD | varchar(4096) | YES | The password of the backup set. |
| EXTERNAL_KMS_INFO | varchar(4096) | YES | The Key Management Service (KMS) information of the source tenant. This field must be configured in the session. |
| REMAP_DB_LIST | longtext | YES | The remappings of databases, in the format of db1:new_db1, db2:newdb2. |
| REMAP_TABLE_LIST | longtext | YES | The remappings of tables, in the format of db1.t1:new_t1, db1.t2:db2.new_t2. |
| REMAP_TABLEGROUP_LIST | longtext | YES | The remappings of table groups, in the format of tg1:new_tg1, tg2:new_tg2. You can remap a table from the original table group to the target table group. |
| REMAP_TABLESPACE_LIST | longtext | YES | The remappings of tablespaces, in the format of ts1:new_ts1, ts2:new_ts2. You can remap a table from the original tablespace to the target tablespace. |
| RESULT | varchar(64) | YES | The result of the table-level restore job. Valid values:
|
| COMMENT | longtext | YES | The additional information. |
| DESCRIPTION | longtext | YES | The description specified in the restore statement. |