View the data backup progress

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.

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

2. 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\G
     

     A sample query result is as follows:

     *************************** 1. 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 set
     

   • View the task progress

     A task corresponds to a backup set.

     obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_BACKUP_TASKS\G
     

     A sample query result is as follows:

     *************************** 1. row ***************************
                    TENANT_ID: 1002
                      TASK_ID: 2
                       JOB_ID: 2
                  INCARNATION: 1
                BACKUP_SET_ID: 2
              START_TIMESTAMP: 2024-05-09 17:54:07.718856
                END_TIMESTAMP: NULL
                       STATUS: BEFORE_BACKUP_LOG
                    START_SCN: 1715248462749288000
                      END_SCN: 1715248598352783000
            USER_LS_START_SCN: 1715248476694964000
              ENCRYPTION_MODE: NONE
                       PASSWD:
                  INPUT_BYTES: 173261302
                 OUTPUT_BYTES: 18706154
            OUTPUT_RATE_BYTES: 0.0000
             EXTRA_META_BYTES: 0
                 TABLET_COUNT: 668
          FINISH_TABLET_COUNT: 668
            MACRO_BLOCK_COUNT: 82
     FINISH_MACRO_BLOCK_COUNT: 82
                   FILE_COUNT: 0
                 META_TURN_ID: 1
                 DATA_TURN_ID: 0
                       RESULT: 0
                      COMMENT:
                         PATH: file:///data/nfs/backup/data
                MINOR_TURN_ID: 1
                MAJOR_TURN_ID: 1
                DATA_PROGRESS: 100.00
               LOG_FILE_COUNT: 0
        FINISH_LOG_FILE_COUNT: 0
                 LOG_PROGRESS: 0.00
     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 BEFORE_BACKUP_LOG.

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.

1. Log on to the database as a tenant administrator.

2. View the data backup progress.

   • View the job progress

     A job corresponds to an initiated backup.

     MySQL mode

     Oracle mode

     Here is an example in MySQL mode:

     obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_BACKUP_JOBS\G
     

     Here is an example in Oracle mode:

     obclient [SYS]> SELECT * FROM SYS.DBA_OB_BACKUP_JOBS\G
     

   • View the task progress

     A task corresponds to a backup set.

     MySQL mode

     Oracle mode

     Here is an example in MySQL mode:

     obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_BACKUP_TASKS\G
     

     Here is an example in Oracle mode:

     obclient [SYS]> SELECT * FROM SYS.DBA_OB_BACKUP_TASKS\G
     

References

View the data backup history