---
title: "查看数据备份结果 | OceanBase 文档中心"
description: "查看数据备份结果 数据备份执行完成后，您可以通过视图查看备份任务历史。 通过视图查看数据备份任务历史 使用 root 用户登录到数据库的 sys 租户。 查看数据备份历史。 示例如下： obclient> SELECT * FROM oceanbase.CDB_OB_BACKUP_JOB_HISTORY\\G ****…"
---
切换语言

- 中文站 - 简体中文
- International - English
- 日本站 - 日本語

文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 4.0.0 企业版

# 查看数据备份结果

更新时间：2026-07-02 08:41:00

数据备份执行完成后，您可以通过视图查看备份任务历史。

## 通过视图查看数据备份任务历史

1. 使用 `root` 用户登录到数据库的 `sys` 租户。
 2. 查看数据备份历史。

   示例如下：

   ```sql
   obclient> SELECT * FROM oceanbase.CDB_OB_BACKUP_JOB_HISTORY\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 16:54:25.940040
         END_TIMESTAMP: 2022-06-01 16:56:03.779662
                STATUS: COMPLETED
                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 16:54:26.007298
         END_TIMESTAMP: 2022-06-01 16:56:03.629399
                STATUS: COMPLETED
                RESULT: 0
               COMMENT:
           DESCRIPTION:
                  PATH: file:///data/nfs/backup/data

   obclient> SELECT * FROM oceanbase.CDB_OB_BACKUP_TASK_HISTORY\G
   *************************** 1. row ***************************
                  TENANT_ID: 1002
                    TASK_ID: 1
                     JOB_ID: 1
                INCARNATION: 1
              BACKUP_SET_ID: 1
            START_TIMESTAMP: 2022-06-01 16:54:26.007298
              END_TIMESTAMP: 2022-06-01 16:56:03.576909
                     STATUS: COMPLETED
                  START_SCN: 1658739252505427433
                    END_SCN: 1658739352813474497
          USER_LS_START_SCN: 1658739274182399688
            ENCRYPTION_MODE: NONE
                     PASSWD:
                INPUT_BYTES: 567650229
               OUTPUT_BYTES: 567650229
          OUTPUT_RATE_BYTES: 5817899.8889
            EXTRA_META_BYTES: 0
               TABLET_COUNT: 1285
        FINISH_TABLET_COUNT: 1285
          MACRO_BLOCK_COUNT: 270
   FINISH_MACRO_BLOCK_COUNT: 270
                 FILE_COUNT: 0
               META_TURN_ID: 1
               DATA_TURN_ID: 1
                     RESULT: 0
                    COMMENT:
                       PATH: file:///data/nfs/backup/data

   ```

   `oceanbase.CDB_OB_BACKUP_JOB_HISTORY` 视图中的各字段基本与 `oceanbase.CDB_OB_BACKUP_JOBS` 视图相对应， `oceanbase.CDB_OB_BACKUP_TASK_HISTORY` 各字段基本与 `oceanbase.CDB_OB_BACKUP_TASKS` 相对应。其中， `COMMENT` 用于记录任务失败时的相关错误信息。

   更多 `CDB_OB_BACKUP_JOB_HISTORY` 和 `CDB_OB_BACKUP_TASK_HISTORY` 视图的说明，请参见 [CDB_OB_BACKUP_JOB_HISTORY](https://www.oceanbase.com/docs/enterprise-oceanbase-database-cn-10000000000885362) 和 [CDB_OB_BACKUP_TASK_HISTORY](https://www.oceanbase.com/docs/enterprise-oceanbase-database-cn-10000000000885366)。
 3. 查看对应的备份集信息。

   ```sql
   obclient> SELECT * FROM oceanbase.CDB_OB_BACKUP_SET_FILES WHERE backup_set_id = 1 AND tenant_id = 1004\G
   *************************** 1. row ***************************
                    TENANT_ID: 1002
                BACKUP_SET_ID: 1
                      DEST_ID: 1001
                  INCARNATION: 1
                  BACKUP_TYPE: FULL
      PREV_FULL_BACKUP_SET_ID: 0
       PREV_INC_BACKUP_SET_ID: 0
              START_TIMESTAMP: 2022-06-01 16:54:26.007298
                END_TIMESTAMP: 2022-06-01 16:56:03.576909
                       STATUS: SUCCESS
                  FILE_STATUS: AVAILABLE
             ELAPSED_SECONDES: 469
              PLUS_ARCHIVELOG: OFF
             START_REPLAY_SCN: 0
     START_REPLAY_SCN_DISPLAY:
              MIN_RESTORE_SCN: 1662389318902587000
      MIN_RESTORE_SCN_DISPLAY: 2022-06-01 16:55:03.902587
                  INPUT_BYTES: 567650229
                 OUTPUT_BYTES: 567650229
            OUTPUT_RATE_BYTES: 5817899.8889
             EXTRA_META_BYTES: 0
                 TABLET_COUNT: 1285
          FINISH_TABLET_COUNT: 1285
            MACRO_BLOCK_COUNT: 270
     FINISH_MACRO_BLOCK_COUNT: 270
                   FILE_COUNT: 0
                 META_TURN_ID: 1
                 DATA_TURN_ID: 1
                       RESULT: 0
                      COMMENT:
              ENCRYPTION_MODE: NONE
                       PASSWD:
            TENANT_COMPATIBLE: 4.0.0.0
            BACKUP_COMPATIBLE: 0
                         PATH: file:///data/nfs/backup/data

   ```

   更多 `CDB_OB_BACKUP_SET_FILES` 视图的说明，请参见 [CDB_OB_BACKUP_SET_FILES](https://www.oceanbase.com/docs/enterprise-oceanbase-database-cn-10000000000885358)。

 上一篇 下一篇 ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线