Note
- For V4.4.2, this view is available starting from V4.4.2 BP2.
- For V4.6.x versions, this view is available starting from V4.6.0.
Overview
The oceanbase.DBA_OB_BACKUP_VALIDATE_JOB_HISTORY view displays the execution history of job-level backup validation tasks initiated by the current tenant. Each job corresponds to a backup validation command.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| JOB_ID | bigint(20) | NO | Task ID |
| INCARNATION | bigint(20) | NO | Avatar ID |
| INITIATOR_TENANT_ID | bigint(20) | NO | Tenant ID that initiated the job |
| INITIATOR_JOB_ID | bigint(20) | NO | The job ID that initiated this job. If the value is 0, it indicates that the current job initiated this job. |
| EXECUTOR_TENANT_ID | varchar(65536) | NO | The tenant ID of the user tenant for which the verification task needs to be executed. If the value is empty, it indicates that the current tenant is performing the verification task. |
| TYPE | varchar(64) | NO | Verification task type:
|
| PATH | longtext | YES | The backup path or log archive path specified for verification. If the value is empty, it indicates that this task is for verifying non-specified paths. |
| PATH_TYPE | varchar(64) | YES | Type of verification under the specified path. If the value is empty, the task is a non-path-specific verification:
|
| ID | longtext | YES | The backup set to be verified is The default value is empty, indicating that all backup sets and log archive pieces under the current backup path and archive path are to be verified. When you specify to verify backup sets of |
| VALIDATE_LEVEL | varchar(64) | NO | Verification Level:
|
| START_TIMESTAMP | timestamp(6) | NO | Start Time of Verification Task |
| END_TIMESTAMP | timestamp(6) | NO | End time of the verification task |
| STATUS | varchar(64) | NO | Job status:
|
| RETRY_COUNT | bigint(20) | YES | Retry Count |
| TASK_COUNT | bigint(20) | YES | Total Verification Tasks for Backup Sets or Log Archiving Pieces |
| SUCCESS_TASK_COUNT | bigint(20) | YES | Number of Tasks with Successful Piece Verification for Backup Sets or Log Archiving |
| RESULT | bigint(20) | NO | Error code information of the verification result |
| DESCRIPTION | varchar(4096) | YES | External information provided by OCP |
| COMMENT | varchar(4096) | YES | Reason description for the verification task failure |
Sample query
You can view the execution history of job-level backup verification tasks initiated by the current tenant.
obclient(root@mysql001)[oceanbase]> SELECT * FROM oceanbase.DBA_OB_BACKUP_VALIDATE_JOB_HISTORY\G
The query result is as follows:
*************************** 1. row ***************************
JOB_ID: 2
INCARNATION: 1
INITIATOR_TENANT_ID: 1002
INITIATOR_JOB_ID: 0
EXECUTOR_TENANT_ID:
TYPE: DATABASE
PATH:
PATH_TYPE:
ID:
VALIDATE_LEVEL: basic
START_TIMESTAMP: 2026-03-03 13:58:07.778690
END_TIMESTAMP: 2026-03-03 13:58:09.864257
STATUS: COMPLETED
RETRY_COUNT: 0
TASK_COUNT: 1
SUCCESS_TASK_COUNT: 1
RESULT: 0
COMMENT: all archive pieces are not support for backup validate or not find any piece
DESCRIPTION:
*************************** 2. row ***************************
JOB_ID: 4
INCARNATION: 1
INITIATOR_TENANT_ID: 1
INITIATOR_JOB_ID: 1
EXECUTOR_TENANT_ID:
TYPE: DATABASE
PATH:
PATH_TYPE:
ID:
VALIDATE_LEVEL: basic
START_TIMESTAMP: 2026-03-03 14:15:56.389026
END_TIMESTAMP: 2026-03-03 14:18:59.846956
STATUS: COMPLETED
RETRY_COUNT: 0
TASK_COUNT: 3
SUCCESS_TASK_COUNT: 3
RESULT: 0
COMMENT: all archive pieces are not support for backup validate or not find any piece
DESCRIPTION:
*************************** 3. row ***************************
JOB_ID: 5
INCARNATION: 1
INITIATOR_TENANT_ID: 1
INITIATOR_JOB_ID: 2
EXECUTOR_TENANT_ID:
TYPE: DATABASE
PATH:
PATH_TYPE:
ID:
VALIDATE_LEVEL: physical
START_TIMESTAMP: 2026-03-03 14:25:03.764490
END_TIMESTAMP: 2026-03-03 14:25:12.691621
STATUS: COMPLETED
RETRY_COUNT: 0
TASK_COUNT: 4
SUCCESS_TASK_COUNT: 4
RESULT: 0
COMMENT:
DESCRIPTION:
3 rows in set
References
View information about job-level backup validation tasks for the current tenant: DBA_OB_BACKUP_VALIDATE_JOBS
View task-level backup verification tasks for the current tenant:
View all tenant job-level backup verification tasks:
View all tenant task-level backup verification tasks: