【使用环境 】 测试环境
【 OB or 其他组件 】
【 使用版本 】oceanbase-ce-4.3.5.1
【问题描述】进行了多次全量备份，而且设置每小时清理，备份目的端的数据清理掉了，备份归档日志什么时候会清理？
【重新步骤】
– 配置归档目的端
ALTER SYSTEM SET LOG_ARCHIVE_DEST=‘LOCATION=file:///hybackup/archive’ TENANT = ‘haiyisec’;
– 配置备份目的端
ALTER SYSTEM SET DATA_BACKUP_DEST=‘file:///hybackup/data’ TENANT = ‘haiyisec’;
– 开启归档模式
ALTER SYSTEM ARCHIVELOG TENANT = ‘haiyisec’;
– 全量备份
ALTER SYSTEM BACKUP TENANT = ‘haiyisec’ PLUS ARCHIVELOG;
– 每小时清理
ALTER SYSTEM ADD DELETE BACKUP POLICY ‘default’ RECOVERY_WINDOW ‘1h’ TENANT = ‘haiyisec’
SELECT * FROM oceanbase.CDB_OB_BACKUP_DELETE_POLICY;
SELECT * FROM CDB_OB_BACKUP_DELETE_JOB_HISTORY\G;
SELECT * FROM oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY;
SELECT * FROM oceanbase.CDB_OB_BACKUP_SET_FILES WHERE TENANT_ID = tenant_id order by START_TIMESTAMP;
SELECT * FROM oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES WHERE TENANT_ID = tenant_id order by START_TIMESTAMP;
