delete backup set do not allow

Chris-Wang · 2026 年1 月 6 日 17:54

之前的备份集，通过命令删除，查看job信息显示错误。只显示：delete backup set do not allow。这到底是为什么？


obclient(root@sys)[oceanbase]>  ALTER SYSTEM DELETE BACKUPSET 4 tenant hive;
Query OK, 0 rows affected (0.014 sec)

obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.CDB_OB_BACKUP_DELETE_JOBS\G
*************************** 1. row ***************************
          TENANT_ID: 1
             JOB_ID: 19
        INCARNATION: 1
INITIATOR_TENANT_ID: 1
   INITIATOR_JOB_ID: 19
 EXECUTOR_TENANT_ID: 1002
               TYPE: DELETE BACKUPSET
          PARAMETER: backup_set_id:4
          JOB_LEVEL: SYS_TENANT
    START_TIMESTAMP: 2026-01-06 17:50:41.714422
      END_TIMESTAMP: 2026-01-06 17:51:11.861720
             STATUS: FAILED
         TASK_COUNT: 0
 SUCCESS_TASK_COUNT: 0
             RESULT: -9045
            COMMENT: delete backup set do not allow
1 row in set (0.013 sec)

*************************** 4. row ***************************
               TENANT_ID: 1002
           BACKUP_SET_ID: 4
                 DEST_ID: 1002
             INCARNATION: 1
             BACKUP_TYPE: FULL
 PREV_FULL_BACKUP_SET_ID: 0
  PREV_INC_BACKUP_SET_ID: 0
         START_TIMESTAMP: 2025-12-22 17:38:10.404876
           END_TIMESTAMP: 2025-12-22 17:39:46.086509
                  STATUS: SUCCESS
             FILE_STATUS: AVAILABLE
        ELAPSED_SECONDES: 96
         PLUS_ARCHIVELOG: OFF
        START_REPLAY_SCN: 1766389282030451000
START_REPLAY_SCN_DISPLAY: 2025-12-22 15:41:22.030451
         MIN_RESTORE_SCN: 1766396383028544000
 MIN_RESTORE_SCN_DISPLAY: 2025-12-22 17:39:43.028544000
             INPUT_BYTES: 2018973701
            OUTPUT_BYTES: 35376301
       OUTPUT_RATE_BYTES: 369729.2771
        EXTRA_META_BYTES: 0
            TABLET_COUNT: 811
     FINISH_TABLET_COUNT: 811
       MACRO_BLOCK_COUNT: 962
FINISH_MACRO_BLOCK_COUNT: 962
              FILE_COUNT: 0
            META_TURN_ID: 1
            DATA_TURN_ID: 0
                  RESULT: 0
                 COMMENT: 
         ENCRYPTION_MODE: NONE
                  PASSWD: 
       TENANT_COMPATIBLE: 4.5.0.0
       BACKUP_COMPATIBLE: 4
                    PATH: file:///obbackup/data
         CLUSTER_VERSION: 4.5.0.0
          CONSISTENT_SCN: 1766396330670956000
           MINOR_TURN_ID: 1
           MAJOR_TURN_ID: 1
4 rows in set (0.024 sec)

这到底是为什么，官方文档表示看看是否命令有错误。

旭辉 · 2026 年1 月 6 日 17:58

看下这个
https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000004475986

Chris-Wang · 2026 年1 月 6 日 18:06

obclient(root@sys)[oceanbase]> select * from CDB_OB_BACKUP_DELETE_POLICY;
Empty set (0.016 sec)

我没有什么policy，删除还是报错。

我描述一下几个疑惑点：

之前我的policy是保留1天的备份，而上面的备份其实是12.22号的，已经过快一月，所以我手动删除，发现无法删除，然后删除policy，再执行清除备份命令，也无法删除。
之前数据库是archivelog mode, 我去删除 archivelog piece发现也无法删除，于是我把数据库修改成noarchivelog mode, 还是无法删除archivelog piece。

obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.CDB_OB_BACKUP_DELETE_JOBS\G
*************************** 1. row ***************************
          TENANT_ID: 1
             JOB_ID: 22
        INCARNATION: 1
INITIATOR_TENANT_ID: 1
   INITIATOR_JOB_ID: 22
 EXECUTOR_TENANT_ID: 1002
               TYPE: DELETE BACKUPSET
          PARAMETER: backup_set_id:4
          JOB_LEVEL: SYS_TENANT
    START_TIMESTAMP: 2026-01-06 18:02:40.634554
      END_TIMESTAMP: 2026-01-06 18:03:10.848733
             STATUS: FAILED
         TASK_COUNT: 0
 SUCCESS_TASK_COUNT: 0
             RESULT: -9045
            COMMENT: delete backup set do not allow
1 row in set (0.035 sec)

你看我删除的时间，无法删除

旭辉 · 2026 年1 月 6 日 18:09

压缩发下你操作时间的 observer.log和rootservice.log

Chris-Wang · 2026 年1 月 6 日 18:10

archivelog piece也是如此：

obclient(root@sys)[oceanbase]> SELECT TENANT_ID, ROUND_ID, PIECE_ID, STATUS, FILE_STATUS, START_SCN, START_SCN_DISPLAY, END_SCN, END_SCN_DISPLAY, PATH FROM oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES;
+-----------+----------+----------+--------+-------------+---------------------+----------------------------+---------------------+----------------------------+-----------------------------+
| TENANT_ID | ROUND_ID | PIECE_ID | STATUS | FILE_STATUS | START_SCN           | START_SCN_DISPLAY          | END_SCN             | END_SCN_DISPLAY            | PATH                        |
+-----------+----------+----------+--------+-------------+---------------------+----------------------------+---------------------+----------------------------+-----------------------------+
|      1002 |        1 |        1 | FROZEN | AVAILABLE   | 1766389282030451000 | 2025-12-22 15:41:22.030451 | 1766475682030451000 | 2025-12-23 15:41:22.030451 | file:///obbackup/archivelog |
|      1002 |        1 |        2 | FROZEN | AVAILABLE   | 1766475682030451000 | 2025-12-23 15:41:22.030451 | 1766562082030451000 | 2025-12-24 15:41:22.030451 | file:///obbackup/archivelog |
|      1002 |        1 |        3 | FROZEN | AVAILABLE   | 1766562082030451000 | 2025-12-24 15:41:22.030451 | 1766648482030451000 | 2025-12-25 15:41:22.030451 | file:///obbackup/archivelog |
|      1002 |        1 |        4 | FROZEN | AVAILABLE   | 1766648482030451000 | 2025-12-25 15:41:22.030451 | 1766734882030451000 | 2025-12-26 15:41:22.030451 | file:///obbackup/archivelog |
|      1002 |        1 |        5 | FROZEN | AVAILABLE   | 1766734882030451000 | 2025-12-26 15:41:22.030451 | 1766821282030451000 | 2025-12-27 15:41:22.030451 | file:///obbackup/archivelog |
|      1002 |        1 |        6 | FROZEN | AVAILABLE   | 1766821282030451000 | 2025-12-27 15:41:22.030451 | 1766907682030451000 | 2025-12-28 15:41:22.030451 | file:///obbackup/archivelog |
|      1002 |        1 |        7 | FROZEN | AVAILABLE   | 1766907682030451000 | 2025-12-28 15:41:22.030451 | 1766994082030451000 | 2025-12-29 15:41:22.030451 | file:///obbackup/archivelog |
|      1002 |        1 |        8 | FROZEN | AVAILABLE   | 1766994082030451000 | 2025-12-29 15:41:22.030451 | 1767080482030451000 | 2025-12-30 15:41:22.030451 | file:///obbackup/archivelog |
|      1002 |        1 |        9 | FROZEN | AVAILABLE   | 1767080482030451000 | 2025-12-30 15:41:22.030451 | 1767166882030451000 | 2025-12-31 15:41:22.030451 | file:///obbackup/archivelog |
|      1002 |        1 |       10 | FROZEN | AVAILABLE   | 1767166882030451000 | 2025-12-31 15:41:22.030451 | 1767253282030451000 | 2026-01-01 15:41:22.030451 | file:///obbackup/archivelog |
|      1002 |        1 |       11 | FROZEN | AVAILABLE   | 1767253282030451000 | 2026-01-01 15:41:22.030451 | 1767339682030451000 | 2026-01-02 15:41:22.030451 | file:///obbackup/archivelog |
|      1002 |        1 |       12 | FROZEN | AVAILABLE   | 1767339682030451000 | 2026-01-02 15:41:22.030451 | 1767426082030451000 | 2026-01-03 15:41:22.030451 | file:///obbackup/archivelog |
|      1002 |        1 |       13 | FROZEN | AVAILABLE   | 1767426082030451000 | 2026-01-03 15:41:22.030451 | 1767512482030451000 | 2026-01-04 15:41:22.030451 | file:///obbackup/archivelog |
|      1002 |        1 |       14 | FROZEN | AVAILABLE   | 1767512482030451000 | 2026-01-04 15:41:22.030451 | 1767598882030451000 | 2026-01-05 15:41:22.030451 | file:///obbackup/archivelog |
|      1002 |        1 |       15 | FROZEN | AVAILABLE   | 1767598882030451000 | 2026-01-05 15:41:22.030451 | 1767685282030451000 | 2026-01-06 15:41:22.030451 | file:///obbackup/archivelog |
|      1002 |        1 |       16 | FROZEN | AVAILABLE   | 1767685282030451000 | 2026-01-06 15:41:22.030451 | 1767771682030451000 | 2026-01-07 15:41:22.030451 | file:///obbackup/archivelog |
+-----------+----------+----------+--------+-------------+---------------------+----------------------------+---------------------+----------------------------+-----------------------------+
16 rows in set (0.019 sec)

obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.CDB_OB_BACKUP_DELETE_JOBS\G
*************************** 1. row ***************************
          TENANT_ID: 1
             JOB_ID: 23
        INCARNATION: 1
INITIATOR_TENANT_ID: 1
   INITIATOR_JOB_ID: 23
 EXECUTOR_TENANT_ID: 1002
               TYPE: DELETE ARCHIVELOG_PIECE
          PARAMETER: archivelog_piece_id:1
          JOB_LEVEL: SYS_TENANT
    START_TIMESTAMP: 2026-01-06 18:09:01.483970
      END_TIMESTAMP: 2026-01-06 18:09:31.539848
             STATUS: FAILED
         TASK_COUNT: 0
 SUCCESS_TASK_COUNT: 0
             RESULT: -9069
            COMMENT: deleting backup piece is not allowed
1 row in set (0.040 sec)

错误一样，也是无法删除。到底哪里还有什么限制吗？

旭辉 · 2026 年1 月 6 日 18:17

发下日志吧，需要分析看下

Chris-Wang · 2026 年1 月 6 日 18:22

正在上传：observer.log.tar.gz…
rootservice.log.tar.gz (5.4 MB)

observer日志太大，我就传了一台。

旭辉 · 2026 年1 月 7 日 10:53

那你先发rootserver节点的observer.log和rootservice.log吧，复现下然后发下对应日志文件，压缩上传，是可以上传成功的