Note
This view is available starting with V4.6.0.
Purpose
The oceanbase.CDB_OB_BACKUP_VALIDATE_JOB_HISTORY view displays the execution history of job-level backup validation tasks initiated by all tenants. Each job corresponds to a backup validation instruction. If an instruction involves multiple user tenants, the view may contain multiple sub-jobs at the user tenant level.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The tenant ID of the tenant that initiated the validation task. |
| JOB_ID | bigint(20) | NO | The task ID. |
| INCARNATION | bigint(20) | NO | The incarnation ID. |
| INITIATOR_TENANT_ID | bigint(20) | NO | The tenant ID of the tenant that initiated the job. |
| INITIATOR_JOB_ID | bigint(20) | NO | The job ID of the job that initiated the current job. If the value is 0, it indicates that the current job was initiated by itself. |
| EXECUTOR_TENANT_ID | varchar(65536) | NO | The tenant ID of the user tenant that needs to execute the validation task for the current job. If the value is 0, it indicates that the current tenant is executing the validation task. |
| TYPE | varchar(64) | NO | The type of the validation task. Valid values:
|
| PATH | longtext | YES | The backup path or log archive path specified by the user for validation. If the value is empty, it indicates that the task is not for a specified path. |
| PATH_TYPE | varchar(64) | YES | The type of the specified path for validation (if the value is empty, it indicates that the task is not for a specified path). Valid values:
|
| ID | longtext | YES | The If the value is empty, it indicates that the task validates all backup sets and log archive pieces under the current backup path and archive path. When the user specifies the |
| VALIDATE_LEVEL | varchar(64) | NO | The validation level. Valid values:
|
| START_TIMESTAMP | timestamp(6) | NO | The start time of the validation task. |
| END_TIMESTAMP | timestamp(6) | NO | The end time of the validation task. |
| STATUS | varchar(64) | NO | The job status. Valid values:
|
| RETRY_COUNT | bigint(20) | YES | The number of retries. |
| TASK_COUNT | bigint(20) | YES | The total number of validation tasks for the backup set or log archive piece. |
| SUCCESS_TASK_COUNT | bigint(20) | YES | The number of successful validation tasks for the backup set or log archive piece. |
| RESULT | bigint(20) | NO | The error code of the validation result. |
| DESCRIPTION | varchar(4096) | YES | The external information provided by OCP. |
| COMMENT | varchar(4096) | YES | The description of the reason why the validation task failed. |
Sample query
Query the execution history of job-level backup validation tasks initiated by all tenants as the sys tenant.
obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.CDB_OB_BACKUP_VALIDATE_JOB_HISTORY\G
The query result is as follows:
*************************** 1. row ***************************
TENANT_ID: 1002
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
DESCRIPTION:
COMMENT: all archive pieces are not support for backup validate or not find any piece
1 row in set
References
View the information about all job-level backup validation tasks: CDB_OB_BACKUP_VALIDATE_JOBS
View the information about all task-level backup validation tasks: