oracle归档日志清理

RMAN清除方式会自动清除磁盘上的归档日志文件，同时会释放控制文件中对应的归档日志的归档信息。

• rman target /
• crosscheck archivelog all; –查看所有的归档日志文件是否都是正常的
• delete expired archivelog all;
• DELETE ARCHIVELOG ALL COMPLETED BEFORE ‘SYSDATE-7’;
• DELETE ARCHIVELOG FROM TIME ‘SYSDATE-7’;
• list archivelog all;
• sql ‘alter system switch logfile’;

- list expired archivelog all;; –列出所有失效的归档日志
- delete archivelog until sequence 16; –删除log sequence为16及16之前的所有归档日志
- delete archivelog all completed before ‘sysdate-7’; –删除系统时间7天以前的归档日志，不会删除闪回区有效的归档日志
- delete archivelog all completed before ‘sysdate - 1’; –同上，1天以前的
- delete archivelog from time ‘sysdate-1’; –注意这个命令，删除系统时间1天以内到现在的归档日志
- delete noprompt archivelog all completed before ‘sysdate’; –该命令清除所有的归档日志
- delete noprompt archivelog all; –同上一命令*