Monday, October 17, 2016

MaxL Script to Automate ESSBASE Backup

$ cat backupessbase.sh #!/bin/sh #######Essbase Application and Bin folder Backup ################# #######Author Mohammed Ashraf TP ################# #######Creation Date 22 September 2016 ################# #######This script is to Automate the following ################# #######Automate the backup of app and bin folder ################# #######Backup the essbase database using Maxl script ################# export DATE=`date '+%d%b%y'` mkdir -p /TapeBackup/essbasePRODbackup/essbase_backup_`date "+%Y%m%d%H"` cp -r /phyp01/essbase/Oracle/Middleware/user_projects/epmsystem1/EssbaseServer/essbaseserver1/bin /TapeBackup/essbasePRODbackup/essbase_backup_`date "+%Y%m%d%H"` cp -r /phyp01/essbase/Oracle/Middleware/user_projects/epmsystem1/EssbaseServer/essbaseserver1/app /TapeBackup/essbasePRODbackup/essbase_backup_`date "+%Y%m%d%H"` /phyp01/essbase/Oracle/Middleware/user_projects/epmsystem1/EssbaseServer/essbaseserver1/bin/startMaxl.sh -u hyp_admin -p welcome123 -s mof-pessdb01.mof.local tp.msh cp /tmp/Maxl_bkp.txt /TapeBackup/essbasePRODbackup/essbase_backup_`date "+%Y%m%d%H"`/ ================================================================================ $ cat tp.msh export database QGFMIS.MainBud Level0 data to data_file "/tmp/Maxl_bkp.txt"; =========================================================================== $ cat obsolete_essbase_backup.sh find /TapeBackup/essbasePRODbackup/* -type d -ctime +3 -exec rm -rf {} \; ======================================================= $crontab -l 1 2 * * * /phyp01/essbase/Oracle/Middleware/user_projects/epmsystem1/EssbaseServer/essbaseserver1/bin/obsolete_essbase_backup.sh >/dev/null 2>&1 1 * * * * /phyp01/essbase/Oracle/Middleware/user_projects/epmsystem1/EssbaseServer/essbaseserver1/bin/backupessbase.sh >/dev/null 2>&1

No comments:

Post a Comment