essbase自动备份及邮件通知

1.编写shell脚本

#!/bin/bash 
### 设定当前时间参数 ######### 
datetime=`date +%Y_%m_%d-%H_%M_%S` 
#unset BKLOG
BKLOG=/apps/Oracle/backupzip/log/bkessbase_$datetime.log
/apps/Oracle/Middleware/user_projects/epmsystem1/bin/opmnctl status >> ${BKLOG};
# stop Essbase
echo " --- Begin Stop Essbase  --- " >> ${BKLOG}
### 停止服务 ###### 
###sh /home/EPM/Oracle/Middleware/user_projects/epmsystem1/bin/stop.sh; 
 /apps/Oracle/Middleware/user_projects/epmsystem1/bin/opmnctl stopall >> ${BKLOG};
echo " --- End Stop Essbase  --- " >> ${BKLOG}
date >> ${BKLOG}
sleep 5
# backup essbase files
echo " --- Begin Copy Essbase Files --- " >> ${BKLOG}
### 备份打包文档 #########
tar -czPf /apps/Oracle/backupzip/"$datetime"_MPLPLN.tar.gz  /apps/Oracle/Middleware/user_projects/epmsystem1/EssbaseServer/essbaseserver1/app/MPL_PLN >> ${BKLOG}
echo " --- End Copy Essbase Files --- "  >> ${BKLOG}
date >> ${BKLOG}
sleep 5
# start Essbase
echo " --- Begin Start Essbase  --- " >> ${BKLOG}
### 启动服务 ######### 
###sh /home/EPM/Oracle/Middleware/user_projects/epmsystem1/bin/start.sh
/apps/Oracle/Middleware/user_projects/epmsystem1/bin/opmnctl startall >> ${BKLOG};
date >> ${BKLOG}
echo " --- End Start Essbase  --- " >> ${BKLOG}
echo " --- Begin Purge old backup files and logfiles  --- " >> ${BKLOG}
### 删除改文件夹下超过30天的文件 #########
find /apps/Oracle/backupzip/ -mtime +30 -name "*.tar.gz" -exec rm -rf {} \; >> ${BKLOG}
/apps/Oracle/Middleware/user_projects/epmsystem1/bin/opmnctl status >> ${BKLOG};
#end
mail -v -s "epm cron log"_$datetime [e-mail] < ${BKLOG}

2.设置定时任务
crontab -e
30 19 */1 * * /home/EPM/Oracle/ESSBASE_Backup54.sh > /dev/null 2>&1

3.查看任务
/var/spool/cron

4.查看定时报错
/var/mail