Note
This view is available starting with V4.0.0.
Purpose
This view displays the history of backup cleanup tasks that have been executed under a specific tenant.
Columns
| Column | Type | Nullable | Description | |||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Column | Type | Nullable | Description | --- | --- | --- | --- | JOB_ID | NUMBER(38) | NO | Job ID, which is incrementally generated. | |||||||||||||||||
| Column | Type | Nullable | Description | --- | --- | --- | --- | INCARNATION | NUMBER(38) | NO | incarnation | incarnation ID | ||||||||||||||||
| INITIATOR_TENANT_ID | NUMBER(38) | NO | The ID of the tenant that initiated the job. | |||||||||||||||||||||||||
| INITIATOR_JOB_ID | NUMBER(38) | NO | The tenant of the JOB that initiated this job. | |||||||||||||||||||||||||
| JOB_ID | ||||||||||||||||||||||||||||
| COLUMN | TYPE | NULLABLE | DESCRIPTION | --- | --- | --- | --- | EXECUTOR_TENANT_ID | VARCHAR2(65536) | NO | The tenant IDs of tenants that execute cleanup tasks. | |||||||||||||||||
| TYPE | VARCHAR2(64) | NO | The cleanup type. Valid values:
|
|||||||||||||||||||||||||
| COLUMN | VARCHAR2(1024) | NO | Displays specific parameters of different cleanup types. | |||||||||||||||||||||||||
| JOB_LEVEL | VARCHAR2(64) | NO | Task initiation level:
|
|||||||||||||||||||||||||
| START_TIMESTAMP | VARCHAR2(256) | NO | The current tenant time when the task is started. | |||||||||||||||||||||||||
| END_TIMESTAMP | VARCHAR2(256) | NO | The tenant's current time when the task is completed. | |||||||||||||||||||||||||
| STATUS | VARCHAR2(64) | NO | The task status:
|
|||||||||||||||||||||||||
| TASK_COUNT | NUMBER(38) | YES | The number of backup_set/piece tasks. | |||||||||||||||||||||||||
| SUCCESS_TASK_COUNT | NUMBER(38) | YES | The number of tasks executed successfully for a backup piece or backup set. | |||||||||||||||||||||||||
| RESULT | NUMBER(38) | NO | Error code | |||||||||||||||||||||||||
| Column | Type | Nullable | Description | --- | --- | --- | --- | COMMENT | VARCHAR2(4096) | YES | Task execution description. |
Sample query
You can query the history of backup cleanup tasks executed by your tenant and view the first 5 records.
obclient [SYS]> SELECT * FROM SYS.DBA_OB_BACKUP_DELETE_JOB_HISTORY WHERE ROWNUM <= 5\G
The query result is as follows:
*************************** 1. row ***************************
JOB_ID: 20
INCARNATION: 1
INITIATOR_TENANT_ID: 1004
INITIATOR_JOB_ID: 20
EXECUTOR_TENANT_ID: 1004
TYPE: DELETE OBSOLETE BACKUP
PARAMETER: expired_time:2025-09-10 06:33:50.079557
JOB_LEVEL: USER_TENANT
START_TIMESTAMP: 2025-09-11 06:33:50.084931
END_TIMESTAMP: 2025-09-11 06:33:50.160191
STATUS: COMPLETED
TASK_COUNT: 0
SUCCESS_TASK_COUNT: 0
RESULT: 0
COMMENT:
*************************** 2. row ***************************
JOB_ID: 21
INCARNATION: 1
INITIATOR_TENANT_ID: 1004
INITIATOR_JOB_ID: 21
EXECUTOR_TENANT_ID: 1004
TYPE: DELETE OBSOLETE BACKUP
PARAMETER: expired_time:2025-09-10 07:33:50.384197
JOB_LEVEL: USER_TENANT
START_TIMESTAMP: 2025-09-11 07:33:50.387567
END_TIMESTAMP: 2025-09-11 07:33:50.435527
STATUS: COMPLETED
TASK_COUNT: 0
SUCCESS_TASK_COUNT: 0
RESULT: 0
COMMENT:
*************************** 3. row ***************************
JOB_ID: 22
INCARNATION: 1
INITIATOR_TENANT_ID: 1004
INITIATOR_JOB_ID: 22
EXECUTOR_TENANT_ID: 1004
TYPE: DELETE OBSOLETE BACKUP
PARAMETER: expired_time:2025-09-10 08:33:50.660556
JOB_LEVEL: USER_TENANT
START_TIMESTAMP: 2025-09-10 08:33:50.663947
END_TIMESTAMP: 2025-09-10 08:33:50.710906
STATUS: COMPLETED
TASK_COUNT: 0
SUCCESS_TASK_COUNT: 0
RESULT: 0
COMMENT:
*************************** 4. row ***************************
JOB_ID: 23
INCARNATION: 1
INITIATOR_TENANT_ID: 1004
INITIATOR_JOB_ID: 23
EXECUTOR_TENANT_ID: 1004
TYPE: DELETE OBSOLETE BACKUP
PARAMETER: expired_time:2025-09-10 09:33:50.931100
JOB_LEVEL: USER_TENANT
START_TIMESTAMP: 2025-09-11 09:33:50.934741
END_TIMESTAMP: 2025-09-11 09:33:50.984381
STATUS: COMPLETED
TASK_COUNT: 0
SUCCESS_TASK_COUNT: 0
RESULT: 0
COMMENT:
*************************** 5. row ***************************
JOB_ID: 24
INCARNATION: 1
INITIATOR_TENANT_ID: 1004
INITIATOR_JOB_ID: 24
EXECUTOR_TENANT_ID: 1004
TYPE: DELETE OBSOLETE BACKUP
PARAMETER: expired_time:2025-09-10 10:33:51.206735
JOB_LEVEL: USER_TENANT
START_TIMESTAMP: 2025-09-11 10:33:51.210244
END_TIMESTAMP: 2025-09-11 10:33:51.258817
STATUS: COMPLETED
TASK_COUNT: 0
SUCCESS_TASK_COUNT: 0
RESULT: 0
COMMENT:
5 rows in set
References
View the execution progress of a Job task for ongoing backup cleanup: DBA_OB_BACKUP_DELETE_JOBS
To query the execution progress of a backup cleanup task in progress: DBA_OB_BACKUP_DELETE_TASKS
View the historical information of the backup cleanup task: DBA_OB_BACKUP_DELETE_TASK_HISTORY
For details about how to enable automatic cleanup of expired backups, see Enable automatic cleanup of expired backups.