1、创建一个删除归档日志的内容(dellog.txt):
connect target sys/atmshis
run{
DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-2'; //删除两天前的归档日志
crosscheck archivelog all;
delete expired archivelog all;
}
2、创建批处理任务(del_arhiverlog.bat)
rman cmdfile=c:dellog.txt
3、创建一个windows任务定时调用批处理任务
connect target sys/atmshis
run{
DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-2'; //删除两天前的归档日志
crosscheck archivelog all;
delete expired archivelog all;
}
2、创建批处理任务(del_arhiverlog.bat)
rman cmdfile=c:dellog.txt
3、创建一个windows任务定时调用批处理任务