清理归档日志
查询apply的归档序号
select max(sequence#) from v$archived_log where applied='YES';
可以按查到的序号rm已应用的归档,也可通过以下脚本删除
进入rman
rman target /
清理归档
crosscheck archivelog all;
crosscheck backup;
-- 清理过期归档
delete noprompt expired archivelog all;
delete noprompt obsolete;
delete expired copy;
delete noprompt expired backup;
-- 强制清理两天前的归档日志
run{
delete noprompt archivelog all completed before 'sysdate-2';
}