Note
- For V4.4.2, this view is available starting from V4.4.2 BP2.
- For V4.6.x versions, this view is available starting from V4.6.0.
Overview
The oceanbase.DBA_OB_BACKUP_VALIDATE_JOB_HISTORY view displays the execution history of 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 to perform under the 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 |
| COMMENT | varchar(4096) | YES | Reason description for the validation task failure |
| DESCRIPTION | varchar(4096) | YES | External information provided by OCP |
Sample query
The system tenant can view the execution history of job-level backup validation tasks initiated by itself.
obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.DBA_OB_BACKUP_VALIDATE_JOB_HISTORY\G
The query result is as follows:
*************************** 1. row ***************************
JOB_ID: 1
INCARNATION: 1
INITIATOR_TENANT_ID: 1
INITIATOR_JOB_ID: 0
EXECUTOR_TENANT_ID: 1002
TYPE: DATABASE
PATH:
PATH_TYPE:
ID:
VALIDATE_LEVEL: basic
START_TIMESTAMP: 2026-03-03 14:15:56.377358
END_TIMESTAMP: 2026-03-03 14:18:59.881419
STATUS: COMPLETED
RETRY_COUNT: 0
TASK_COUNT: 0
SUCCESS_TASK_COUNT: 0
RESULT: 0
COMMENT:
DESCRIPTION:
*************************** 2. row ***************************
JOB_ID: 2
INCARNATION: 1
INITIATOR_TENANT_ID: 1
INITIATOR_JOB_ID: 0
EXECUTOR_TENANT_ID: 1002
TYPE: DATABASE
PATH:
PATH_TYPE:
ID:
VALIDATE_LEVEL: physical
START_TIMESTAMP: 2026-03-03 14:25:03.758517
END_TIMESTAMP: 2026-03-03 14:25:12.702483
STATUS: COMPLETED
RETRY_COUNT: 0
TASK_COUNT: 0
SUCCESS_TASK_COUNT: 0
RESULT: 0
COMMENT:
DESCRIPTION:
*************************** 3. row ***************************
JOB_ID: 3
INCARNATION: 1
INITIATOR_TENANT_ID: 1
INITIATOR_JOB_ID: 0
EXECUTOR_TENANT_ID: 1002
TYPE: DATABASE
PATH:
PATH_TYPE:
ID:
VALIDATE_LEVEL: basic
START_TIMESTAMP: 2026-03-03 14:25:46.576284
END_TIMESTAMP: 2026-03-03 14:29:49.871001
STATUS: COMPLETED
RETRY_COUNT: 0
TASK_COUNT: 0
SUCCESS_TASK_COUNT: 0
RESULT: 0
COMMENT:
DESCRIPTION:
*************************** 4. row ***************************
JOB_ID: 4
INCARNATION: 1
INITIATOR_TENANT_ID: 1
INITIATOR_JOB_ID: 0
EXECUTOR_TENANT_ID: 1002
TYPE: BACKUPSET
PATH:
PATH_TYPE:
ID:
VALIDATE_LEVEL: basic
START_TIMESTAMP: 2026-03-03 14:38:34.403754
END_TIMESTAMP: 2026-03-03 14:40:37.863050
STATUS: COMPLETED
RETRY_COUNT: 0
TASK_COUNT: 0
SUCCESS_TASK_COUNT: 0
RESULT: 0
COMMENT:
DESCRIPTION:
*************************** 5. 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: 2026-03-03 14:51:03.679399
STATUS: COMPLETED
RETRY_COUNT: 0
TASK_COUNT: 0
SUCCESS_TASK_COUNT: 0
RESULT: 0
COMMENT:
DESCRIPTION:
5 rows in set
References
View all tenant job-level backup validation tasks:
View all tenant task-level backup validation tasks: