ob4.3.5的备份删除策略不起作用?

【 使用环境 】测试环境
【 OB使用版本 】4.3.5


【问题描述】做了多次手动的ob租户全量备份,和7天的自动备份删除策略,有历史清理job记录,但发现备份并没有被删除?为何?目前已经存放了5个全量备份,导致空间紧张。

[root@ob ~]# cd /backup/lnzyob/data/
[root@ob data]# ls -lt
total 8
drwx------. 2 root root 4096 Nov 17 12:05 backup_sets
drwx------. 5 root root  224 Nov 17 12:05 backup_set_5_full
drwx------. 5 root root  224 Nov 16 18:16 backup_set_4_full
drwx------. 5 root root  224 Nov 14 12:19 backup_set_3_full
drwx------. 5 root root  224 Nov 10 11:33 backup_set_2_full --这个已经是8天了
-rw-------. 1 root root  140 Oct 29 13:23 format.obbak
drwx------. 2 root root   53 Oct 29 13:23 check_file
[root@ob data]# du -sh *
185G    backup_set_2_full  --备份文件还在
185G    backup_set_3_full
185G    backup_set_4_full
185G    backup_set_5_full
36K     backup_sets
4.0K    check_file
4.0K    format.obbak
[root@ob data]# date
Tue Nov 18 09:17:38 CST 2025
[root@ob data]# obclient -h192.168.207.18 -P2881 -uroot@sys -p'linux2025.' -Doceanbase -A
Welcome to the OceanBase.  Commands end with ; or \g.
Your OceanBase connection id is 3221588684
Server version: OceanBase 4.3.5.3 (r103040032025092501-bcea1d40bd48deb5da7b483709579d2f8ea84ee6) (Built Sep 25 2025 01:27:34)

Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

obclient(root@sys)[oceanbase]> SELECT * FROM CDB_OB_BACKUP_DELETE_POLICY;
+-----------+-------------+-----------------+
| TENANT_ID | POLICY_NAME | RECOVERY_WINDOW |
+-----------+-------------+-----------------+
|      1002 | default     | 7d              | ---保留时间是7天
+-----------+-------------+-----------------+
1 row in set (0.097 sec)

obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.CDB_OB_BACKUP_TASK_HISTORY\G
*************************** 1. row ***************************
               TENANT_ID: 1002
                 TASK_ID: 1
                  JOB_ID: 1
             INCARNATION: 1
           BACKUP_SET_ID: 1
         START_TIMESTAMP: 2025-10-29 13:23:54.969878
           END_TIMESTAMP: 2025-10-29 14:18:49.743895
                  STATUS: COMPLETED
               START_SCN: 1761715452030565000
                 END_SCN: 1761718720023072000
       USER_LS_START_SCN: 1761715462002868000
         ENCRYPTION_MODE: NONE
                  PASSWD: 
             INPUT_BYTES: 284822823607
            OUTPUT_BYTES: 233298275234
       OUTPUT_RATE_BYTES: 70808581.7207
        EXTRA_META_BYTES: 0
            TABLET_COUNT: 6152
     FINISH_TABLET_COUNT: 6152
       MACRO_BLOCK_COUNT: 135797
FINISH_MACRO_BLOCK_COUNT: 135797
              FILE_COUNT: 0
            META_TURN_ID: 1
            DATA_TURN_ID: 0
                  RESULT: 0
                 COMMENT: 
                    PATH: file:///backup/lnzyob/data
           MINOR_TURN_ID: 1
           MAJOR_TURN_ID: 1
*************************** 2. row ***************************
               TENANT_ID: 1002
                 TASK_ID: 2
                  JOB_ID: 2
             INCARNATION: 1
           BACKUP_SET_ID: 2
         START_TIMESTAMP: 2025-11-10 10:42:01.799105
           END_TIMESTAMP: 2025-11-10 11:33:21.944992
                  STATUS: COMPLETED
               START_SCN: 1762742531611400000
                 END_SCN: 1762745592455625000
       USER_LS_START_SCN: 1762742541122915000
         ENCRYPTION_MODE: NONE
                  PASSWD: 
             INPUT_BYTES: 234361965305
            OUTPUT_BYTES: 197171565127
       OUTPUT_RATE_BYTES: 64013709.8568
        EXTRA_META_BYTES: 0
            TABLET_COUNT: 6152
     FINISH_TABLET_COUNT: 6152
       MACRO_BLOCK_COUNT: 111740
FINISH_MACRO_BLOCK_COUNT: 111740
              FILE_COUNT: 0
            META_TURN_ID: 1
            DATA_TURN_ID: 0
                  RESULT: 0
                 COMMENT: 
                    PATH: file:///backup/lnzyob/data
           MINOR_TURN_ID: 1
           MAJOR_TURN_ID: 1
*************************** 3. row ***************************
               TENANT_ID: 1002
                 TASK_ID: 3
                  JOB_ID: 3
             INCARNATION: 1
           BACKUP_SET_ID: 3
         START_TIMESTAMP: 2025-11-14 11:31:39.747239
           END_TIMESTAMP: 2025-11-14 12:19:21.404765
                  STATUS: COMPLETED
               START_SCN: 1763091121723413000
                 END_SCN: 1763093951741047000
       USER_LS_START_SCN: 1763091134999439000
         ENCRYPTION_MODE: NONE
                  PASSWD: 
             INPUT_BYTES: 234403908819
            OUTPUT_BYTES: 197172193003
       OUTPUT_RATE_BYTES: 68901394.1087
        EXTRA_META_BYTES: 0
            TABLET_COUNT: 6152
     FINISH_TABLET_COUNT: 6152
       MACRO_BLOCK_COUNT: 111760
FINISH_MACRO_BLOCK_COUNT: 111760
              FILE_COUNT: 0
            META_TURN_ID: 1
            DATA_TURN_ID: 0
                  RESULT: 0
                 COMMENT: 
                    PATH: file:///backup/lnzyob/data
           MINOR_TURN_ID: 1
           MAJOR_TURN_ID: 1
*************************** 4. row ***************************
               TENANT_ID: 1002
                 TASK_ID: 4
                  JOB_ID: 57
             INCARNATION: 1
           BACKUP_SET_ID: 4
         START_TIMESTAMP: 2025-11-16 17:16:16.700891
           END_TIMESTAMP: 2025-11-16 18:16:34.651781
                  STATUS: COMPLETED
               START_SCN: 1763284590034814000
                 END_SCN: 1763288184614041000
       USER_LS_START_SCN: 1763284603157180000
         ENCRYPTION_MODE: NONE
                  PASSWD: 
             INPUT_BYTES: 234420683884
            OUTPUT_BYTES: 197173651692
       OUTPUT_RATE_BYTES: 54498708.7130
        EXTRA_META_BYTES: 0
            TABLET_COUNT: 6152
     FINISH_TABLET_COUNT: 6152
       MACRO_BLOCK_COUNT: 111768
FINISH_MACRO_BLOCK_COUNT: 111768
              FILE_COUNT: 0
            META_TURN_ID: 1
            DATA_TURN_ID: 0
                  RESULT: 0
                 COMMENT: 
                    PATH: file:///backup/lnzyob/data
           MINOR_TURN_ID: 1
           MAJOR_TURN_ID: 1
*************************** 5. row ***************************
               TENANT_ID: 1002
                 TASK_ID: 5
                  JOB_ID: 75
             INCARNATION: 1
           BACKUP_SET_ID: 5
         START_TIMESTAMP: 2025-11-17 11:07:06.511714
           END_TIMESTAMP: 2025-11-17 12:05:48.653540
                  STATUS: COMPLETED
               START_SCN: 1763348837043040000
                 END_SCN: 1763352338850327000
       USER_LS_START_SCN: 1763348849349840000
         ENCRYPTION_MODE: NONE
                  PASSWD: 
             INPUT_BYTES: 234460533921
            OUTPUT_BYTES: 197172153550
       OUTPUT_RATE_BYTES: 55980753.5558
        EXTRA_META_BYTES: 0
            TABLET_COUNT: 6152
     FINISH_TABLET_COUNT: 6152
       MACRO_BLOCK_COUNT: 111787
FINISH_MACRO_BLOCK_COUNT: 111787
              FILE_COUNT: 0
            META_TURN_ID: 1
            DATA_TURN_ID: 0
                  RESULT: 0
                 COMMENT: 
                    PATH: file:///backup/lnzyob/data
           MINOR_TURN_ID: 1
           MAJOR_TURN_ID: 1
5 rows in set (0.184 sec)

obclient(root@sys)[oceanbase]> select BACKUP_SET_ID,START_TIMESTAMP,END_TIMESTAMP,STATUS,PATH FROM oceanbase.CDB_OB_BACKUP_SET_FILES;
+---------------+----------------------------+----------------------------+---------+----------------------------+
| BACKUP_SET_ID | START_TIMESTAMP            | END_TIMESTAMP              | STATUS  | PATH                       |
+---------------+----------------------------+----------------------------+---------+----------------------------+
|             1 | 2025-10-29 13:23:54.969878 | 2025-10-29 14:18:49.743895 | SUCCESS | file:///backup/lnzyob/data |
|             2 | 2025-11-10 10:42:01.799105 | 2025-11-10 11:33:21.944992 | SUCCESS | file:///backup/lnzyob/data |
|             3 | 2025-11-14 11:31:39.747239 | 2025-11-14 12:19:21.404765 | SUCCESS | file:///backup/lnzyob/data |
|             4 | 2025-11-16 17:16:16.700891 | 2025-11-16 18:16:34.651781 | SUCCESS | file:///backup/lnzyob/data |
|             5 | 2025-11-17 11:07:06.511714 | 2025-11-17 12:05:48.653540 | SUCCESS | file:///backup/lnzyob/data |
+---------------+----------------------------+----------------------------+---------+----------------------------+
5 rows in set (0.092 sec)

obclient(root@sys)[oceanbase]> 
obclient(root@sys)[oceanbase]> select * from CDB_OB_BACKUP_DELETE_TASK_HISTORY;
+-----------+---------+-------------+--------+--------------+------+----------+---------+----------------------------+----------------------------+-----------+----------------+-----------------+--------+---------+----------------------------+
| TENANT_ID | TASK_ID | INCARNATION | JOB_ID | TASK_TYPE    | ID   | ROUND_ID | DEST_ID | START_TIMESTAMP            | END_TIMESTAMP              | STATUS    | TOTAL_LS_COUNT | FINISH_LS_COUNT | RESULT | COMMENT | PATH                       |
+-----------+---------+-------------+--------+--------------+------+----------+---------+----------------------------+----------------------------+-----------+----------------+-----------------+--------+---------+----------------------------+
|      1002 |       6 |           1 |     77 | BACKUP SET   |    1 |        0 |    1003 | 2025-11-17 12:09:22.131316 | 2025-11-17 12:09:52.431795 | COMPLETED |              0 |               0 |      0 |         | file:///backup/lnzyob/data |
|      1002 |       7 |           1 |     77 | BACKUP PIECE |    1 |        1 |    1002 | 2025-11-17 12:09:22.157173 | 2025-11-17 12:09:53.864509 | COMPLETED |              2 |               2 |      0 |         | file:///backup/lnzyob/log  |
|      1002 |       8 |           1 |     77 | BACKUP PIECE |    2 |        1 |    1002 | 2025-11-17 12:09:22.164193 | 2025-11-17 12:09:55.976068 | COMPLETED |              2 |               2 |      0 |         | file:///backup/lnzyob/log  |
+-----------+---------+-------------+--------+--------------+------+----------+---------+----------------------------+----------------------------+-----------+----------------+-----------------+--------+---------+----------------------------+
3 rows in set (0.016 sec)

obclient(root@sys)[oceanbase]> 

obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY;
+-----------+--------+-------------+---------------------+------------------+--------------------+------------------------+----------------------------+-------------+----------------------------+----------------------------+-----------+------------+--------------------+--------+---------+
| TENANT_ID | JOB_ID | INCARNATION | INITIATOR_TENANT_ID | INITIATOR_JOB_ID | EXECUTOR_TENANT_ID | TYPE                   | PARAMETER                  | JOB_LEVEL   | START_TIMESTAMP            | END_TIMESTAMP              | STATUS    | TASK_COUNT | SUCCESS_TASK_COUNT | RESULT | COMMENT |
+-----------+--------+-------------+---------------------+------------------+--------------------+------------------------+----------------------------+-------------+----------------------------+----------------------------+-----------+------------+--------------------+--------+---------+
|      1002 |      4 |           1 |                1002 |                4 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-07 13:08:46.820998 | USER_TENANT | 2025-11-14 13:08:46.829172 | 2025-11-14 13:08:47.009534 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |      5 |           1 |                1002 |                5 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-07 14:08:47.423506 | USER_TENANT | 2025-11-14 14:08:47.42628

 省略一些记录,太长了

|      1002 |     30 |           1 |                1002 |               30 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-08 15:08:59.625815 | USER_TENANT | 2025-11-15 15:08:59.630151 | 2025-11-15 15:08:59.694513 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     31 |           1 |                1002 |               31 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-08 16:09:00.118512 | USER_TENANT | 2025-11-15 16:09:00.120762 | 2025-11-15 16:09:00.215475 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     32 |           1 |                1002 |               32 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-08 17:09:00.640005 | USER_TENANT | 2025-11-15 17:09:00.641705 | 2025-11-15 17:09:00.679821 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     33 |           1 |                1002 |               33 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-08 18:09:01.103081 | USER_TENANT | 2025-11-15 18:09:01.107859 | 2025-11-15 18:09:01.167375 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     34 |           1 |                1002 |               34 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-08 19:09:01.596905 | USER_TENANT | 2025-11-15 19:09:01.602164 | 2025-11-15 19:09:01.651808 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     35 |           1 |                1002 |               35 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-08 20:09:02.091340 | USER_TENANT | 2025-11-15 20:09:02.095709 | 2025-11-15 20:09:02.141963 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     36 |           1 |                1002 |               36 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-08 21:09:02.557688 | USER_TENANT | 2025-11-15 21:09:02.560218 | 2025-11-15 21:09:02.622703 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     37 |           1 |                1002 |               37 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-08 22:09:03.025501 | USER_TENANT | 2025-11-15 22:09:03.043900 | 2025-11-15 22:09:03.140051 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     38 |           1 |                1002 |               38 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-08 23:09:03.568641 | USER_TENANT | 2025-11-15 23:09:03.570768 | 2025-11-15 23:09:03.627344 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     39 |           1 |                1002 |               39 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-09 00:09:04.060248 | USER_TENANT | 2025-11-16 00:09:04.062474 | 2025-11-16 00:09:04.121889 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     40 |           1 |                1002 |               40 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-09 01:09:04.548372 | USER_TENANT | 2025-11-16 01:09:04.552824 | 2025-11-16 01:09:04.615948 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     41 |           1 |                1002 |               41 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-09 02:09:05.076872 | USER_TENANT | 2025-11-16 02:09:05.100281 | 2025-11-16 02:09:05.333820 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     42 |           1 |                1002 |               42 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-09 03:09:05.746274 | USER_TENANT | 2025-11-16 03:09:05.754942 | 2025-11-16 03:09:05.819152 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     43 |           1 |                1002 |               43 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-09 04:09:06.219621 | USER_TENANT | 2025-11-16 04:09:06.221549 | 2025-11-16 04:09:06.277239 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     44 |           1 |                1002 |               44 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-09 05:09:06.686926 | USER_TENANT | 2025-11-16 05:09:06.689218 | 2025-11-16 05:09:06.747184 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     45 |           1 |                1002 |               45 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-09 06:09:07.173667 | USER_TENANT | 2025-11-16 06:09:07.176376 | 2025-11-16 06:09:07.269041 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     46 |           1 |                1002 |               46 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-09 07:09:07.689226 | USER_TENANT | 2025-11-16 07:09:07.691507 | 2025-11-16 07:09:07.735336 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     47 |           1 |                1002 |               47 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-09 08:09:08.162196 | USER_TENANT | 2025-11-16 08:09:08.170651 | 2025-11-16 08:09:08.251628 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     48 |           1 |                1002 |               48 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-09 09:09:08.655102 | USER_TENANT | 2025-11-16 09:09:08.660090 | 2025-11-16 09:09:08.744424 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     49 |           1 |                1002 |               49 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-09 10:09:09.158786 | USER_TENANT | 2025-11-16 10:09:09.161501 | 2025-11-16 10:09:09.235501 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     50 |           1 |                1002 |               50 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-09 11:09:09.640186 | USER_TENANT | 2025-11-16 11:09:09.641938 | 2025-11-16 11:09:09.727115 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     51 |           1 |                1002 |               51 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-09 12:09:10.135520 | USER_TENANT | 2025-11-16 12:09:10.138681 | 2025-11-16 12:09:10.215097 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     52 |           1 |                1002 |               52 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-09 13:09:10.615948 | USER_TENANT | 2025-11-16 13:09:10.618515 | 2025-11-16 13:09:10.689010 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     53 |           1 |                1002 |               53 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-09 14:09:11.109690 | USER_TENANT | 2025-11-16 14:09:11.127620 | 2025-11-16 14:09:11.225880 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     54 |           1 |                1002 |               54 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-09 15:09:11.621239 | USER_TENANT | 2025-11-16 15:09:11.623284 | 2025-11-16 15:09:11.692717 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     55 |           1 |                1002 |               55 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-09 16:09:12.070188 | USER_TENANT | 2025-11-16 16:09:12.083131 | 2025-11-16 16:09:12.193986 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     56 |           1 |                1002 |               56 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-09 17:09:12.670382 | USER_TENANT | 2025-11-16 17:09:12.675181 | 2025-11-16 17:09:12.729771 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     58 |           1 |                1002 |               58 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-09 18:09:13.118820 | USER_TENANT | 2025-11-16 18:09:13.138612 | 2025-11-16 18:09:13.303398 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     59 |           1 |                1002 |               59 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-09 19:09:13.746511 | USER_TENANT | 2025-11-16 19:09:13.749142 | 2025-11-16 19:09:13.802400 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     60 |           1 |                1002 |               60 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-09 20:09:14.217916 | USER_TENANT | 2025-11-16 20:09:14.220383 | 2025-11-16 20:09:14.266097 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     61 |           1 |                1002 |               61 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-09 21:09:14.682835 | USER_TENANT | 2025-11-16 21:09:14.685138 | 2025-11-16 21:09:14.728970 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     62 |           1 |                1002 |               62 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-09 22:09:15.119086 | USER_TENANT | 2025-11-16 22:09:15.123214 | 2025-11-16 22:09:15.211041 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     63 |           1 |                1002 |               63 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-09 23:09:15.644323 | USER_TENANT | 2025-11-16 23:09:15.650023 | 2025-11-16 23:09:15.704296 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     64 |           1 |                1002 |               64 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-10 00:09:16.131353 | USER_TENANT | 2025-11-17 00:09:16.135188 | 2025-11-17 00:09:16.180739 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     65 |           1 |                1002 |               65 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-10 01:09:16.646141 | USER_TENANT | 2025-11-17 01:09:16.655285 | 2025-11-17 01:09:16.714953 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     66 |           1 |                1002 |               66 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-10 02:09:17.134780 | USER_TENANT | 2025-11-17 02:09:17.184254 | 2025-11-17 02:09:17.345503 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     67 |           1 |                1002 |               67 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-10 03:09:17.730792 | USER_TENANT | 2025-11-17 03:09:17.737554 | 2025-11-17 03:09:17.784443 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     68 |           1 |                1002 |               68 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-10 04:09:18.167869 | USER_TENANT | 2025-11-17 04:09:18.170075 | 2025-11-17 04:09:18.228425 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     69 |           1 |                1002 |               69 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-10 05:09:18.642651 | USER_TENANT | 2025-11-17 05:09:18.649035 | 2025-11-17 05:09:18.704244 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     70 |           1 |                1002 |               70 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-10 06:09:19.120670 | USER_TENANT | 2025-11-17 06:09:19.126736 | 2025-11-17 06:09:19.171203 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     71 |           1 |                1002 |               71 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-10 07:09:19.583734 | USER_TENANT | 2025-11-17 07:09:19.589759 | 2025-11-17 07:09:19.702256 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     72 |           1 |                1002 |               72 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-10 08:09:20.098625 | USER_TENANT | 2025-11-17 08:09:20.102613 | 2025-11-17 08:09:20.162228 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     73 |           1 |                1002 |               73 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-10 09:09:20.550935 | USER_TENANT | 2025-11-17 09:09:20.554217 | 2025-11-17 09:09:20.594158 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     74 |           1 |                1002 |               74 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-10 10:09:21.011785 | USER_TENANT | 2025-11-17 10:09:21.016083 | 2025-11-17 10:09:21.070878 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     76 |           1 |                1002 |               76 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-10 11:09:21.473849 | USER_TENANT | 2025-11-17 11:09:21.478006 | 2025-11-17 11:09:21.538520 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     77 |           1 |                1002 |               77 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-10 12:09:21.957713 | USER_TENANT | 2025-11-17 12:09:21.961868 | 2025-11-17 12:09:55.986540 | COMPLETED |          3 |                  3 |      0 |         |
|      1002 |     78 |           1 |                1002 |               78 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-10 13:09:26.392423 | USER_TENANT | 2025-11-17 13:09:26.396674 | 2025-11-17 13:09:26.479735 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     79 |           1 |                1002 |               79 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-10 14:09:26.888970 | USER_TENANT | 2025-11-17 14:09:26.891091 | 2025-11-17 14:09:26.970882 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     80 |           1 |                1002 |               80 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-10 15:09:27.376801 | USER_TENANT | 2025-11-17 15:09:27.381943 | 2025-11-17 15:09:27.455853 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     81 |           1 |                1002 |               81 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-10 16:09:27.889015 | USER_TENANT | 2025-11-17 16:09:27.891440 | 2025-11-17 16:09:27.964061 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     82 |           1 |                1002 |               82 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-10 17:09:28.416086 | USER_TENANT | 2025-11-17 17:09:28.418394 | 2025-11-17 17:09:28.546490 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     83 |           1 |                1002 |               83 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-10 18:09:28.934761 | USER_TENANT | 2025-11-17 18:09:28.936720 | 2025-11-17 18:09:28.975829 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     84 |           1 |                1002 |               84 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-10 19:09:29.356669 | USER_TENANT | 2025-11-17 19:09:29.358612 | 2025-11-17 19:09:29.404483 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     85 |           1 |                1002 |               85 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-10 20:09:29.792143 | USER_TENANT | 2025-11-17 20:09:29.794291 | 2025-11-17 20:09:29.841294 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     86 |           1 |                1002 |               86 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-10 21:09:30.213454 | USER_TENANT | 2025-11-17 21:09:30.215712 | 2025-11-17 21:09:30.261593 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     87 |           1 |                1002 |               87 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-10 22:09:30.687753 | USER_TENANT | 2025-11-17 22:09:30.701787 | 2025-11-17 22:09:30.805961 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     88 |           1 |                1002 |               88 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-10 23:09:31.244657 | USER_TENANT | 2025-11-17 23:09:31.247218 | 2025-11-17 23:09:31.311311 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     89 |           1 |                1002 |               89 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-11 00:09:31.737736 | USER_TENANT | 2025-11-18 00:09:31.740643 | 2025-11-18 00:09:31.802706 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     90 |           1 |                1002 |               90 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-11 01:09:32.206218 | USER_TENANT | 2025-11-18 01:09:32.208894 | 2025-11-18 01:09:32.286571 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     91 |           1 |                1002 |               91 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-11 02:09:32.715792 | USER_TENANT | 2025-11-18 02:09:32.737176 | 2025-11-18 02:09:32.891795 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     92 |           1 |                1002 |               92 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-11 03:09:33.270691 | USER_TENANT | 2025-11-18 03:09:33.279741 | 2025-11-18 03:09:33.399923 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     93 |           1 |                1002 |               93 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-11 04:09:33.842139 | USER_TENANT | 2025-11-18 04:09:33.846775 | 2025-11-18 04:09:33.905465 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     94 |           1 |                1002 |               94 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-11 05:09:34.336313 | USER_TENANT | 2025-11-18 05:09:34.339007 | 2025-11-18 05:09:34.397755 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     95 |           1 |                1002 |               95 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-11 06:09:34.820532 | USER_TENANT | 2025-11-18 06:09:34.823251 | 2025-11-18 06:09:34.896311 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     96 |           1 |                1002 |               96 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-11 07:09:35.356111 | USER_TENANT | 2025-11-18 07:09:35.358985 | 2025-11-18 07:09:35.444914 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     97 |           1 |                1002 |               97 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-11 08:09:35.812586 | USER_TENANT | 2025-11-18 08:09:35.814637 | 2025-11-18 08:09:35.872155 | COMPLETED |          0 |                  0 |      0 |         |
|      1002 |     98 |           1 |                1002 |               98 | 1002               | DELETE OBSOLETE BACKUP | 2025-11-11 09:09:36.221054 | USER_TENANT | 2025-11-18 09:09:36.223222 | 2025-11-18 09:09:36.292272 | COMPLETED |          0 |                  0 |      0 |         |
+-----------+--------+-------------+---------------------+------------------+--------------------+------------------------+----------------------------+-------------+----------------------------+----------------------------+-----------+------------+--------------------+--------+---------+
93 rows in set (0.131 sec)


已参考的文档,不起作用:自动清理过期备份
https://www.oceanbase.com/docs/common-oceanbase-database-standalone-1000000003577572

1 个赞

@淇铭

赞赞赞

RECOVERY_WINDOW是7天,最早的备份文件是11.10号的,这是正常的

您觉得哪天才会删掉?

RECOVERY_WINDOW是7天的含义是说 需要保证最近7天的数据可恢复,如果要恢复11.12号的数据 是否得用 11.10号的这个全备份?