首先寒砖，先使用rman命令，手動清理一下歸檔日志
（1）set oracle_sid=orcl
（2）rman.exe target /
（3）然后執(zhí)行rman的命令即可
crosscheck archivelog all; #校驗日志的可用性
list expired archivelog all; #列出所有失效的歸檔日志
刪除系統(tǒng)時間七天以前的歸檔日志
delete force archivelog all completed before 'sysdate-7';
清除當前所有的歸檔日志
delete force archivelog all completed before 'sysdate';
具體的清理腳本
delete_arch.bat
rman cmdfile=E:\arch_clean\delete_arch.txt
echo bat in %date% %time% clean arch sucessed>E:\arch_clean\clean.txt
delete_arch.txt
connect target /
run{
DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7'; //刪除7天前的歸檔日志,怕哪天DG有問題，有日志沒有及時應用
crosscheck archivelog all;
delete expired archivelog all;
}
