Note
- For V4.4.2, this view is available starting with V4.4.2 BP2.
- For V4.6.x, this view is available starting with V4.6.0.
Overview
The oceanbase.DBA_OB_BACKUP_VALIDATE_JOBS view displays information related to job-level backup verification tasks initiated by the current tenant. Each job corresponds to a backup verification 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 verification tasks need to be executed. If this value is empty, it indicates that the verification task is being executed by the current tenant. |
| 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. Valid values:
|
| 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 and archive paths 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 information about the job-level backup verification tasks initiated by the current tenant.
obclient(root@mysql001)[oceanbase]> SELECT * FROM oceanbase.DBA_OB_BACKUP_VALIDATE_JOBS\G
The query result is as follows:
*************************** 1. row ***************************
JOB_ID: 10
INCARNATION: 1
INITIATOR_TENANT_ID: 1
INITIATOR_JOB_ID: 7
EXECUTOR_TENANT_ID:
TYPE: BACKUPSET
PATH:
PATH_TYPE:
ID:
VALIDATE_LEVEL: basic
START_TIMESTAMP: 2026-03-03 16:05:10.017329
END_TIMESTAMP: NULL
STATUS: DOING
RETRY_COUNT: 0
TASK_COUNT: 3
SUCCESS_TASK_COUNT: 0
RESULT: 0
DESCRIPTION:
COMMENT:
1 row in set
References
View the execution history of job-level backup validation tasks for the current tenant: DBA_OB_BACKUP_VALIDATE_JOB_HISTORY
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: