This topic describes how to view the data backup progress.
View the data backup progress in the sys tenant
You can query the CDB_OB_BACKUP_JOBS and CDB_OB_BACKUP_TASKS views in the sys tenant for the data backup progress.
Log on to the
systenant of the cluster as therootuser.View the data backup progress.
View the job progress
A job corresponds to an initiated backup.
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_BACKUP_JOBS\GThe query result is as follows:
*************************** 1. row *************************** TENANT_ID: 1 JOB_ID: 1 INCARNATION: 1 BACKUP_SET_ID: 0 INITIATOR_TENANT_ID: 1 INITIATOR_JOB_ID: 1 EXECUTOR_TENANT_ID: 1002 PLUS_ARCHIVELOG: OFF BACKUP_TYPE: D JOB_LEVEL: CLUSTER ENCRYPTION_MODE: NONE PASSWD: START_TIMESTAMP: 2022-06-01 17:10:23.975539 END_TIMESTAMP: STATUS: DOING RESULT: 0 COMMENT: DESCRIPTION: PATH: *************************** 2. row *************************** TENANT_ID: 1002 JOB_ID: 1 INCARNATION: 1 BACKUP_SET_ID: 1 INITIATOR_TENANT_ID: 1 INITIATOR_JOB_ID: 1 EXECUTOR_TENANT_ID: 1002 PLUS_ARCHIVELOG: OFF BACKUP_TYPE: D JOB_LEVEL: USER_TENANT ENCRYPTION_MODE: NONE PASSWD: START_TIMESTAMP: 2022-06-01 17:10:24.046643 END_TIMESTAMP: STATUS: DOING RESULT: 0 COMMENT: DESCRIPTION: PATH: file:///data/nfs/backup/data 1 row in setView the task progress
A task corresponds to a backup set.
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_BACKUP_TASKS\GThe query result is as follows:
*************************** 1. row *************************** TENANT_ID: 1002 TASK_ID: 1 JOB_ID: 1 INCARNATION: 1 BACKUP_SET_ID: 1 START_TIMESTAMP: 2022-06-01 17:10:24.046643 END_TIMESTAMP: STATUS: BACKUP_DATA START_SCN: 1658740213006643504 END_SCN: 0 USER_LS_START_SCN: 1658740229412297106 ENCRYPTION_MODE: NONE PASSWD: INPUT_BYTES: 0 OUTPUT_BYTES: 0 OUTPUT_RATE_BYTES: 0.0000 EXTRA_META_BYTES: 0 TABLET_COUNT: 0 FINISH_TABLET_COUNT: 0 MACRO_BLOCK_COUNT: 0 FINISH_MACRO_BLOCK_COUNT: 0 FILE_COUNT: 0 META_TURN_ID: 1 DATA_TURN_ID: 1 RESULT: 0 COMMENT: PATH: file:///data/nfs/backup/data 1 row in set
In the preceding example, the tenant with the tenant ID 1002 has a data backup job in progress. The backup destination is file:///data/nfs/backup/data. The current data backup status is DOING.
For more information about the CDB_OB_BACKUP_JOBS and CDB_OB_BACKUP_TASKS views, see CDB_OB_BACKUP_JOBS and CDB_OB_BACKUP_TASKS.
View the data backup progress in a user tenant
You can query the DBA_OB_BACKUP_JOBS and DBA_OB_BACKUP_TASKS views in a user tenant for the data backup progress.
Log on to the database as a tenant administrator.
View the data backup progress.
View the job progress
A job corresponds to an initiated backup.
MySQL modeOracle modeHere is an example in MySQL mode:
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_BACKUP_JOBS\GHere is an example in Oracle mode:
obclient [SYS]> SELECT * FROM SYS.DBA_OB_BACKUP_JOBS\GView the task progress
A task corresponds to a backup set.
MySQL modeOracle modeHere is an example in MySQL mode:
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_BACKUP_TASKS\GHere is an example in Oracle mode:
obclient [SYS]> SELECT * FROM SYS.DBA_OB_BACKUP_TASKS\G