设置本租户的清理策略,备份文件没有清理干净

【 使用环境 】生产环境 or 测试环境
【 OB or 其他组件 】
【 使用版本 】4.3.4
【问题描述】

设置本租户的清理策略,备份文件没有清理干净,残留complement_log日志


1 个赞

–先确认是不是“已经删完、只剩垃圾目录”
– 清理策略
SELECT * FROM oceanbase.DBA_OB_BACKUP_DELETE_POLICY;

– 备份集是否已 DELETED,以及是否带补偿日志
SELECT backup_set_id, backup_type, plus_archivelog, file_status,
start_timestamp, min_restore_timestamp
FROM oceanbase.DBA_OB_BACKUP_SET_FILES
ORDER BY backup_set_id;

– 最近清理任务
SELECT * FROM oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY
ORDER BY start_timestamp DESC LIMIT 20;

SELECT * FROM oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY
ORDER BY start_timestamp DESC LIMIT 50;