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_JOBS view displays information about 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 user-specified path. If the value is empty, the task is a non-path-specific validation:
|
| 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 information about the job-level backup validation tasks initiated by the current tenant.
obclient(sys@oracle001)[SYS]> SELECT * FROM SYS.DBA_OB_BACKUP_VALIDATE_JOBS\G
The query result is as follows:
*************************** 1. row ***************************
JOB_ID: 4
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:21:40
END_TIMESTAMP: NULL
STATUS: DOING
TASK_COUNT: 3
SUCCESS_TASK_COUNT: 0
RESULT: 0
COMMENT: all archive pieces are not support for backup validate or not find any piece
1 row in set
References
View the execution history of job-level backup validation tasks for the current tenant: DBA_OB_BACKUP_VALIDATE_JOB_HISTORY
View the task-level backup validation tasks of the current tenant:
View all tenant job-level backup validation tasks:
View all tenant task-level backup validation tasks: