日期:2014-05-16  浏览次数:20526 次

清理oracle10g日志----shell脚本定时任务执行rman
定时执行脚本:
cleanarclog.sh
#!/bin/bash

oracle_sid=mdspdb
oracle_home="/opt/oracle/product/11g/db"

ps -ef | grep oracle | grep -w "ora_lgwr_${oracle_sid}" >& /dev/null
if [ $? -ne 0 ]
then
    exit 0
fi
source $HOME/.bash_profile ## 必须有oracle的环境变量,否则会提示##Message file RMAN<lang>.msb not found
##Verify that ORACLE_HOME is set properly

##${oracle_home}/bin/rman 必须时全路径的否则,会报不认识RMAN这个命#令
${oracle_home}/bin/rman target / nocatalog << EOF
crosscheck archivelog all;
delete noprompt obsolete;
delete noprompt expired archivelog all;
EOF

定时任务:
* */3 * * * /opt/oracle/product/11g/db/bin/cleanarclog.sh