Purpose
The DBA_OB_BACKUP_DELETE_JOB_HISTORY view displays the history of JOB-level backup cleanup jobs that have been executed in the tenant.
Note
This view is introduced since OceanBase Database V4.0.0.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| JOB_ID | NUMBER(38) | NO | The job ID, which monotonically increases. |
| INCARNATION | NUMBER(38) | NO | The ID of the incarnation. |
| 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 initiated by the tenant. |
| EXECUTOR_TENANT_ID | VARCHAR2(65536) | NO | IDs of tenants that execute the cleanup job. |
| TYPE | VARCHAR2(64) | NO | The cleanup type, including cleanup upon expiration, cleanup for a specified backup set, round, or piece, and cleanup canceling. |
| PARAMETER | VARCHAR2(1024) | NO | The parameters are described as follows: |
| JOB_LEVEL | VARCHAR2(64) | NO | The job initiation level. Valid values: USER_TENANT, CLUSTER, and SYS_TENANT. |
| START_TIMESTAMP | VARCHAR2(256) | NO | The time on the tenant when the job was started. |
| END_TIMESTAMP | VARCHAR2(256) | NO | The time on the tenant when the task ended. |
| STATUS | VARCHAR2(64) | NO | The task status. Valid values: |
| TASK_COUNT | NUMBER(38) | YES | The number of backup set/piece cleanup tasks. |
| SUCCESS_TASK_COUNT | NUMBER(38) | YES | The number of backup set/piece cleanup tasks that are successfully executed. |
| RESULT | NUMBER(38) | NO | The error code. |
| COMMENT | VARCHAR2(4096) | YES | The execution description of the task. |
