Note
This view is available starting with V4.0.0.
Purpose
This view shows the execution progress of backup retention tasks of the current tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| JOB_ID | NUMBER(38) | NO | The job ID. The ID is strictly increasing. |
| INCARNATION | NUMBER(38) | NO | The incarnation ID. |
| INITIATOR_TENANT_ID | NUMBER(38) | NO | The tenant ID that initiated this job. |
| INITIATOR_JOB_ID | NUMBER(38) | NO | The JOB_ID of the tenant that initiated this job. |
| EXECUTOR_TENANT_ID | VARCHAR2(65536) | NO | The list of tenants that execute the cleanup task. |
| TYPE | VARCHAR2(64) | NO | Cleanup type:
|
| PARAMETER | VARCHAR2(1024) | NO | Cleanup parameters. Records the expiration time. |
| JOB_LEVEL | VARCHAR2(64) | NO | Job initiator level. Valid values:
|
| START_TIMESTAMP | VARCHAR2(256) | NO | The current time in the tenant when the task starts. |
| END_TIMESTAMP | VARCHAR2(256) | NO | The current time in the tenant when the task ends. |
| STATUS | VARCHAR2(64) | NO | Task status. Valid values:
|
| TASK_COUNT | NUMBER(38) | YES | Number of backup_set/piece tasks. |
| SUCCESS_TASK_COUNT | NUMBER(38) | YES | Number of backup_set/piece tasks executed successfully. |
| RESULT | NUMBER(38) | NO | Error code. |
| COMMENT | VARCHAR2(4096) | YES | Description of the task execution. |
Sample query
You can query the progress of backup cleanup jobs for your user 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: 2022-05-31 12:09:40.060284
JOB_LEVEL: USER_TENANT
START_TIMESTAMP: 2022-06-01 12:09:53.389512
END_TIMESTAMP:
STATUS: DOING
TASK_COUNT: 2
SUCCESS_TASK_COUNT: 1
RESULT: 0
COMMENT:
1 row in set
References
To view the task status of the backup cleanup DBA_OB_BACKUP_DELETE_TASKS.
View the history information of the backup deletion job: DBA_OB_BACKUP_DELETE_JOB_HISTORY.
View the task history of the backup cleanup task: DBA_OB_BACKUP_DELETE_TASK_HISTORY
For more information about how to enable auto cleanup of expired backups, see Enable auto cleanup of expired backups.