Note
- For V4.4.2, this view is available starting with V4.4.2 BP2.
- For V4.6.x versions, this view is available starting from V4.6.0.
Overview
The oceanbase.CDB_OB_BACKUP_VALIDATE_JOBS view displays information about all job-level backup validation tasks initiated by tenants. Each job corresponds to a backup validation command. If a backup validation command involves multiple user tenants, the view may show multiple sub-jobs at the user tenant level.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID, the ID of the tenant for which the validation task is being executed. |
| JOB_ID | bigint(20) | NO | Task ID |
| INCARNATION | bigint(20) | NO | Incarnation 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 validation tasks need to be executed. If the value is 0, it indicates that the current tenant performs the validation task. |
| TYPE | varchar(64) | NO | Validation task type:
|
| PATH | longtext | YES | The backup path or log archive path specified for validation. If the value is empty, it indicates that this task is for validating non-specified paths. |
| PATH_TYPE | varchar(64) | YES | Type of validation to perform under the specified path. If the value is empty, the task is a non-path-specific validation:
|
| ID | longtext | YES | The By default, this value is empty, indicating all backup sets and log archive pieces under the current backup and archive paths. When you specify |
| VALIDATE_LEVEL | varchar(64) | NO | Validation level:
|
| START_TIMESTAMP | timestamp(6) | NO | Start time of the validation task |
| END_TIMESTAMP | timestamp(6) | NO | End time of the validation task |
| STATUS | varchar(64) | NO | Job status:
|
| RETRY_COUNT | bigint(20) | YES | Retry Count |
| TASK_COUNT | bigint(20) | YES | Total validation tasks for backup sets or log archive pieces |
| SUCCESS_TASK_COUNT | bigint(20) | YES | Number of Tasks with successful piece validation for backup sets or log archive pieces |
| RESULT | bigint(20) | NO | Error code information of the validation result |
| DESCRIPTION | varchar(4096) | YES | External information provided by OCP |
| COMMENT | varchar(4096) | YES | Reason description for the validation task failure |
Sample query
Query information about job-level backup validation tasks initiated by all tenants in the sys tenant.
obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.CDB_OB_BACKUP_VALIDATE_JOBS\G
The query result is as follows:
*************************** 1. row ***************************
TENANT_ID: 1
JOB_ID: 5
INCARNATION: 1
INITIATOR_TENANT_ID: 1
INITIATOR_JOB_ID: 0
EXECUTOR_TENANT_ID: 1002
TYPE: BACKUPSET
PATH:
PATH_TYPE:
ID: 1,2
VALIDATE_LEVEL: physical
START_TIMESTAMP: 2026-03-03 14:43:58.603856
END_TIMESTAMP: NULL
STATUS: DOING
RETRY_COUNT: 0
TASK_COUNT: 0
SUCCESS_TASK_COUNT: 0
RESULT: 0
DESCRIPTION:
COMMENT:
*************************** 2. row ***************************
TENANT_ID: 1002
JOB_ID: 8
INCARNATION: 1
INITIATOR_TENANT_ID: 1
INITIATOR_JOB_ID: 5
EXECUTOR_TENANT_ID:
TYPE: BACKUPSET
PATH:
PATH_TYPE:
ID: 1,2
VALIDATE_LEVEL: physical
START_TIMESTAMP: 2026-03-03 14:43:58.616794
END_TIMESTAMP: NULL
STATUS: DOING
RETRY_COUNT: 0
TASK_COUNT: 3
SUCCESS_TASK_COUNT: 0
RESULT: 0
DESCRIPTION:
COMMENT:
2 rows in set
References
View the execution history of all tenant job-level backup validation tasks: CDB_OB_BACKUP_VALIDATE_JOB_HISTORY
View all tenant task-level backup validation tasks: