--- title: "oceanbase.DBA_OB_BACKUP_VALIDATE_TASKS - OceanBase 数据库 V4.6.0 | OceanBase 文档中心" description: oceanbase.DBA_OB_BACKUP_VALIDATE_TASKS 说明 该视图从 V4.6.0 版本开始引入。 功能描述 视图 oceanbase.DBA_OB_BACKUP_VALIDATE_TASKS 用于展示本租户发起的备份校验 Task 级任务的相关信息。每个 Task 对应一个备份集或日志归档 … image: https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*OSPzQ6GUQF4AAAAAQHAAAAgAeiGDAQ/original --- 切换语言 - 中文站 - 简体中文 - International - English - 日本站 - 日本語 文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 4.6.0 # oceanbase.DBA_OB_BACKUP_VALIDATE_TASKS 更新时间：2026-07-15 15:16:39 [编辑](https://github.com/oceanbase/oceanbase-doc/edit/V4.6.0/zh-CN/700.reference/700.system-views/400.system-view-of-mysql-mode/200.dictionary-view-of-mysql-mode/7640.o-dba_ob_backup_validate_tasks-of-mysql-mode.md) #### 说明 该视图从 V4.6.0 版本开始引入。 ## 功能描述 视图 `oceanbase.DBA_OB_BACKUP_VALIDATE_TASKS` 用于展示本租户发起的备份校验 Task 级任务的相关信息。每个 Task 对应一个备份集或日志归档 Piece 校验任务。 ## 字段说明 | 字段名称 | 类型 | 是否可以为 NULL | 描述 | | --- | --- | --- | --- | | TASK_ID | bigint(20) | NO | 任务的 task_id | | INCARNATION | bigint(20) | NO | 分身 ID | | JOB_ID | bigint(20) | NO | 任务的 job_id | | TASK_TYPE | varchar(64) | NO | 校验任务类型： - `BACKUPSET`：校验指定的备份集 - `ARCHIVELOG_PIECE`：校验指定的日志归档 Piece | | ID | bigint(20) | YES | 校验的备份集的 `backup_set_id` 或归档 Piece 的 `piece_id` | | PATH | longtext | YES | 校验的备份路径或日志归档路径 | | PATH_TYPE | varchar(64) | YES | 校验的路径类型： - `BACKUP_SET_DEST`：数据备份路径 - `ARCHIVELOG_PIECE_DEST`：日志归档路径 | | DEST_ID | bigint(20) | YES | 校验的备份路径或归档路径的 ID | | PLUS_ARCHIVELOG | varchar(64) | NO | 是否包含补偿日志 | | INITIATOR_TASK_ID | bigint(20) | NO | 补偿日志校验任务的父 task_id，否则为 0 | | VALIDATE_LEVEL | varchar(64) | NO | 校验等级： - `basic`：仅检查文件列表的完整性。 - `physical`：检查物理数据的正确性及逻辑一致性。 | | ROUND_ID | bigint(20) | NO | 校验日志归档 Piece 时所属的 Round ID，否则为 0 | | START_TIMESTAMP | timestamp(6) | NO | 校验任务的开始时间 | | END_TIMESTAMP | timestamp(6) | NO | 校验任务的结束时间 | | STATUS | varchar(64) | NO | Task 状态： - `INIT`：校验任务正在初始化 - `DOING`：校验任务正在执行中 - `COMPLETED`：校验任务已执行完成 - `FAILED`：校验任务执行失败 - `CANCELED`：校验任务已取消 | | TOTAL_LS_COUNT | bigint(20) | YES | Task 所包含的日志流数 | | FINISH_LS_COUNT | bigint(20) | YES | 已校验完成的日志流数 | | TOTAL_BYTES | bigint(20) | YES | 预计需要校验的数据量，单位为字节 | | VALIDATED_BYTES | bigint(20) | YES | 已完成校验的数据量，单位为字节 | | RESULT | bigint(20) | NO | 校验结果的错误码信息 | | COMMENT | varchar(4096) | YES | 校验任务失败的原因描述 | ## 查询示例 用户租户查看本租户发起的 Task 级备份校验任务的相关信息。 ```shell obclient(root@mysql001)[oceanbase]> SELECT * FROM oceanbase.DBA_OB_BACKUP_VALIDATE_TASKS\G ``` 查询结果如下： ```shell *************************** 1. row *************************** TENANT_ID: 1002 TASK_ID: 21 INCARNATION: 1 JOB_ID: 10 TASK_TYPE: BACKUPSET ID: 1 PATH: file:///data/nfs/backup/data/backup_set_1_full PATH_TYPE: BACKUP_SET_DEST DEST_ID: 1002 PLUS_ARCHIVELOG: OFF INITIATOR_TASK_ID: 0 VALIDATE_LEVEL: basic ROUND_ID: 0 START_TIMESTAMP: 2026-03-03 16:05:10.038803 END_TIMESTAMP: 2026-03-03 16:05:11.774651 STATUS: COMPLETED TOTAL_LS_COUNT: 2 FINISH_LS_COUNT: 2 TOTAL_BYTES: 21126037 VALIDATED_BYTES: 0 RESULT: 0 COMMENT: *************************** 2. row *************************** TENANT_ID: 1002 TASK_ID: 22 INCARNATION: 1 JOB_ID: 10 TASK_TYPE: BACKUPSET ID: 2 PATH: file:///data/nfs/backup/data/backup_set_2_full PATH_TYPE: BACKUP_SET_DEST DEST_ID: 1002 PLUS_ARCHIVELOG: ON INITIATOR_TASK_ID: 0 VALIDATE_LEVEL: basic ROUND_ID: 0 START_TIMESTAMP: 2026-03-03 16:05:10.044946 END_TIMESTAMP: 2026-03-03 16:05:13.850183 STATUS: COMPLETED TOTAL_LS_COUNT: 2 FINISH_LS_COUNT: 2 TOTAL_BYTES: 19295388 VALIDATED_BYTES: 0 RESULT: 0 COMMENT: *************************** 3. row *************************** TENANT_ID: 1002 TASK_ID: 23 INCARNATION: 1 JOB_ID: 10 TASK_TYPE: ARCHIVELOG_PIECE ID: 1 PATH: file:///data/nfs/backup/data/backup_set_2_full/complement_log/piece_d1002r1p1 PATH_TYPE: ARCHIVELOG_PIECE_DEST DEST_ID: 1002 PLUS_ARCHIVELOG: ON INITIATOR_TASK_ID: 22 VALIDATE_LEVEL: basic ROUND_ID: 1 START_TIMESTAMP: 2026-03-03 16:05:10.047825 END_TIMESTAMP: 2026-03-03 16:05:13.856278 STATUS: COMPLETED TOTAL_LS_COUNT: 0 FINISH_LS_COUNT: 0 TOTAL_BYTES: 0 VALIDATED_BYTES: 0 RESULT: 0 COMMENT: 3 rows in set ``` ## 相关视图或文档 - 查看本租户 Task 级备份校验任务的执行历史：[DBA_OB_BACKUP_VALIDATE_TASK_HISTORY](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000005684742) - 查看本租户 Job 级备份校验任务： - [DBA_OB_BACKUP_VALIDATE_JOBS](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000005684650) - [DBA_OB_BACKUP_VALIDATE_JOB_HISTORY](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000005684724) - 查看所有租户 Job 级备份校验任务： - [CDB_OB_BACKUP_VALIDATE_JOBS](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000005684073) - [CDB_OB_BACKUP_VALIDATE_JOB_HISTORY](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000005684043) - 查看所有租户 Task 级备份校验任务： - [CDB_OB_BACKUP_VALIDATE_TASKS](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000005684171) - [CDB_OB_BACKUP_VALIDATE_TASK_HISTORY](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000005684115) - [查看备份校验进度](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000005682421) 上一篇 下一篇 ![有帮助](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) 咨询热线