Note
This view is available starting with V4.6.0.
Purpose
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 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 ID of the job that initiated the job. If the value is 0, the job was initiated by the current 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. Valid values:
|
| PATH | longtext | YES | The backup path or log archive 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 the path specified by the user for validation (if the value is empty, the task does not specify a path). Valid values:
|
| ID | longtext | YES | The By default, this column is empty, indicating that all backup sets and log archive 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. 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 job status. 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 log archive piece. |
| SUCCESS_TASK_COUNT | bigint(20) | YES | The number of successful validation tasks for the backup set or log archive piece. |
| RESULT | bigint(20) | NO | The error code of the validation result. |
| COMMENT | varchar(4096) | YES | The reason for the failure of the validation task. |
| DESCRIPTION | varchar(4096) | YES | The external information provided by OCP. |
Sample query
Query the execution history of job-level backup validation tasks initiated by the current tenant.
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
Query the execution history of job-level backup validation tasks initiated by all tenants:
Query the execution history of task-level backup validation tasks initiated by all tenants: