Note
- For V4.4.2, this view is available starting with V4.4.2 BP2.
- For V4.6.x versions, this view is available starting from V4.6.0.
Overview
The 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 | NUMBER(38) | NO | Task ID |
| INCARNATION | NUMBER(38) | NO | Incarnation ID |
| INITIATOR_TENANT_ID | NUMBER(38) | NO | Tenant ID that initiated the job |
| INITIATOR_JOB_ID | NUMBER(38) | 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 | VARCHAR2(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 | VARCHAR2(64) | NO | Validation task type:
|
| PATH | CLOB | 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 | VARCHAR2(64) | YES | Type of validation under the specified path. If the value is empty, the task is a non-path-specific validation. Valid values:
|
| ID | CLOB | 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 | VARCHAR2(64) | NO | Validation level:
|
| START_TIMESTAMP | VARCHAR2(256) | NO | Start time of the validation task |
| END_TIMESTAMP | VARCHAR2(256) | NO | End time of the validation task |
| STATUS | VARCHAR2(64) | NO | Job status:
|
| RETRY_COUNT | NUMBER(38) | YES | Retry Count |
| TASK_COUNT | NUMBER(38) | YES | Total validation tasks for backup sets or log archive pieces |
| SUCCESS_TASK_COUNT | NUMBER(38) | YES | Number of Tasks with successful piece validation for backup sets or log archive pieces |
| RESULT | NUMBER(38) | NO | Error code information of the validation result |
| DESCRIPTION | VARCHAR2(4096) | YES | External information provided by OCP |
| COMMENT | VARCHAR2(4096) | YES | Reason description for the validation task failure |
Sample query
You can view the execution history of job-level backup validation tasks 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 job-level backup validation tasks for the current tenant: DBA_OB_BACKUP_VALIDATE_JOBS
View task-level backup validation tasks for the current tenant:
View all tenant job-level backup validation tasks:
View all tenant task-level backup validation tasks: