Purpose
The oceanbase.DBA_OB_RECOVER_TABLE_JOBS view provides information about 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. |
| 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 job. Valid values:
|
| COMMENT | longtext | YES | The additional information. |
| DESCRIPTION | longtext | YES | The description specified in the restore statement. |
