一、定时任务
crontab -e
编辑 每周6凌晨3点执行脚本
0 3 * * 6 . /home/oracle/scripts/arch_delete_before_60days_arch.sh
crontab -l
二、清楚日志脚本
su - oracle
vi /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