oracle 删除过期归档脚本

vi /bin/bash /home/oracle/scripts/arch_delete_before_60days_arch.sh

#!/bin/bash
# auther wangxp
# crontab--> su - oracle -c /home/oracle/scripts/arch_delete_before_60days_arch.sh

export LOG=/home/oracle/delete_archive.log
export DATE=`date "+%F %T"`

echo -e "\n--------------------------------- DATE: $DATE --------------------------------" >> $LOG
rman target / >>$LOG <<EOF
crosscheck archivelog all;
delete force noprompt archivelog all completed before 'sysdate - 60';
delete force noprompt expired archivelog all;
exit
EOF
echo "------------------------------------------ FINISHED ----------------------------------------" >> $LOG