删除数据库归档文件脚本

archivelog_delete.sh

#oracle自动删除归档文件脚本

rman target /  <<EOF
#delete noprompt expired archivelog all;
delete noprompt archivelog until time 'sysdate-7';
exit;

EOF

delet_archive.sh

. /home/oracle/.bash_profile
LOGFILE=/opt/...rman_delete.log
RMAN=$ORACLE_HOME/bin/rman
WEEK=$((`date +%w`))
date=`date +%Y-%m-%d`
echo "----------------------------begin backup ----------------------------------" >> $LOGFILE
date >>$LOGFILE
sh /opt/.../archivelog_delete.sh   $RMAN $LOGFILE
date >>$LOGFILE
echo "---------------------------end backup ---------" >> $LOGFILE