Note
This view is available starting with V4.0.0.
Overview
Displays the execution progress of the backup cleanup job for the current tenant.
Columns
Field Name |
Type |
Nullable |
Description |
|---|---|---|---|
| JOB_ID | NUMBER(38) | NO | Task ID, which is monotonically increasing. |
| INCARNATION | NUMBER(38) | NO | Avatar ID |
| INITIATOR_TENANT_ID | NUMBER(38) | NO | Tenant ID that initiated the job |
| INITIATOR_JOB_ID | NUMBER(38) | NO | The tenant ID of the job initiator. |
| JOB_ID | |||
| EXECUTOR_TENANT_ID | VARCHAR2(65536) | NO | List of Tenants for Which the Cleanup Task Is to Be Performed |
| TYPE | VARCHAR2(64) | NO | Cleanup type:
For V4.4.x versions, DELETE BACKED UP ARCHIVELOG PIECEIntroduced in V4.4.2 BP3. |
| PARAMETER | VARCHAR2(1024) | NO | Cleanup parameters, describing the specific parameter information for different cleanup types |
| JOB_LEVEL | VARCHAR2(64) | NO | Task Initiation Level:
|
| START_TIMESTAMP | VARCHAR2(256) | NO | Current Tenant Time at Task Start |
| END_TIMESTAMP | VARCHAR2(256) | NO | Current Tenant Time at Task End |
| STATUS | VARCHAR2(64) | NO | Task status:
|
| TASK_COUNT | NUMBER(38) | YES | Number of backup_set/piece Tasks |
| SUCCESS_TASK_COUNT | NUMBER(38) | YES | Number of Successful Tasks for backup_set/piece |
| RESULT | NUMBER(38) | NO | Error Code |
| COMMENT | VARCHAR2(4096) | YES | Task Execution Instructions |
Sample query
You can query the execution progress of backup cleanup jobs for the current tenant.
obclient [SYS]> SELECT * FROM SYS.DBA_OB_BACKUP_DELETE_JOBS\G
The query result is as follows:
*************************** 1. row ***************************
JOB_ID: 7
INCARNATION: 1
INITIATOR_TENANT_ID: 1002
INITIATOR_JOB_ID: 7
EXECUTOR_TENANT_ID: 1002
TYPE: DELETE OBSOLETE BACKUP
PARAMETER: expired_time:2025-09-12 12:09:40.060284
JOB_LEVEL: USER_TENANT
START_TIMESTAMP: 2025-09-13 12:09:53.389512
END_TIMESTAMP:
STATUS: DOING
TASK_COUNT: 2
SUCCESS_TASK_COUNT: 1
RESULT: 0
COMMENT:
1 row in set
References
View the progress of backup cleanup tasks in progress: DBA_OB_BACKUP_DELETE_TASKS
View the job history of backup cleanup: DBA_OB_BACKUP_DELETE_JOB_HISTORY
View the history of backup cleanup tasks: DBA_OB_BACKUP_DELETE_TASK_HISTORY
For detailed operations on setting automatic cleanup of expired backups, see Automatically clean up expired backups.