Purpose
The oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY view displays the result of table-level restore jobs.
Note
This view is introduced since OceanBase Database V4.2.1.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| JOB_ID | bigint(20) | NO | The ID of the job. |
| 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 was 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 path for backup and archiving. |
| BACKUP_SET_LIST | longtext | NO | The path for data backup. |
| BACKUP_PIECE_LIST | longtext | NO | The path for log archiving. |
| 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 column must be configured in the session. If Key Management Service (KMS) is enabled for the source tenant, you need to set EXTERNAL_KMS_INFO through the session. |
| REMAP_DB_LIST | longtext | YES | The list of renamed databases, in the db1:new_db1, db2:newdb2 format. |
| REMAP_TABLE_LIST | longtext | YES | The list of renamed tables, in the db1.t1:new_t1, db1.t2:db2.new_t2 format. |
| REMAP_TABLEGROUP_LIST | longtext | YES | The list of remapped table groups in the tg1:new_tg1, tg2:new_tg2 format. You can remap a table from the original table group to the target table group. |
| REMAP_TABLESPACE_LIST | longtext | YES | The list of remapped tablespaces, in the ts1:new_ts1, ts2:new_ts2 format. You can remap a table from the original tablespace to the target tablespace. |
| RESULT | varchar(64) | YES | The result of the table-level restore task. Valid values:
|
| COMMENT | longtext | YES | The additional information. |
| DESCRIPTION | longtext | YES | The description specified in the restore statement. |