Note
This view is available starting with V4.6.0.
Purpose
The oceanbase.DBA_OB_BACKUP_VALIDATE_JOBS view displays information about backup validation tasks initiated by the current tenant. Each job corresponds to a backup validation instruction.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| JOB_ID | bigint(20) | NO | The task 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 job ID of the job that initiated the job. If the value is 0, the current job initiated the job. |
| EXECUTOR_TENANT_ID | varchar(65536) | NO | The tenant ID of the user tenant that needs to execute the validation task. If the value is empty, the current tenant executes the validation task. |
| 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 does not specify a path. |
| PATH_TYPE | varchar(64) | YES | The type of validation on the specified path (if the value is empty, the task does not specify a path):
|
| ID | longtext | YES | The By default, the value is empty, indicating that all backup sets and archive log pieces under the current backup path and archive path are to 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 job status:
|
| 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 information of the validation result. |
| DESCRIPTION | varchar(4096) | YES | The external information provided by OCP. |
| COMMENT | varchar(4096) | YES | The description of the reason for the validation task failure. |
Sample query
Query information about 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
Query information about backup validation tasks initiated by all tenants:
Query information about backup validation tasks initiated by all tenants: