--- title: "oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY - OceanBase 数据库 V4.2.5 | OceanBase 文档中心" description: oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY 说明 该视图从 V4.0.0 版本开始引入。 功能描述 展示本租户下已执行的备份清理任务历史信息。 字段说明 字段名称 类型 是否可以为 NULL 描述 TENANT_ID bigint(20) NO 租户 ID JOB_ID bi… --- 切换语言 - 中文站 - 简体中文 - International - English - 日本站 - 日本語 文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 4.2.5 LTS # oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY 更新时间：2026-07-15 20:42:47 [编辑](https://github.com/oceanbase/oceanbase-doc/edit/V4.2.5/zh-CN/700.reference/700.system-views/400.system-view-of-mysql-mode/200.dictionary-view-of-mysql-mode/6100.o-dba_ob_backup_delete_job_history-of-mysql-mode.md) #### 说明 该视图从 V4.0.0 版本开始引入。 ## 功能描述 展示本租户下已执行的备份清理任务历史信息。 ## 字段说明 | 字段名称 | 类型 | 是否可以为 NULL | 描述 | | --- | --- | --- | --- | | TENANT_ID | bigint(20) | NO | 租户 ID | | JOB_ID | bigint(20) | NO | 任务 ID，单调递增 | | INCARNATION | bigint(20) | NO | 分身 ID | | INITIATOR_TENANT_ID | bigint(20) | NO | 发起此次 JOB 的租户 ID | | INITIATOR_JOB_ID | bigint(20) | NO | 发起此次 JOB 的租户所属的 JOB_ID | | EXECUTOR_TENANT_ID | varchar(65536) | NO | 执行清理任务的租户列表 | | TYPE | varchar(64) | NO | 清理类型： - DELETE OBSOLETE BACKUP：过期清理 | | PARAMETER | timestamp(6) | NO | 清理参数，记录过期时间 | | JOB_LEVEL | varchar(64) | NO | 任务发起级别： - `USER_TENANT` ：用户租户发起的任务 - `SYS_TENANT` ：系统租户发起的任务 | | START_TIMESTAMP | timestamp(6) | NO | 任务开始时租户当前时间 | | END_TIMESTAMP | timestamp(6) | NO | 任务结束时租户当前时间 | | STATUS | varchar(64) | NO | 任务状态： - `INIT` ：任务初始化阶段 - `DOING` ：任务执行阶段 - `CANCELING` ：任务被取消阶段 - `COMPLETED`：任务执行成功 - `FAILED` ：任务执行失败 - `CANCELED` ：任务成功被取消 | | TASK_COUNT | bigint(20) | YES | backup_set/piece 任务数 | | SUCCESS_TASK_COUNT | bigint(20) | YES | backup_set/piece 执行成功的任务数 | | RESULT | bigint(20) | NO | 错误码 | | COMMENT | varchar(4096) | YES | 任务执行说明 | ## 查询示例 用户租户查询本租户已执行的备份清理任务历史信息，展示前 5 条记录。 ```shell obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY LIMIT 5\G ``` 查询结果如下： ```shell *************************** 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 ``` ## 相关视图或文档 - 查看正在执行的备份清理的 Job 任务的执行进度：[DBA_OB_BACKUP_DELETE_JOBS](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000001501656) - 查看正在执行的备份清理的 Task 任务的执行进度：[DBA_OB_BACKUP_DELETE_TASKS](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000001501742) - 查看备份清理的 Task 任务的历史信息：[DBA_OB_BACKUP_DELETE_TASK_HISTORY](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000001501750) - 设置自动清理过期备份的详细操作，参见 [自动清理过期备份](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000001499878)。 上一篇 下一篇 ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线