Note
This view is available starting with V4.6.0.
Purpose
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 instruction.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| JOB_ID | NUMBER(38) | NO | The task 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, it indicates that the current job initiated the task. |
| 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, it indicates that the current tenant is executing the validation task. |
| TYPE | VARCHAR2(64) | NO | The type of the validation task:
|
| PATH | CLOB | YES | The backup or log archive path specified by the user for validation. If the value is empty, it indicates that the task is not for a specified path. |
| PATH_TYPE | VARCHAR2(64) | YES | The type of the specified path for validation (if the value is empty, it indicates that the task is not for a specified path):
|
| ID | CLOB | YES | The By default, it is empty, indicating that all backup sets and log archive pieces under the current backup and archive paths 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 status of the job:
|
| 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 information 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 failure of the validation task. |
Sample query
Query the information about job-level backup validation tasks initiated by the current user 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 initiated by the current tenant: DBA_OB_BACKUP_VALIDATE_JOB_HISTORY
View task-level backup validation tasks initiated by the current tenant:
View job-level backup validation tasks initiated by all tenants:
CDB_OB_BACKUP_VALIDATE_JOBS
CDB_OB_BACKUP_VALIDATE_JOB_HISTORY
View task-level backup validation tasks initiated by all tenants:
CDB_OB_BACKUP_VALIDATE_TASKS
CDB_OB_BACKUP_VALIDATE_TASK_HISTORY