Purpose
The oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY view displays the history of backup cleanup jobs that have been executed in the tenant.
Note
This view was introduced in OceanBase Database V4.0.0.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| JOB_ID | bigint(20) | NO | The job ID, which monotonically increases. |
| INCARNATION | bigint(20) | NO | The ID of the incarnation. |
| INITIATOR_TENANT_ID | bigint(20) | NO | The ID of the tenant that initiated the job. |
| INITIATOR_JOB_ID | bigint(20) | NO | The job ID of the tenant that initiated the job. |
| EXECUTOR_TENANT_ID | varchar(65536) | NO | IDs of tenants that execute the cleanup job. |
| TYPE | varchar(64) | NO | The cleanup type. Valid value:
|
| PARAMETER | timestamp(6) | NO | The parameters, which are described as follows: policy_name = xxx; expired_time = xxx; redundancy:2; backup_copies:1backup_set_id = 1; dest_id = 1; dest = xxxxxdest_round_id = 1; backup_piece_id = 1; dest_id = 1; dest = xxxxdest_round_id = 1; dest_id = 1; dest = xxxxdest_id = 1; dest = xxx |
| JOB_LEVEL | varchar(64) | NO | The job initiation level. Valid values: USER_TENANT and SYS_TENANT. |
| START_TIMESTAMP | timestamp(6) | NO | The time on the tenant when the job started. |
| END_TIMESTAMP | timestamp(6) | NO | The time on the tenant when the job ended. |
| STATUS | varchar(64) | NO | The status of the job. Valid values: INITDOINGCANCELINGCANCELEDCOMPLETEDFAILED |
| TASK_COUNT | bigint(20) | YES | The number of backup set/piece cleanup tasks. |
| SUCCESS_TASK_COUNT | bigint(20) | YES | The number of backup set/piece cleanup tasks that are successfully executed. |
| RESULT | bigint(20) | NO | The error code. |
| COMMENT | varchar(4096) | YES | The execution description of the job. |