Overview
This view displays information related to the entire table restore task. The process of restoring a table includes both the restore operation for the auxiliary tenant and the import operation across tenants. 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-by-table restore for the target user tenant. A task ends when the entire table-by-table restore task for the target tenant is completed.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 under the entire tenant. This parameter is valid only when the user specifies RECOVER TABLE *.* 1, and 0 in other scenarios. |
| DB_LIST | longtext | YES | Database to be Fully Restored |
| TABLE_LIST | longtext | YES | Table to be restored |
| RESTORE_SCN | bigint(20) unsigned | NO | User-specified restore point |
| RESTORE_SCN_DISPLAY | datetime(6) | NO | The timestamp of the user-specified restore point is represented as |
| RESTORE_OPTION | varchar(4096) | NO | restore_option parameter for dependent sub-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 key custody is enabled for the source tenant, you must configure this option in 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, which indicates the tables that have been remapped from the original tablespaces to the target tablespaces. 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 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 restore.