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 mahone@qq.com < ${BKLOG}
2.设置定时任务
crontab -e
30 19 */1 * * /home/EPM/Oracle/ESSBASE_Backup54.sh > /dev/null 2>&1
3.查看任务
/var/spool/cron
4.查看定时报错
/var/mail
分享到:
相关推荐
essbase教程essbase教程essbase教程
essbase
本文介绍 Hyperion Essbase,描述其体系结构,并阐述它如何与 Oracle 的中间件和业务智能技术系列相适应。稍后,您将了解构建 Hyperion Essbase 多维数据库,然后将它连接到 Oracle 业务智能套件企业版,
Essbase培训教材,全方位了解Oracle Essbase多维数据库
Essbase财务分析操作 Financial Analytics with Essbase
Oracle Hyperion Essbase - Essbase介绍 - 培训资料 At the end of this lesson, you should be able to: Describe the Hyperion analytic solution List the key features of the Essbase products Describe the ...
windows环境下,ESSBASE11.1.1.3 版本安装及配置文档。
Hyperion Essbase用于企业绩效管理解决方案,为企业实现其内部的完整流程(制定战略方针、业务建模、规划、业绩监控、报表及分析)提供全面支持。 Hyperion的组件包括市场领先的OLAP引擎Hyperion Essbase以及相关的...
如何使用BIEE连接essbase.doc 如何使用BIEE连接essbase.doc 如何使用BIEE连接essbase.doc
ESSBASE资料!!!!!!
Essbase ORACLE olap刷新.pdf
Oracle BI ESSBASE,培训材料,Essbase Concept and Database Building
Hyperion Essbase用于企业绩效管理解决方案,为企业实现其内部的完整流程(制定战略方针、业务建模、规划、业绩监控、报表及分析)提供全面支持。这些解决方案可集成多个数据源中的数据,在整个企业内提供共同的视点...
Essbase9.2.1数据库管理员手册
H Y P ER I O N ® E S S B A S E ® – S Y S T E M 9
这个是essbase 7的英文文档,可以按照文档说明操作 essbase,它也支持essbase 9system
essbase官方中文联机丛书,版本:11.2。
Oracle ESSBASE是当今市面上领先的联机分析处理服务器(OLAP),利用它能够快速定制开发分析与企业绩效管理软件。
Essbase cube 设计指南;Essbase 性能及负载测试;利用结构化查询语言增强ESSBASE最佳实践.....
Essbase for java API :https://docs.oracle.com/cd/E40248_01/epm.1112/aps_java_api/index.html?help-doc.html