oracle 数据库下有时候需要删除归档日志,分两种情况
1、操作系统删除
# rm -f ./archive*.dbf
使用rm命令后,此时在os上文件是被删除了,但是 archivelog 信息还是记录在controlfile里,需要使用 rman 清除一下。
$ rman target /
RMAN> list archivelog all;
crosscheck archivelog all;
list expired archivelog all;
delete noprompt expired archivelog all;
rman 命令删除
个人建议优先考虑rman删除archivelog,该命令会同时删除os和 controlfile有关archivelog的信息
$ rman target /
RMAN> delete force noprompt archivelog all;
RMAN> delete force noprompt archivelog all completed before 'sysdate - 3';
RMAN> delete force noprompt archivelog until time "to_date('2019-07-06 04:00:00','yyyy-mm-dd hh24:mi:ss')";
RMAN> delete force noprompt archivelog until sequence 123;
RMAN> delete force noprompt archivelog from time 'sysdate-1';