Note
This view is available starting with V4.0.0.
Purpose
This view displays the execution progress of backup cleanup jobs in the current tenant.
Columns
| Column | Type | Nullable | Description | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Column | Type | Nullable | Description | --- | --- | --- | --- | JOB_ID | NUMBER(38) | NO | Task ID, auto-incremental | ||
| Column | Type | Nullable | Description | --- | --- | --- | --- | INCARNATION | NUMBER(38) | NO | This column specifies 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 initiator in the tenant where the job was initiated. | ||||||||||
| JOB_ID | |||||||||||||
| Column | Type | Nullable | Description | --- | --- | --- | --- | EXECUTOR_TENANT_ID | VARCHAR2(65536) | NO | The tenant ID of the tenant that performs the cleanup task. | ||
| TYPE | VARCHAR2(64) | NO | Backup cleanup type:
|
||||||||||
| Column | Type | Nullable | Description | --- | --- | --- | --- | PARAMETER | VARCHAR2(1024) | NO | This column specifies the parameter used to clean up data. It describes the parameters of different data cleanup types. | ||
| JOB_LEVEL | VARCHAR2(64) | NO | Job level:
|
||||||||||
| START_TIMESTAMP | VARCHAR2(256) | NO | The time when the task starts. | ||||||||||
| END_TIMESTAMP | VARCHAR2(256) | NO | The current time of the task's tenant at the end time. | ||||||||||
| STATUS | VARCHAR2(64) | NO | The status of the task, which takes the following values:
|
||||||||||
| TASK_COUNT | NUMBER(38) | YES | Number of backup set/piece tasks | ||||||||||
| SUCCESS_TASK_COUNT | NUMBER(38) | YES | The number of tasks that successfully executed on the 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 cleanup jobs for your own 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
To check the progress of a task for cleaning up a backup: DBA_OB_BACKUP_DELETE_TASKS
View job task history information of backup cleanup: DBA_OB_BACKUP_DELETE_JOB_HISTORY
View the historical information about backup cleanup tasks: DBA_OB_BACKUP_DELETE_TASK_HISTORY
For more information about the procedure for automatically cleaning up expired backups, see Automatically clean up backed-up data.