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 backup validation tasks initiated by the current tenant at the job level. 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 current job initiated the job. |
| EXECUTOR_TENANT_ID | varchar(65536) | NO | The 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 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 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 If the value is empty, all backup sets and archive log pieces under the current backup path and archive path are 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 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 execution history of backup validation tasks initiated by the current user tenant at the job level.
obclient(root@mysql001)[oceanbase]> SELECT * FROM oceanbase.DBA_OB_BACKUP_VALIDATE_JOB_HISTORY\G
The query result is as follows:
*************************** 1. row ***************************
JOB_ID: 2
INCARNATION: 1
INITIATOR_TENANT_ID: 1002
INITIATOR_JOB_ID: 0
EXECUTOR_TENANT_ID:
TYPE: DATABASE
PATH:
PATH_TYPE:
ID:
VALIDATE_LEVEL: basic
START_TIMESTAMP: 2026-03-03 13:58:07.778690
END_TIMESTAMP: 2026-03-03 13:58:09.864257
STATUS: COMPLETED
RETRY_COUNT: 0
TASK_COUNT: 1
SUCCESS_TASK_COUNT: 1
RESULT: 0
COMMENT: all archive pieces are not support for backup validate or not find any piece
DESCRIPTION:
*************************** 2. row ***************************
JOB_ID: 4
INCARNATION: 1
INITIATOR_TENANT_ID: 1
INITIATOR_JOB_ID: 1
EXECUTOR_TENANT_ID:
TYPE: DATABASE
PATH:
PATH_TYPE:
ID:
VALIDATE_LEVEL: basic
START_TIMESTAMP: 2026-03-03 14:15:56.389026
END_TIMESTAMP: 2026-03-03 14:18:59.846956
STATUS: COMPLETED
RETRY_COUNT: 0
TASK_COUNT: 3
SUCCESS_TASK_COUNT: 3
RESULT: 0
COMMENT: all archive pieces are not support for backup validate or not find any piece
DESCRIPTION:
*************************** 3. row ***************************
JOB_ID: 5
INCARNATION: 1
INITIATOR_TENANT_ID: 1
INITIATOR_JOB_ID: 2
EXECUTOR_TENANT_ID:
TYPE: DATABASE
PATH:
PATH_TYPE:
ID:
VALIDATE_LEVEL: physical
START_TIMESTAMP: 2026-03-03 14:25:03.764490
END_TIMESTAMP: 2026-03-03 14:25:12.691621
STATUS: COMPLETED
RETRY_COUNT: 0
TASK_COUNT: 4
SUCCESS_TASK_COUNT: 4
RESULT: 0
COMMENT:
DESCRIPTION:
3 rows in set
References
View the information of backup validation tasks initiated by the current tenant at the job level: DBA_OB_BACKUP_VALIDATE_JOBS
View the information of backup validation tasks initiated by the current tenant at the task level:
View the information of backup validation tasks initiated by all tenants at the job level:
CDB_OB_BACKUP_VALIDATE_JOBS
CDB_OB_BACKUP_VALIDATE_JOB_HISTORY
View the information of backup validation tasks initiated by all tenants at the task level:
CDB_OB_BACKUP_VALIDATE_TASKS
CDB_OB_BACKUP_VALIDATE_TASK_HISTORY