Window上归档日志删除脚本

--##Window上归档日志删除脚本del_arch.bat ##计划任务中配置自动任务
--## del_arch.bat
set ORACLE_SID=orcl
rman target / cmdfile='D:\autojob\del_arch_src.sql' msglog='D:\autojob\del_arch_src.log'

--## D:\autojob\del_arch_src.sql
RUN{
crosscheck archivelog all;
delete noprompt archivelog until time 'sysdate - 1';
--#delete noprompt archivelog until time = 'sysdate - 1' backed up 1 times to device type disk;
}