Cold backup script

1. Cold backup script:

BKUP_DATE=`date +%d%m%Y`
export BKUP_DATE

BKUP_LOG_FILE=/xx/log_backup_”$BKUP_DATE”.log
export BKUP_LOG_FILE

echo “##########STOPPING ORACLE SERVICES################” >> $BKUP_LOG_FILE
/xx/oraclectl.sh stop >> $BKUP_LOG_FILE
echo “##########DONE Stopping Oracle Services###########”  >> $BKUP_LOG_FILE
sleep 60
echo “##########COPYING DATABASE DIRECTORIES############”  >> $BKUP_LOG_FILE
/xx/backup_to_disk.sh
echo “##########DONE Copying Database Directories#######”  >> $BKUP_LOG_FILE
sleep 120
echo “##########STARTING ORACLE SERVICES################”  >> $BKUP_LOG_FILE7
/xx/oraclectl.sh start >> $BKUP_LOG_FILE
echo “##########DONE Starting Oracle Services###########”  >> $BKUP_LOG_FILE

echo “##########DELETE OLD BACKUP LOGS #################”  >> $BKUP_LOG_FILE
find . -name ‘log_backup*’ -mtime +3 -exec rm -f {} \;  >> $BKUP_LOG_FILE
echo “##########DONE Delete Old Backup Logs ############”  >> $BKUP_LOG_FILE

/bin/mail -s “Unitrans UDEV COLD BACKUP LOG  ” pavankumar077@gmail.com < $BKUP_LOG_FILE

As you can see we are using oraclectl.sh for can stop/start services.

The details of this sh is:

ORA_OWNER_DB=oradev
ORA_SID_DB=UDEV
ORA_HOSTNAME=uitapps.uispl
ORACLE_HOME/u04/dbbudget/db/tech_st/10.2.0

ORA_OWNER_APP=appldev
COMMON_TOP/u01/appsbudget/inst/apps/UDEV_uitapps

SID_HOST=UDEV_uitapps.uispl

case “$1″ in
‘start’) # Start the Oracle e-Business Suite Services
su – $ORA_OWNER_DB -c “$ORACLE_HOME/appsutil/scripts/$SID_HOST/addbctl.sh start”
su – $ORA_OWNER_DB -c “$ORACLE_HOME/appsutil/scripts/$SID_HOST/addlnctl.sh start $ORA_SID_DB”
su – $ORA_OWNER_APP -c “$COMMON_TOP/admin/scripts/$SID_HOST/adstrtal.sh apps/apps”
;;
‘stop’)  # Stop Oracle e-Business Suite Services
su – $ORA_OWNER_APP -c “$COMMON_TOP/admin/scripts/adstpall.sh apps/apps”
sleep 240
su – $ORA_OWNER_DB -c “$ORACLE_HOME/appsutil/scripts/$SID_HOST/addlnctl.sh stop $ORA_SID_DB”
su – $ORA_OWNER_DB -c “$ORACLE_HOME/appsutil/scripts/$SID_HOST/addbctl.sh stop immediate”
;;
esac

As you can see we are using backup_to_disk.sh for can copy process

#Delete first previous cold backup

#Start to copy process for cold backup

Cd  /u04

tar -cvpf - dbbudget 2> /u03/backup/dbbudget_`date +%d_%m_%Y`.log | gzip -c > /u03/backup/dbbudget_`date +%d_%m_%Y`.gz