Purpose
The oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY view displays the history of backup set and backup piece cleanup tasks that have been completed in the tenant.
Note
This view is introduced since OceanBase Database V4.0.0.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| TASK_ID | bigint(20) | NO | The ID of a task group, which identifies a group of tasks. |
| INCARNATION | bigint(20) | NO | The ID of the incarnation. |
| JOB_ID | bigint(20) | NO | The job ID of the task, which corresponds to a job table. |
| TASK_TYPE | varchar(64) | NO | The type of the task. Valid values: backup_set and piece. |
| ID | bigint(20) | NO | The ID of the task. |
| ROUND_ID | bigint(20) | NO | The destination round ID of the piece. For backup set cleanup, the round ID is 0. |
| DEST_ID | bigint(20) | NO | The ID of the backup destination. |
| START_TIMESTAMP | timestamp(6) | NO | The start time of the task. |
| END_TIMESTAMP | timestamp(6) | NO | The end time of the task. |
| STATUS | varchar(64) | NO | The status of the task. Valid values: |
| TOTAL_LS_COUNT | bigint(20) | YES | The number of log streams under the task. |
| FINISH_LS_COUNT | bigint(20) | YES | The number of successful log streams under the task. |
| TOTAL_BYTES | bigint(20) | YES | The total amount of data to be cleaned up. |
| DELETE_BYTES | bigint(20) | YES | The amount of data cleaned up. |
| TOTAL_FILES_COUNT | bigint(20) | YES | The total number of files to be cleaned up. |
| DELETE_FILES_COUNT | bigint(20) | YES | The number of files successfully cleaned up. |
| RESULT | bigint(20) | YES | The error code. |
| COMMENT | varchar(4096) | YES | The comments. |
| PATH | varchar(1024) | NO | The backup destination to which the backup set/backup piece belongs. |