Note
This view is available starting with V4.0.0.
Purpose
This view displays the history of backup cleanup tasks executed in the tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The tenant ID. |
| JOB_ID | bigint(20) | NO | The task ID, which is a monotonic increasing value. |
| INCARNATION | bigint(20) | NO | The incarnation ID. |
| INITIATOR_TENANT_ID | bigint(20) | NO | The ID of the tenant that initiated the task. |
| INITIATOR_JOB_ID | bigint(20) | NO | The ID of the task initiated by the tenant. |
| EXECUTOR_TENANT_ID | varchar(65536) | NO | The list of tenants that executed the cleanup task. |
| TYPE | varchar(64) | NO | The cleanup type. Valid value: DELETE OBSOLETE BACKUP, which indicates the obsolete backup cleanup. |
| PARAMETER | timestamp(6) | NO | The cleanup parameter, which records the obsolete time. |
| JOB_LEVEL | varchar(64) | NO | The task initiation level. Valid values: USER_TENANT and SYS_TENANT. USER_TENANT indicates that the task was initiated by a user tenant. SYS_TENANT indicates that the task was initiated by a system tenant. |
| START_TIMESTAMP | timestamp(6) | NO | The current time of the tenant when the task started. |
| END_TIMESTAMP | timestamp(6) | NO | The current time of the tenant when the task ended. |
| STATUS | varchar(64) | NO | The task status. Valid values: INIT, DOING, CANCELING, COMPLETED, FAILED, and CANCELED. INIT indicates the task initialization stage. DOING indicates the task execution stage. CANCELING indicates the task cancellation stage. COMPLETED indicates that the task was executed successfully. FAILED indicates that the task execution failed. CANCELED indicates that the task was successfully canceled. |
| TASK_COUNT | bigint(20) | YES | The number of backup_set/piece tasks. |
| SUCCESS_TASK_COUNT | bigint(20) | YES | The number of backup_set/piece tasks that were executed successfully. |
| RESULT | bigint(20) | NO | The error code. |
| COMMENT | varchar(4096) | YES | The task execution description. |
Sample query
Query the history of backup cleanup tasks executed in the current user tenant and display the first five records.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY LIMIT 5\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: 2025-01-06 17:33:46.374127
JOB_LEVEL: USER_TENANT
START_TIMESTAMP: 2025-01-07 17:33:46.377760
END_TIMESTAMP: 2025-01-07 17:33:46.426616
STATUS: COMPLETED
TASK_COUNT: 0
SUCCESS_TASK_COUNT: 0
RESULT: 0
COMMENT:
*************************** 2. row ***************************
JOB_ID: 8
INCARNATION: 1
INITIATOR_TENANT_ID: 1002
INITIATOR_JOB_ID: 8
EXECUTOR_TENANT_ID: 1002
TYPE: DELETE OBSOLETE BACKUP
PARAMETER: 2025-01-06 18:33:46.641517
JOB_LEVEL: USER_TENANT
START_TIMESTAMP: 2025-01-07 18:33:46.645269
END_TIMESTAMP: 2025-01-07 18:33:46.692936
STATUS: COMPLETED
TASK_COUNT: 0
SUCCESS_TASK_COUNT: 0
RESULT: 0
COMMENT:
*************************** 3. row ***************************
JOB_ID: 9
INCARNATION: 1
INITIATOR_TENANT_ID: 1002
INITIATOR_JOB_ID: 9
EXECUTOR_TENANT_ID: 1002
TYPE: DELETE OBSOLETE BACKUP
PARAMETER: 2025-01-06 19:33:46.913048
JOB_LEVEL: USER_TENANT
START_TIMESTAMP: 2025-01-07 19:33:46.916564
END_TIMESTAMP: 2025-01-07 19:33:46.964739
STATUS: COMPLETED
TASK_COUNT: 0
SUCCESS_TASK_COUNT: 0
RESULT: 0
COMMENT:
*************************** 4. row ***************************
JOB_ID: 10
INCARNATION: 1
INITIATOR_TENANT_ID: 1002
INITIATOR_JOB_ID: 10
EXECUTOR_TENANT_ID: 1002
TYPE: DELETE OBSOLETE BACKUP
PARAMETER: 2025-01-06 20:33:47.194699
JOB_LEVEL: USER_TENANT
START_TIMESTAMP: 2025-01-07 20:33:47.199112
END_TIMESTAMP: 2025-01-07 20:33:47.252810
STATUS: COMPLETED
TASK_COUNT: 0
SUCCESS_TASK_COUNT: 0
RESULT: 0
COMMENT:
*************************** 5. row ***************************
JOB_ID: 11
INCARNATION: 1
INITIATOR_TENANT_ID: 1002
INITIATOR_JOB_ID: 11
EXECUTOR_TENANT_ID: 1002
TYPE: DELETE OBSOLETE BACKUP
PARAMETER: 2025-01-06 21:33:47.474197
JOB_LEVEL: USER_TENANT
START_TIMESTAMP: 2025-01-07 21:33:47.477776
END_TIMESTAMP: 2025-01-07 21:33:47.527881
STATUS: COMPLETED
TASK_COUNT: 0
SUCCESS_TASK_COUNT: 0
RESULT: 0
COMMENT:
5 rows in set
References
View the progress of a backup cleanup job that is being executed: DBA_OB_BACKUP_DELETE_JOBS
View the progress of a backup cleanup task that is being executed: DBA_OB_BACKUP_DELETE_TASKS
View the history of a backup cleanup task: DBA_OB_BACKUP_DELETE_TASK_HISTORY
For more information about how to set up automatic cleanup of obsolete backups, see Automatically clear obsolete backups.