--- title: github-fill description: DBA_OB_BACKUP_DELETE_JOB_HISTORY 说明 该视图从 V4.0.0 版本开始引入。 功能描述 展示租户下已执行的备份清理任务历史信息。 字段说明 字段名称 类型 是否可以为 NULL 描述 JOB_ID NUMBER(38) NO 任务 ID，单调递增 INCARNATION NUMBER… --- 切换语言 - 中文站 - 简体中文 - International - English - 日本站 - 日本語 文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 4.2.5 LTS # DBA_OB_BACKUP_DELETE_JOB_HISTORY 更新时间：2026-07-15 20:56:59 [编辑](https://github.com/oceanbase/oceanbase-doc/edit/V4.2.5/zh-CN/700.reference/700.system-views/500.system-view-of-oracle-mode/200.dictionary-view-of-oracle-mode/9700.dba_ob_backup_delete_job_history-of-oracle-mode.md) #### 说明 该视图从 V4.0.0 版本开始引入。 ## 功能描述 展示租户下已执行的备份清理任务历史信息。 ## 字段说明 | 字段名称 | 类型 | 是否可以为 NULL | 描述 | | --- | --- | --- | --- | | JOB_ID | NUMBER(38) | NO | 任务 ID，单调递增 | | INCARNATION | NUMBER(38) | NO | 分身 ID | | INITIATOR_TENANT_ID | NUMBER(38) | NO | 发起此次 JOB 的租户 ID | | INITIATOR_JOB_ID | NUMBER(38) | NO | 发起此次 JOB 的租户所属的 | | JOB_ID | | EXECUTOR_TENANT_ID | VARCHAR2(65536) | NO | 执行清理任务的租户列表 | | TYPE | VARCHAR2(64) | NO | 清理类型： - DELETE OBSOLETE BACKUP：过期清理 | | PARAMETER | VARCHAR2(1024) | NO | 清理参数，记录过期时间 | | JOB_LEVEL | VARCHAR2(64) | NO | 任务发起级别： - `USER_TENANT` ：用户租户发起的任务 - `SYS_TENANT` ：系统租户发起的任务 | | START_TIMESTAMP | VARCHAR2(256) | NO | 任务开始时租户当前时间 | | END_TIMESTAMP | VARCHAR2(256) | NO | 任务结束时租户当前时间 | | STATUS | VARCHAR2(64) | NO | 任务状态： - `INIT` ：任务初始化阶段 - `DOING`：任务执行阶段 - `CANCELING`：任务被取消阶段 - `COMPLETED`：任务执行成功 - `FAILED`：任务执行失败 - `CANCELED`：任务成功被取消 | | TASK_COUNT | NUMBER(38) | YES | backup_set/piece 任务数 | | SUCCESS_TASK_COUNT | NUMBER(38) | YES | backup_set/piece 执行成功的任务数 | | RESULT | NUMBER(38) | NO | 错误码 | | COMMENT | VARCHAR2(4096) | YES | 任务执行说明 | ## 查询示例 用户租户查询本租户已执行的备份清理任务历史信息，展示前 5 条记录。 ```shell obclient [SYS]> SELECT * FROM SYS.DBA_OB_BACKUP_DELETE_JOB_HISTORY WHERE ROWNUM <= 5\G ``` 查询结果如下： ```shell *************************** 1. row *************************** JOB_ID: 20 INCARNATION: 1 INITIATOR_TENANT_ID: 1004 INITIATOR_JOB_ID: 20 EXECUTOR_TENANT_ID: 1004 TYPE: DELETE OBSOLETE BACKUP PARAMETER: 2025-01-07 06:33:50.079557 JOB_LEVEL: USER_TENANT START_TIMESTAMP: 2025-01-08 06:33:50.084931 END_TIMESTAMP: 2025-01-08 06:33:50.160191 STATUS: COMPLETED TASK_COUNT: 0 SUCCESS_TASK_COUNT: 0 RESULT: 0 COMMENT: *************************** 2. row *************************** JOB_ID: 21 INCARNATION: 1 INITIATOR_TENANT_ID: 1004 INITIATOR_JOB_ID: 21 EXECUTOR_TENANT_ID: 1004 TYPE: DELETE OBSOLETE BACKUP PARAMETER: 2025-01-07 07:33:50.384197 JOB_LEVEL: USER_TENANT START_TIMESTAMP: 2025-01-08 07:33:50.387567 END_TIMESTAMP: 2025-01-08 07:33:50.435527 STATUS: COMPLETED TASK_COUNT: 0 SUCCESS_TASK_COUNT: 0 RESULT: 0 COMMENT: *************************** 3. row *************************** JOB_ID: 22 INCARNATION: 1 INITIATOR_TENANT_ID: 1004 INITIATOR_JOB_ID: 22 EXECUTOR_TENANT_ID: 1004 TYPE: DELETE OBSOLETE BACKUP PARAMETER: 2025-01-07 08:33:50.660556 JOB_LEVEL: USER_TENANT START_TIMESTAMP: 2025-01-08 08:33:50.663947 END_TIMESTAMP: 2025-01-08 08:33:50.710906 STATUS: COMPLETED TASK_COUNT: 0 SUCCESS_TASK_COUNT: 0 RESULT: 0 COMMENT: *************************** 4. row *************************** JOB_ID: 23 INCARNATION: 1 INITIATOR_TENANT_ID: 1004 INITIATOR_JOB_ID: 23 EXECUTOR_TENANT_ID: 1004 TYPE: DELETE OBSOLETE BACKUP PARAMETER: 2025-01-07 09:33:50.931100 JOB_LEVEL: USER_TENANT START_TIMESTAMP: 2025-01-08 09:33:50.934741 END_TIMESTAMP: 2025-01-08 09:33:50.984381 STATUS: COMPLETED TASK_COUNT: 0 SUCCESS_TASK_COUNT: 0 RESULT: 0 COMMENT: *************************** 5. row *************************** JOB_ID: 24 INCARNATION: 1 INITIATOR_TENANT_ID: 1004 INITIATOR_JOB_ID: 24 EXECUTOR_TENANT_ID: 1004 TYPE: DELETE OBSOLETE BACKUP PARAMETER: 2025-01-07 10:33:51.206735 JOB_LEVEL: USER_TENANT START_TIMESTAMP: 2025-01-08 10:33:51.210244 END_TIMESTAMP: 2025-01-08 10:33:51.258817 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-1000000001501020) - 查看正在执行的备份清理的 Task 任务的执行进度：[DBA_OB_BACKUP_DELETE_TASKS](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000001500993) - 查看备份清理的 Task 任务的历史信息：[DBA_OB_BACKUP_DELETE_TASK_HISTORY](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000001500790) - 设置自动清理过期备份的详细操作，参见 [自动清理过期备份](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) 咨询热线