$ 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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment