Note
This view is introduced since OceanBase Database V4.2.1.
Purpose
The DBA_OB_RECOVER_TABLE_JOB_HISTORY view displays the results of table-level restore jobs.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| JOB_ID | NUMBER(38) | NO | The ID of the job. |
| INITIATOR_TENANT_ID | NUMBER(38) | NO | The tenant ID of the parent job. |
| INITIATOR_JOB_ID | NUMBER(38) | NO | The ID of the parent job. |
| START_TIMESTAMP | VARCHAR2(256) | NO | The time on the tenant when the job was started. |
| FINISH_TIMESTAMP | VARCHAR2(256) | NO | The time on the tenant when the job was completed. |
| STATUS | VARCHAR2(64) | NO | The status of the job. Valid values:
|
| AUX_TENANT_NAME | VARCHAR2(64) | NO | The name of the auxiliary tenant. |
| TARGET_TENANT_NAME | VARCHAR2(64) | NO | The name of the destination tenant. |
| IMPORT_ALL | NUMBER(38) | 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 | CLOB | YES | The databases to restore. |
| TABLE_LIST | CLOB | YES | The tables to restore. |
| RESTORE_SCN | NUMBER(38) | NO | The restore system change number (SCN). |
| RESTORE_SCN_DISPLAY | TIMESTAMP(9) | NO | The restore SCN displayed as a timestamp. |
| RESTORE_OPTION | VARCHAR2(4096) | NO | The restore options that the auxiliary tenant depends on. |
| BACKUP_DEST | VARCHAR2(4096) | NO | The path for backup and archiving. |
| BACKUP_SET_LIST | CLOB | NO | The path for data backup. |
| BACKUP_PIECE_LIST | CLOB | NO | The path for log archiving. |
| BACKUP_PASSWD | VARCHAR2(4096) | YES | The password of the backup set. |
| EXTERNAL_KMS_INFO | VARCHAR2(4096) | YES | The Key Management Service (KMS) information of the source tenant. This field must be configured in the session. |
| REMAP_DB_LIST | CLOB | YES | The list of renamed databases, in the db1:new_db1, db2:newdb2 format. |
| REMAP_TABLE_LIST | CLOB | YES | The list of renamed tables, in the db1.t1:new_t1, db1.t2:db2.new_t2 format. |
| REMAP_TABLEGROUP_LIST | CLOB | 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 | CLOB | 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 | VARCHAR2(64) | YES | The result of the table-level restore job. Valid values:
|
| COMMENT | CLOB | YES | The additional information. |
| DESCRIPTION | CLOB | YES | The description specified in the restore statement. |