Oracle RMAN删除归档日志脚本

mkdir-p/home/oracle/scripts/logvi/home/oracle/scripts/del_arch.sh#!/bin/bashsource~/.bash_profileDAY_TAG=`date+"%Y-%m-%d"`rmantarget/nocatalogmsglog/home/oracle/scripts/log/del_arch_$DAY_TAG.log<<EOFcrosscheckarchivelogall;
deletenopromptarchiveloguntiltime'(sysdate-7)';
deletenopromptforcearchiveloguntiltime'SYSDATE-10';
EOF##写入crontabcrontab-e#0007***/home/oracle/scripts/del_arch.sh

@echooffsetORACLE_SID=orclset"filename=del_arch_task_log_%date:~0,4%%date:~5,2%%date:~8,2%.log"(
echo.
echo====================cleaning%date%%time%=========================echo.
rmantarget/cmdfile=G:\scripts\del_arch.sqlecho.
echo=====================finish%date%%time%=========================echo.
)>>G:\scripts\%filename%2>&1<nul

run{
crosscheckarchivelogall;
deletenopromptarchiveloguntiltime'sysdate-1/2';
deletenopromptforcearchiveloguntiltime'SYSDATE-1';
}