ITPub博客

首页 > 数据库 > 国内数据库 > 【手摸手玩转 OceanBase 165】怎么查看数据备份进度?

【手摸手玩转 OceanBase 165】怎么查看数据备份进度?

原创 国内数据库 作者:13579NB232 时间:2023-01-19 17:14:33 0 删除 编辑

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

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

系统租户可以通过  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。

相关阅读

查看数据备份结果


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/70026124/viewspace-2932881/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2023-01-18

  • 博文量
    184
  • 访问量
    93199