Note
This view is available starting with V4.6.0.
Purpose
The oceanbase.CDB_OB_BACKUP_VALIDATE_JOBS view displays information about backup validation tasks initiated by all tenants. Each job corresponds to a backup validation instruction. If an instruction involves multiple user tenants, the view may display multiple sub-jobs at the user tenant level.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant that initiated the validation task. |
| 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 current job. If the value is 0, it indicates that the current job is the initiator. |
| EXECUTOR_TENANT_ID | varchar(65536) | NO | The tenant ID of the user tenant that needs to execute the validation task for the current job. If the value is 0, it indicates that the current tenant is executing the validation task. |
| TYPE | varchar(64) | NO | The type of the validation task. Valid values:
|
| PATH | longtext | YES | The backup path or archive log path specified by the user for validation. If the value is empty, it indicates that the task is not for a specified path. |
| PATH_TYPE | varchar(64) | YES | The type of the specified path for validation. If the value is empty, it indicates that the task is not for a specified path. Valid values:
|
| ID | longtext | YES | The If the value is empty, it indicates that all backup sets and archive log pieces under the current backup path and archive path are to be validated. If the user specifies the |
| VALIDATE_LEVEL | varchar(64) | NO | The validation level. Valid values:
|
| 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. Valid values:
|
| 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 | The 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 all backup validation tasks initiated by all tenants.
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-level backup validation tasks: CDB_OB_BACKUP_VALIDATE_JOB_HISTORY
View all task-level backup validation tasks: