分布式数据库学习Note131：OceanBase社区版中，如何查看数据备份进度？

执行数据备份后，您可以查看备份进度。

通过视图查看数据备份进度

系统租户可以通过 oceanbase.CDB_OB_BACKUP_JOBS 视图和 oceanbase.CDB_OB_BACKUP_TASKS 视图查看数据备份的进度。

1. 使用 root 用户登录到数据库的 sys 租户。

2. 查看数据备份进度。

   示例如下：

   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
   

上面的示例中，租户 ID 为 1002 的租户正在进行数据备份，其备份目的端为 file:///data/nfs/backup/data , 当前的数据备份状态为 DOING。

更多 CDB_OB_BACKUP_JOBS 和 CDB_OB_BACKUP_TASKS 视图的说明，请参见 CDB_OB_BACKUP_JOBS 和 CDB_OB_BACKUP_TASKS。

相关阅读

查看数据备份结果