Note
This view is available starting with V4.6.0.
Purpose
The DBA_OB_BACKUP_VALIDATE_JOB_HISTORY view displays the execution history of backup validation jobs initiated by the current tenant. Each job corresponds to a backup validation instruction.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| JOB_ID | NUMBER(38) | NO | The job ID. |
| INCARNATION | NUMBER(38) | NO | The incarnation ID. |
| INITIATOR_TENANT_ID | NUMBER(38) | NO | The ID of the tenant that initiated the job. |
| INITIATOR_JOB_ID | NUMBER(38) | 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 | VARCHAR2(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 | VARCHAR2(64) | NO | The type of the validation task:
|
| PATH | CLOB | YES | The user-specified backup path or log archive path to be validated. If the value is empty, the task is a non-specified path validation. |
| PATH_TYPE | VARCHAR2(64) | YES | The type of validation on the specified path (if the value is empty, the task is a non-specified path validation):
|
| ID | CLOB | YES | The If the value is empty, it indicates 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 | VARCHAR2(64) | NO | The validation level:
|
| START_TIMESTAMP | VARCHAR2(256) | NO | The start time of the validation task. |
| END_TIMESTAMP | VARCHAR2(256) | NO | The end time of the validation task. |
| STATUS | VARCHAR2(64) | NO | The job status:
|
| RETRY_COUNT | NUMBER(38) | YES | The number of retries. |
| TASK_COUNT | NUMBER(38) | YES | The total number of validation tasks for the backup set or log archive piece. |
| SUCCESS_TASK_COUNT | NUMBER(38) | YES | The number of successful validation tasks for the backup set or log archive piece. |
| RESULT | NUMBER(38) | NO | The error code of the validation result. |
| DESCRIPTION | VARCHAR2(4096) | YES | The external information provided by OCP. |
| COMMENT | VARCHAR2(4096) | YES | The description of the reason for the validation task failure. |
Sample query
Query the execution history of backup validation jobs initiated by the current tenant.
obclient(sys@oracle001)[SYS]> SELECT * FROM SYS.DBA_OB_BACKUP_VALIDATE_JOB_HISTORY\G
The query result is as follows:
*************************** 1. row ***************************
JOB_ID: 2
INCARNATION: 1
INITIATOR_TENANT_ID: 1004
INITIATOR_JOB_ID: 0
EXECUTOR_TENANT_ID: NULL
TYPE: DATABASE
PATH: NULL
PATH_TYPE: NULL
ID: NULL
VALIDATE_LEVEL: basic
START_TIMESTAMP: 2026-03-04 14:08:20
END_TIMESTAMP: 2026-03-04 14:08:21
STATUS: COMPLETED
TASK_COUNT: 1
SUCCESS_TASK_COUNT: 1
RESULT: 0
COMMENT: all archive pieces are not support for backup validate or not find any piece
1 row in set (0.010 sec)
References
View information about backup validation jobs initiated by the current tenant: DBA_OB_BACKUP_VALIDATE_JOBS
View information about backup validation tasks initiated by the current tenant:
View information about backup validation jobs initiated by all tenants:
CDB_OB_BACKUP_VALIDATE_JOBS
CDB_OB_BACKUP_VALIDATE_JOB_HISTORY
View information about backup validation tasks initiated by all tenants:
CDB_OB_BACKUP_VALIDATE_TASKS
CDB_OB_BACKUP_VALIDATE_TASK_HISTORY