Note
This view is available starting with V4.6.0.
Purpose
The oceanbase.DBA_OB_BACKUP_VALIDATE_JOBS view displays information about backup validation jobs initiated by the current tenant. Each job corresponds to a backup validation instruction.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| JOB_ID | bigint(20) | NO | The job ID. |
| INCARNATION | bigint(20) | NO | The incarnation ID. |
| INITIATOR_TENANT_ID | bigint(20) | NO | The ID of the tenant that initiated the job. |
| INITIATOR_JOB_ID | bigint(20) | NO | The ID of the job that initiated the job. If the value is 0, the job was initiated by itself. |
| EXECUTOR_TENANT_ID | varchar(65536) | NO | The ID of the user tenant that needs to execute the validation task for this job. If the value is empty, the validation task is executed by the current tenant. |
| TYPE | varchar(64) | NO | The type of the validation task:
|
| PATH | longtext | YES | The backup path or archive log path specified by the user for validation. If the value is empty, the task is for validating the entire backup path and archive path. |
| PATH_TYPE | varchar(64) | YES | The type of the specified path for validation (if the value is empty, the task is for validating the entire backup path and archive path):
|
| ID | longtext | YES | The By default, this value is empty, indicating that all backup sets and archive log pieces in the current backup path and archive path will be validated. When the user specifies the |
| VALIDATE_LEVEL | varchar(64) | NO | The validation level:
|
| 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 status of the job:
|
| 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 archive log piece. |
| SUCCESS_TASK_COUNT | bigint(20) | YES | The number of successful validation tasks for the backup set or archive log piece. |
| RESULT | bigint(20) | NO | The error code of the validation result. |
| DESCRIPTION | varchar(4096) | YES | External information provided by OCP. |
| COMMENT | varchar(4096) | YES | The description of the reason for the failure of the validation task. |
Sample query
Query the information about backup validation jobs initiated by the current user 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 backup validation jobs initiated by the current tenant: DBA_OB_BACKUP_VALIDATE_JOB_HISTORY
View the information about backup validation tasks initiated by the current tenant:
View the information about backup validation jobs initiated by all tenants:
CDB_OB_BACKUP_VALIDATE_JOBS
CDB_OB_BACKUP_VALIDATE_JOB_HISTORY
View the information about backup validation tasks initiated by all tenants:
CDB_OB_BACKUP_VALIDATE_TASKS
CDB_OB_BACKUP_VALIDATE_TASK_HISTORY