he following commands will helpful to delete the expired archive log files using Oracle Recovery Manager(RMAN).Connect to the Rman prompt and try the bellow commands.
RMAN>list expired archivelog all;
RMAN>crosscheck archivelog all;
RMAN>delete noprompt expired archivelog all;
RMAN>list expired archivelog all;
Sample Ouptut:
RMAN> list expired archivelog all;
specification does not match any archived log in the repository
RMAN>
In my develop environment , sometime the archive destination folder is full, caused the database hang. So I will use below command to disable it.
Disable Archive log mode
startup mount
alter database noarchivelog;
alter database open;
方法一:
rman target/
或rman target/@orcl
在命令窗口里面执行
delete noprompt archivelog until time 'sysdate-7'; //删除七天前的归档,果使用了闪回功能,也会删除闪回的数据。
DELETE ARCHIVELOG FROM TIME 'SYSDATE-7'; //删除七天到现在的归档
方法二:(rman登不进去)
执行find /archive/ -name "*.dbf"|wc –l查看有多少归档日志
删除7天之前的所有归档文件
find /archive/ -name "*.dbf" -mtime +7 -exec rm -f {} ;
将归档日志信息进行更新
asm 就得用asmcmd交互界面rm了
RMAN> crosscheck archivelog all;
RMAN> delete noprompt expired archivelog all;
RMAN> exit