--- title: "查看数据备份结果 - OceanBase 数据库 V4.2.1 | OceanBase 文档中心" description: "查看数据备份结果 数据备份执行完成后，您可以通过视图查看备份任务历史。 系统租户查看数据备份任务历史 使用 root 用户登录集群的 sys 租户。 查看数据备份历史。 查看 JOB 级任务历史 租户发起一次备份即对应一条 JOB 任务记录。 obclient [oceanbase]> SELECT * FROM o…" --- 切换语言 - 中文站 - 简体中文 - International - English - 日本站 - 日本語 文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 4.2.1 LTS # 查看数据备份结果 更新时间：2026-04-16 00:11:36 [编辑](https://github.com/oceanbase/oceanbase-doc/edit/V4.2.1/zh-CN/600.manage/600.backup-and-recovery/400.data-backup/600.view-data-backup-history.md) 数据备份执行完成后，您可以通过视图查看备份任务历史。 ## 系统租户查看数据备份任务历史 1. 使用 `root` 用户登录集群的 `sys` 租户。 2. 查看数据备份历史。 - 查看 JOB 级任务历史 租户发起一次备份即对应一条 JOB 任务记录。 ```sql obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_BACKUP_JOB_HISTORY\G ``` 查询结果如下： ```shell *************************** 1. row *************************** TENANT_ID: 1002 JOB_ID: 1 INCARNATION: 1 BACKUP_SET_ID: 1 INITIATOR_TENANT_ID: 1002 INITIATOR_JOB_ID: 0 EXECUTOR_TENANT_ID: 1002 PLUS_ARCHIVELOG: OFF BACKUP_TYPE: FULL JOB_LEVEL: USER_TENANT ENCRYPTION_MODE: NONE PASSWD: START_TIMESTAMP: 2024-01-31 11:20:59.804836 END_TIMESTAMP: 2024-01-31 11:23:08.773566 STATUS: COMPLETED RESULT: 0 COMMENT: DESCRIPTION: PATH: file:///data/nfs/backup/data *************************** 2. row *************************** TENANT_ID: 1002 JOB_ID: 2 INCARNATION: 1 BACKUP_SET_ID: 2 INITIATOR_TENANT_ID: 1002 INITIATOR_JOB_ID: 0 EXECUTOR_TENANT_ID: 1002 PLUS_ARCHIVELOG: OFF BACKUP_TYPE: INC JOB_LEVEL: USER_TENANT ENCRYPTION_MODE: NONE PASSWD: START_TIMESTAMP: 2024-01-31 13:47:57.218929 END_TIMESTAMP: 2024-01-31 13:50:14.985358 STATUS: COMPLETED RESULT: 0 COMMENT: DESCRIPTION: PATH: file:///data/nfs/backup/data 2 rows in set ``` - 查看 Task 级任务历史 一个 Task 对应一个备份集的任务。 ```sql obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_BACKUP_TASK_HISTORY\G ``` 查询结果如下： ```shell *************************** 1. row *************************** TENANT_ID: 1002 TASK_ID: 1 JOB_ID: 1 INCARNATION: 1 BACKUP_SET_ID: 1 START_TIMESTAMP: 2024-01-31 11:20:59.804836 END_TIMESTAMP: 2024-01-31 11:23:08.762451 STATUS: COMPLETED START_SCN: 1706671262627179000 END_SCN: 1706671388756316000 USER_LS_START_SCN: 1706671278153636000 ENCRYPTION_MODE: NONE PASSWD: INPUT_BYTES: 198130272 OUTPUT_BYTES: 16984419 OUTPUT_RATE_BYTES: 131705.4367 EXTRA_META_BYTES: 0 TABLET_COUNT: 617 FINISH_TABLET_COUNT: 617 MACRO_BLOCK_COUNT: 94 FINISH_MACRO_BLOCK_COUNT: 94 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 *************************** 2. row *************************** TENANT_ID: 1002 TASK_ID: 2 JOB_ID: 2 INCARNATION: 1 BACKUP_SET_ID: 2 START_TIMESTAMP: 2024-01-31 13:47:57.218929 END_TIMESTAMP: 2024-01-31 13:50:14.974017 STATUS: COMPLETED START_SCN: 1706680089128492000 END_SCN: 1706680214967798000 USER_LS_START_SCN: 1706680104341550000 ENCRYPTION_MODE: NONE PASSWD: INPUT_BYTES: 42941657 OUTPUT_BYTES: 14592769 OUTPUT_RATE_BYTES: 105932.7043 EXTRA_META_BYTES: 0 TABLET_COUNT: 617 FINISH_TABLET_COUNT: 617 MACRO_BLOCK_COUNT: 20 FINISH_MACRO_BLOCK_COUNT: 20 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 2 rows in set ``` `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/common-oceanbase-database-cn-1000000000219565) 和 [CDB_OB_BACKUP_TASK_HISTORY](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000000219540)。 3. 查看对应的备份集信息。 ```sql obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_BACKUP_SET_FILES WHERE TENANT_ID = 1002 AND BACKUP_SET_ID = 1\G ``` 查询结果如下： ```shell *************************** 1. row *************************** TENANT_ID: 1002 BACKUP_SET_ID: 1 DEST_ID: 1002 INCARNATION: 1 BACKUP_TYPE: FULL PREV_FULL_BACKUP_SET_ID: 0 PREV_INC_BACKUP_SET_ID: 0 START_TIMESTAMP: 2024-01-31 11:20:59.804836 END_TIMESTAMP: 2024-01-31 11:23:08.762451 STATUS: SUCCESS FILE_STATUS: AVAILABLE ELAPSED_SECONDES: 129 PLUS_ARCHIVELOG: OFF START_REPLAY_SCN: 1706670992366131000 START_REPLAY_SCN_DISPLAY: 2024-01-31 11:16:32.366131 MIN_RESTORE_SCN: 1706671388756316000 MIN_RESTORE_SCN_DISPLAY: 2024-01-31 11:23:08.756316000 INPUT_BYTES: 198130272 OUTPUT_BYTES: 16984419 OUTPUT_RATE_BYTES: 131705.4367 EXTRA_META_BYTES: 0 TABLET_COUNT: 617 FINISH_TABLET_COUNT: 617 MACRO_BLOCK_COUNT: 94 FINISH_MACRO_BLOCK_COUNT: 94 FILE_COUNT: 0 META_TURN_ID: 1 DATA_TURN_ID: 0 RESULT: 0 COMMENT: ENCRYPTION_MODE: NONE PASSWD: TENANT_COMPATIBLE: 4.2.2.0 BACKUP_COMPATIBLE: 3 PATH: file:///data/nfs/backup/data CLUSTER_VERSION: 4.2.2.0 CONSISTENT_SCN: 1706671288404894000 MINOR_TURN_ID: 1 MAJOR_TURN_ID: 1 1 row in set ``` 更多 `CDB_OB_BACKUP_SET_FILES` 视图的说明，请参见 [CDB_OB_BACKUP_SET_FILES](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000000219483)。 ## 用户租户查看数据备份任务历史 1. 租户管理员登录到数据库。 2. 查看数据备份历史。 MySQL 模式 Oracle 模式 MySQL 模式下的查询示例如下： ```sql obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_BACKUP_JOB_HISTORY\G ``` Oracle 模式下的查询示例如下： ```sql obclient [SYS]> SELECT * FROM SYS.DBA_OB_BACKUP_TASK_HISTORY\G ```sql obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_BACKUP_TASK_HISTORY\G ``` ``` 3. 查看对应的备份集信息。 ```sql obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_BACKUP_SET_FILES WHERE BACKUP_SET_ID = 1 \G ``` ```sql obclient [SYS]> SELECT * FROM SYS.DBA_OB_BACKUP_SET_FILES WHERE BACKUP_SET_ID = 1 \G ``` 上一篇 下一篇 ![有帮助](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) 咨询热线