首批通过分布式安全可靠测评,为关键业务系统打造
备份配置自动清理策略但过期备份未正常清理
更新时间:2026-05-11 09:51
适用版本
OceanBase 数据库 V2.x、V3.x 版本。
问题现象
物理备份配置了自动清理策略,但是实际过期的基线备份未正常清理。
obclient [oceanbase]> show parameters like '%backup_dest_option';
recovery_window=7d&auto_delete_obsolete_backup=true&backup_copies=2&log_archive_piece_switch_interval=1d
obclient [oceanbase]> show parameters like 'auto_delete_expired_backup';
+-------+----------+---------------+----------+----------------------------+-----------+-------+---------------------------------------+----------+---------+---------+-------------------+
| zone | svr_type | svr_ip | svr_port | name | data_type | value | info | section | scope | source | edit_level |
+-------+----------+---------------+----------+----------------------------+-----------+-------+---------------------------------------+----------+---------+---------+-------------------+
| zone3 | observer | xx.xx.xx.xx | 2882 | auto_delete_expired_backup | NULL | True | control if auto delete expired backup | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE |
obclient [oceanbase]> show parameters like 'backup_recovery_window';
+-------+----------+---------------+----------+------------------------+-----------+-------+-----------------------------------------------------------------------------------------------+----------+---------+---------+-------------------+
| zone | svr_type | svr_ip | svr_port | name | data_type | value | info | section | scope | source | edit_level |
+-------+----------+---------------+----------+------------------------+-----------+-------+-----------------------------------------------------------------------------------------------+----------+---------+---------+-------------------+
| zone3 | observer | xx.xx.xx.xx | 2882 | backup_recovery_window | NULL | 7d | backup expired day limit, 0 means not expiredRange: [0, max) in time interval, for example 7d | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE |
问题原因
该问题与配置项 backup_dest_option 中 backup_copies 的设置有关。
如果
backup_copies设置为 0 或 1,意味着没有二次备份,系统在清理备份文件时不会考虑二次备份是否已成功。如果
backup_copies设置为 2,则仅当一次备份数据完成二次备份后才会执行备份清理。
由于备份时配置项 backup_dest_option 中 backup_copies 参数设置为 2,但实际并未启动二次备份的操作,导致所有的备份数据都不满足清理条件,使得自动清理和手动清理都无法将备份数据清理掉。
解决方法
去除配置项 backup_dest_option 中参数 backup_copies 的设置,backup_copies 的默认值为 0。