跳到主要内容

清理归档日志

查询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';

}