View the data backup progress

This topic describes how to view the data backup progress.

View the data backup progress in views

You can query the oceanbase.CDB_OB_BACKUP_JOBS and oceanbase.CDB_OB_BACKUP_TASKS views from the sys tenant for the data backup progress.

1. Log on to the sys tenant of the cluster as the root user.

2. View the data backup progress.

   Here is an example:

   obclient> SELECT * FROM oceanbase.CDB_OB_BACKUP_JOBS\G
   *************************** 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
   
   
   obclient> SELECT * FROM oceanbase.CDB_OB_BACKUP_TASKS\G
   *************************** 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
   

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.

References

View the data backup history