Note
This view is available starting with V4.0.0.
Purpose
This view displays the history of backup cleanup tasks executed in the current 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 number. |
| INCARNATION | bigint(20) | NO | The incarnation ID. |
| INITIATOR_TENANT_ID | bigint(20) | NO | The tenant ID of the initiator of the task. |
| INITIATOR_JOB_ID | bigint(20) | NO | The job ID of the initiator of the task. |
| EXECUTOR_TENANT_ID | varchar(65536) | NO | The list of tenants that executed the cleanup task. |
| TYPE | varchar(64) | NO | The cleanup type. Valid values:
|
| PARAMETER | timestamp(6) | NO | The content of the parameter. The content is as follows: |
| JOB_LEVEL | varchar(64) | NO | The task initiation level. Valid values: USER_TENANT, CLUSTER, and SYS_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: |
| 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 5 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