oceanbase.DBA_OB_BACKUP_VALIDATE_TASK_HISTORY

更新时间：2026-07-15 15:16:39

说明

该视图从 V4.6.0 版本开始引入。

功能描述

视图 oceanbase.DBA_OB_BACKUP_VALIDATE_TASK_HISTORY 用于展示本租户发起的备份校验 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 状态： `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 级备份校验任务的执行历史。

obclient(root@mysql001)[oceanbase]> SELECT * FROM oceanbase.DBA_OB_BACKUP_VALIDATE_TASK_HISTORY\G

查询结果如下：

*************************** 1. row ***************************
        TENANT_ID: 1002
          TASK_ID: 3
      INCARNATION: 1
           JOB_ID: 2
        TASK_TYPE: BACKUPSET
               ID: 1
             PATH: file:///data/nfs/backup/data/backup_set_1_full
        PATH_TYPE: BACKUP_SET_DEST
  PLUS_ARCHIVELOG: OFF
          DEST_ID: 1002
INITIATOR_TASK_ID: 0
   VALIDATE_LEVEL: basic
         ROUND_ID: 0
  START_TIMESTAMP: 2026-03-03 13:58:07.802366
    END_TIMESTAMP: 2026-03-03 13:58:09.860637
           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: 5
      INCARNATION: 1
           JOB_ID: 4
        TASK_TYPE: BACKUPSET
               ID: 1
             PATH: file:///data/nfs/backup/data/backup_set_1_full
        PATH_TYPE: BACKUP_SET_DEST
  PLUS_ARCHIVELOG: OFF
          DEST_ID: 1002
INITIATOR_TASK_ID: 0
   VALIDATE_LEVEL: basic
         ROUND_ID: 0
  START_TIMESTAMP: 2026-03-03 14:15:56.418858
    END_TIMESTAMP: 2026-03-03 14:15:57.747809
           STATUS: COMPLETED
   TOTAL_LS_COUNT: 2
  FINISH_LS_COUNT: 2
      TOTAL_BYTES: 21126037
  VALIDATED_BYTES: 0
           RESULT: 0
          COMMENT:
*************************** 3. row ***************************
        TENANT_ID: 1002
          TASK_ID: 6
      INCARNATION: 1
           JOB_ID: 4
        TASK_TYPE: BACKUPSET
               ID: 2
             PATH: file:///data/nfs/backup/data/backup_set_2_full
        PATH_TYPE: BACKUP_SET_DEST
  PLUS_ARCHIVELOG: ON
          DEST_ID: 1002
INITIATOR_TASK_ID: 0
   VALIDATE_LEVEL: basic
         ROUND_ID: 0
  START_TIMESTAMP: 2026-03-03 14:15:56.422935
    END_TIMESTAMP: 2026-03-03 14:15:59.819297
           STATUS: COMPLETED
   TOTAL_LS_COUNT: 2
  FINISH_LS_COUNT: 2
      TOTAL_BYTES: 19295388
  VALIDATED_BYTES: 0
           RESULT: 0
          COMMENT:
*************************** 4. row ***************************
        TENANT_ID: 1002
          TASK_ID: 10
      INCARNATION: 1
           JOB_ID: 5
        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
  PLUS_ARCHIVELOG: ON
          DEST_ID: 1002
INITIATOR_TASK_ID: 9
   VALIDATE_LEVEL: physical
         ROUND_ID: 1
  START_TIMESTAMP: 2026-03-03 14:25:03.801253
    END_TIMESTAMP: 2026-03-03 14:25:09.858472
           STATUS: COMPLETED
   TOTAL_LS_COUNT: 0
  FINISH_LS_COUNT: 0
      TOTAL_BYTES: 0
  VALIDATED_BYTES: 0
           RESULT: 0
          COMMENT:
*************************** 5. row ***************************
        TENANT_ID: 1002
          TASK_ID: 11
      INCARNATION: 1
           JOB_ID: 5
        TASK_TYPE: ARCHIVELOG_PIECE
               ID: 1
             PATH: file:///data/nfs/backup/archive/piece_d1001r1p1
        PATH_TYPE: ARCHIVELOG_PIECE_DEST
  PLUS_ARCHIVELOG: OFF
          DEST_ID: 1001
INITIATOR_TASK_ID: 0
   VALIDATE_LEVEL: physical
         ROUND_ID: 1
  START_TIMESTAMP: 2026-03-03 14:25:03.803568
    END_TIMESTAMP: 2026-03-03 14:25:12.689523
           STATUS: COMPLETED
   TOTAL_LS_COUNT: 2
  FINISH_LS_COUNT: 2
      TOTAL_BYTES: 0
  VALIDATED_BYTES: 67535470
           RESULT: 0
          COMMENT:
5 rows in set

oceanbase.DBA_OB_BACKUP_VALIDATE_TASK_HISTORY

说明

功能描述

字段说明

查询示例

相关视图或文档