Note
- For V4.4.2, this view is available starting from V4.4.2 BP2.
- For V4.6.x, this view is available starting from V4.6.0.
Overview
The oceanbase.DBA_OB_BACKUP_VALIDATE_JOBS view displays information related to 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 | 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 the validation task needs to be executed. If the value is empty, it indicates that the current tenant is performing 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 under the user-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
You can view information about the job-level backup validation tasks initiated by the current tenant.
obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.DBA_OB_BACKUP_VALIDATE_JOBS\G
The query result is as follows:
*************************** 1. row ***************************
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:
1 row in set
References
View all tenant job-level backup validation tasks:
View all tenant task-level backup validation tasks: