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 from the sys tenant for the data backup progress.
Log in to the
systenant of the cluster as therootuser.Query the data backup progress.
Query the job progress
Each job corresponds to an initiated backup.
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_BACKUP_JOBS\GA sample 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 setQuery the task progress
Each task corresponds to a backup set.
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_BACKUP_TASKS\GA sample 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 is backing up data to file:///data/nfs/backup/data. The current data backup status is DOING.
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 in to the database as a tenant administrator.
Query the data backup progress.
Query the job progress
Each 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\GQuery the task progress
Each 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