Note
This view is available starting with V4.2.1.
Overview
This view displays information related to the entire table restore task. The process of table restore includes restoration operations for the auxiliary tenant and cross-tenant import operations. This view corresponds to two task records: one for the sys tenant and one for the target user tenant itself. Specifically:
The task records of the
systenant mainly record the progress of table-level restore for the target user tenant. A task is considered complete when the entire table-level restore task for the target tenant is finished.The task records of the target user tenant itself, including the recovery progress of auxiliary tenants and the progress of table import tasks. The task is considered complete when both the recovery task and the table import task for the auxiliary tenant are finished.
Columns
Column |
Type |
Is NULL |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Task Tenant ID |
| JOB_ID | bigint(20) | NO | Task ID |
| INITIATOR_TENANT_ID | bigint(20) | NO | Tenant ID of the parent task |
| INITIATOR_JOB_ID | bigint(20) | NO | JOB ID of the parent task |
| START_TIMESTAMP | timestamp(6) | NO | Current Tenant Time at Task Start |
| FINISH_TIMESTAMP | timestamp(6) | NO | Current Tenant Time at Task Completion |
| STATUS | varchar(64) | NO | Task status. Valid values:
|
| AUX_TENANT_NAME | varchar(64) | NO | Secondary Tenant Name |
| TARGET_TENANT_NAME | varchar(64) | NO | Target Tenant Name Identifier |
| IMPORT_ALL | tinyint(4) | NO | Whether to import all tables in the entire tenant. This parameter is valid only when you specifyRECOVER TABLE *.*1, and 0 in other scenarios. |
| DB_LIST | longtext | YES | Database to be Fully Restored |
| TABLE_LIST | longtext | YES | Table to Restore |
| RESTORE_SCN | bigint(20) unsigned | NO | User-specified restore point |
| RESTORE_SCN_DISPLAY | datetime(6) | NO | The timestamp of the restore point specified by the user is represented as |
| RESTORE_OPTION | varchar(4096) | NO | restore_option parameters for dependent auxiliary tenants |
| BACKUP_DEST | varchar(4096) | NO | Backup and archive paths |
| BACKUP_SET_LIST | longtext | NO | Data Backup Path |
| BACKUP_PIECE_LIST | longtext | NO | Log Archiving Path |
| BACKUP_PASSWD | varchar(4096) | YES | Backup Set Password |
| EXTERNAL_KMS_INFO | varchar(4096) | YES | If the source tenant has key management enabled, you must configure this option via the session. |
| REMAP_DB_LIST | longtext | YES | The renamed database. The format is as follows:db1:new_db1, db2:newdb2 |
| REMAP_TABLE_LIST | longtext | YES | The renamed table. The format is as follows:db1.t1:new_t1, db1.t2:db2.new_t2 |
| REMAP_TABLEGROUP_LIST | longtext | YES | The REMAP TABLEGROUP list remaps tables from the source tablegroup to the target tablegroup. The format is as follows:tg1:new_tg1, tg2:new_tg2 |
| REMAP_TABLESPACE_LIST | longtext | YES | The list of remapped tablespaces allows you to remap a table from its original tablespace to a target tablespace. The format is as follows:ts1:new_ts1, ts2:new_ts2 |
| RESULT | varchar(64) | YES | Result of the table restore task:
|
| COMMENT | longtext | YES | Remarks |
| DESCRIPTION | longtext | YES | DESCRIPTION information specified in the restore command |
Sample query
During table-level restore, view information related to the entire table-level restore task under the sys tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_RECOVER_TABLE_JOBS\G
The query result is as follows:
*************************** 1. row ***************************
TENANT_ID: 1
JOB_ID: 1
INITIATOR_TENANT_ID: 1
INITIATOR_JOB_ID: 0
START_TIMESTAMP: 2025-01-07 16:07:33.965561
FINISH_TIMESTAMP: NULL
STATUS: RECOVERING
AUX_TENANT_NAME: AUX_RECOVER$1736237253959061
TARGET_TENANT_NAME: mysql001
IMPORT_ALL: 0
DB_LIST:
TABLE_LIST: `infotest`.`t2`
RESTORE_SCN: 1736237207609421000
RESTORE_SCN_DISPLAY: 2025-01-07 16:06:47.609421
RESTORE_OPTION: pool_list=rptest
BACKUP_DEST: file:///home/admin/oceanbase/arglog,file:///home/admin/oceanbase/backupdata
BACKUP_SET_LIST: file:///home/admin/oceanbase/backupdata/backup_set_4_full
BACKUP_PIECE_LIST: file:///home/admin/oceanbase/arglog/piece_d1001r1p1
BACKUP_PASSWD: NULL
EXTERNAL_KMS_INFO: NULL
REMAP_DB_LIST:
REMAP_TABLE_LIST: `infotest`.`t2`:`infotest`.`newtb2`
REMAP_TABLEGROUP_LIST:
REMAP_TABLESPACE_LIST:
RESULT:
COMMENT:
DESCRIPTION: NULL
*************************** 2. row ***************************
TENANT_ID: 1002
JOB_ID: 5
INITIATOR_TENANT_ID: 1
INITIATOR_JOB_ID: 1
START_TIMESTAMP: 2025-01-07 16:07:33.965561
FINISH_TIMESTAMP: NULL
STATUS: RESTORE_AUX_TENANT
AUX_TENANT_NAME: AUX_RECOVER$1736237253959061
TARGET_TENANT_NAME: mysql001
IMPORT_ALL: 0
DB_LIST:
TABLE_LIST: `infotest`.`t2`
RESTORE_SCN: 1736237207609421000
RESTORE_SCN_DISPLAY: 2025-01-07 16:06:47.609421
RESTORE_OPTION: pool_list=rptest
BACKUP_DEST: file:///home/admin/oceanbase/arglog,file:///home/admin/oceanbase/backupdata
BACKUP_SET_LIST: file:///home/admin/oceanbase/backupdata/backup_set_4_full
BACKUP_PIECE_LIST: file:///home/admin/oceanbase/arglog/piece_d1001r1p1
BACKUP_PASSWD: NULL
EXTERNAL_KMS_INFO: NULL
REMAP_DB_LIST:
REMAP_TABLE_LIST: `infotest`.`t2`:`infotest`.`newtb2`
REMAP_TABLEGROUP_LIST:
REMAP_TABLESPACE_LIST:
RESULT:
COMMENT:
DESCRIPTION: NULL
2 rows in set
References
For detailed operations and instructions on viewing the progress of a table-level restore task, see View the progress of a table-level restore.