DBNAME=t012band DBIP=10.34.32.154 ORAUSR=oraprod VVNAME=PC_DB_UTGB_11G_154 VVNAME1=PC_DB_UTGB_11G_001_154 VVNAME2=PC_DB_UTGB_11G_002_154 VVNAME3=PC_DB_UTGB_11G_003_154 VVNAME4=PC_DB_UTGB_11G_004_154 VGNAME=vg_db_upgradtn_test LVNAME=/dev/vg_db_upgradtn_test/lvol1 MOUNTP=/oradata_t012band LUN=60 LUN1=61 LUN2=62 LUN3=276 LUN4=277 MINOR=0x690000 MEDIASERVER=DRRRBAP3 INFORMIP=10.44.0.20 INFORMUSR=3parbkp #BEGINBKP=/var/hp/BC/scripts/pugb/pugb_begin_bkp_mode_dbday #ENDBKP=/var/hp/BC/scripts/pugb/pugb_end_bkp_mode_dbday #REPLSTART=/var/hp/BC/scripts/pugb/pugb_repl_start #REPLSTOP=/var/hp/BC/scripts/pugb/pugb_repl_stop LOG=/var/hp3par/log/utgb/$DBNAME.log #echo "\n" >> $LOG #date "+START DATE : %d-%b-%Y%nSTART TIME : %H:%M:%S" >> $LOG #echo "\n" >> $LOG #echo "################# UTGB Backup Job Started ##########################" 2>&1 |sed -e "s/^/$(date) /" #echo "########################################################################################" >> $LOG #echo "################# UTGB Backup Job Started ##########################" 2>&1 |sed -e "s/^/$(date) /" >> $LOG #echo "########################################################################################" >> $LOG ##t=`ps -ef |grep pmon |grep $DBNAME` #if [ $? -eq 0 ];then # export TPE='' # until [ "$TPE" = "yes" ]; do # echo "$DBNAME Database is Up, Do You Want to shutdown it? : yes/no " # echo "$DBNAME Database is Up, Do You Want to shutdown it? : yes/no " >> $LOG # read TPE # echo "User Input For Database Shutdown ==> " $TPE >> $LOG # if [ "$TPE" = "yes" ]; then # export ORACLE_SID=$DBNAME # $ORACLE_HOME/bin/sqlplus '/ as sysdba'<> $LOG # echo "Which type of Backup it is ?: pre/post " # echo "Which type of Backup it is ?: pre/post " >> $LOG # read BKPTYPE # echo "User Input For Backup Type ==> " $BKPTYPE >> $LOG # if [ "$BKPTYPE" = "pre" ]; then # clear # echo " Stoping Replication of $DBNAME ." # sleep 1 #sudo su - unisph << eof #. /home/unisph/.profile #/usr/bin/ssh $DBIP $REPLSTOP #eof # echo " $DBNAME Replication Stoped. " # sleep 1 # elif [ "$BKPTYPE" = "post" ]; then # clear # echo " Starting Replication of $DBNAME " # sleep 1 #sudo su - unisph << eof #. /home/unisph/.profile #/usr/bin/ssh $DBIP $REPLSTART #eof # echo " $DBNAME Replication Started. " # sleep 1 # fi # done # #clear banner " UTGB BC " banner " STARTED " date sudo /usr/sbin/fuser -kuc $MOUNTP 2>&1 |sed -e "s/^/$(date) /" sudo /usr/sbin/fuser -kuc $MOUNTP 2>&1 |sed -e "s/^/$(date) /" sudo /usr/sbin/umount $MOUNTP 2>&1 |sed -e "s/^/$(date) /" sudo /usr/sbin/vgchange -a n $VGNAME 2>&1 |sed -e "s/^/$(date) /" sudo /usr/sbin/vgexport $VGNAME 2>&1 |sed -e "s/^/$(date) /" >> $LOG echo "######################### Removing Lun ###############################" 2>&1 |sed -e "s/^/$(date) /" echo "######################### Removing Lun ###############################" 2>&1 |sed -e "s/^/$(date) /" >> $LOG ssh $INFORMIP -l $INFORMUSR removevlun -f $VVNAME.ro.rw $LUN $MEDIASERVER 2>&1 |sed -e "s/^/$(date) /" ssh $INFORMIP -l $INFORMUSR removevlun -f $VVNAME1.ro.rw $LUN1 $MEDIASERVER 2>&1 |sed -e "s/^/$(date) /" ssh $INFORMIP -l $INFORMUSR removevlun -f $VVNAME2.ro.rw $LUN2 $MEDIASERVER 2>&1 |sed -e "s/^/$(date) /" ssh $INFORMIP -l $INFORMUSR removevlun -f $VVNAME3.ro.rw $LUN3 $MEDIASERVER 2>&1 |sed -e "s/^/$(date) /" ssh $INFORMIP -l $INFORMUSR removevlun -f $VVNAME4.ro.rw $LUN4 $MEDIASERVER 2>&1 |sed -e "s/^/$(date) /" sleep 10 echo "######################### Starting DB Begin Backup mode ###############################" 2>&1 |sed -e "s/^/$(date) /" echo "######################### Starting DB Begin Backup mode ###############################" 2>&1 |sed -e "s/^/$(date) /" >> $LOG #sudo su - unisph << eof #. /home/unisph/.profile #/usr/bin/ssh $DBIP $BEGINBKP #banner "BEGIN" #eof ###ssh $DBIP -l $ORAUSR $BEGINBKP 2>&1 |sed -e "s/^/$(date) /" echo "######################### Starting Resync Physical copy Volume ###############################" 2>&1 |sed -e "s/^/$(date) /" echo "######################### Starting Resync Physical copy Volume ###############################" 2>&1 |sed -e "s/^/$(date) /" >> $LOG TASK=`ssh $INFORMIP -l $INFORMUSR createvvcopy -pri high -r $VVNAME|awk '{print $10}'` TASK1=`ssh $INFORMIP -l $INFORMUSR createvvcopy -pri high -r $VVNAME1|awk '{print $10}'` TASK2=`ssh $INFORMIP -l $INFORMUSR createvvcopy -pri high -r $VVNAME2|awk '{print $10}'` TASK3=`ssh $INFORMIP -l $INFORMUSR createvvcopy -pri high -r $VVNAME3|awk '{print $10}'` TASK4=`ssh $INFORMIP -l $INFORMUSR createvvcopy -pri high -r $VVNAME4|awk '{print $10}'` sleep 5 echo "######################### Starting DB End Backup mode ###############################" 2>&1 |sed -e "s/^/$(date) /" echo "######################### Starting DB End Backup mode ###############################" 2>&1 |sed -e "s/^/$(date) /" >> $LOG #sudo su - unisph << eof #. /home/unisph/.profile #/usr/bin/ssh $DBIP $ENDBKP #banner "END" #eof ###ssh $DBIP -l $ORAUSR $ENDBKP 2>&1 |sed -e "s/^/$(date) /" while true do STATUS=`ssh $INFORMIP -l $INFORMUSR showtask -d $TASK |head -2 |tail -1|awk '{print $4}'` STATUS1=`ssh $INFORMIP -l $INFORMUSR showtask -d $TASK1 |head -2 |tail -1|awk '{print $4}'` STATUS2=`ssh $INFORMIP -l $INFORMUSR showtask -d $TASK2 |head -2 |tail -1|awk '{print $4}'` STATUS3=`ssh $INFORMIP -l $INFORMUSR showtask -d $TASK3 |head -2 |tail -1|awk '{print $4}'` STATUS4=`ssh $INFORMIP -l $INFORMUSR showtask -d $TASK4 |head -2 |tail -1|awk '{print $4}'` export STS=`ssh $INFORMIP -l $INFORMUSR showtask -d $TASK |tail -2|head -1|awk '{print $4}'` export STS1=`ssh $INFORMIP -l $INFORMUSR showtask -d $TASK1 |tail -2|head -1|awk '{print $4}'` export STS2=`ssh $INFORMIP -l $INFORMUSR showtask -d $TASK2 |tail -2|head -1|awk '{print $4}'` export STS3=`ssh $INFORMIP -l $INFORMUSR showtask -d $TASK3 |tail -2|head -1|awk '{print $4}'` export STS4=`ssh $INFORMIP -l $INFORMUSR showtask -d $TASK4 |tail -2|head -1|awk '{print $4}'` if [ "$STS" = "Update" ]||[ "$STS1" = "Update" ]||[ "$STS2" = "Update" ]||[ "$STS3" = "Update" ]||[ "$STS4" = "Update" ]; then export PER=`ssh $INFORMIP -l $INFORMUSR showtask -d $TASK |tail -2|head -1|awk '{print $9}'|cut -d "(" -f2 |cut -d ")" -f1` export PER1=`ssh $INFORMIP -l $INFORMUSR showtask -d $TASK |tail -2|head -1|awk '{print $9}'|cut -d "(" -f2 |cut -d "." -f1` export PER2=`ssh $INFORMIP -l $INFORMUSR showtask -d $TASK1 |tail -2|head -1|awk '{print $9}'|cut -d "(" -f2 |cut -d ")" -f1` export PER3=`ssh $INFORMIP -l $INFORMUSR showtask -d $TASK1 |tail -2|head -1|awk '{print $9}'|cut -d "(" -f2 |cut -d "." -f1` export PER4=`ssh $INFORMIP -l $INFORMUSR showtask -d $TASK2 |tail -2|head -1|awk '{print $9}'|cut -d "(" -f2 |cut -d "." -f1` export PER5=`ssh $INFORMIP -l $INFORMUSR showtask -d $TASK2 |tail -2|head -1|awk '{print $9}'|cut -d "(" -f2 |cut -d "." -f1` export PER6=`ssh $INFORMIP -l $INFORMUSR showtask -d $TASK3 |tail -2|head -1|awk '{print $9}'|cut -d "(" -f2 |cut -d "." -f1` export PER7=`ssh $INFORMIP -l $INFORMUSR showtask -d $TASK3 |tail -2|head -1|awk '{print $9}'|cut -d "(" -f2 |cut -d "." -f1` export PER8=`ssh $INFORMIP -l $INFORMUSR showtask -d $TASK4 |tail -2|head -1|awk '{print $9}'|cut -d "(" -f2 |cut -d "." -f1` export PER9=`ssh $INFORMIP -l $INFORMUSR showtask -d $TASK4 |tail -2|head -1|awk '{print $9}'|cut -d "(" -f2 |cut -d "." -f1` echo "Syncronization Completed upto : $PER1%" echo "Syncronization Completed upto : $PER3%" echo "Syncronization Completed upto : $PER5%" echo "Syncronization Completed upto : $PER7%" echo "Syncronization Completed upto : $PER9%" echo "Syncronization Completed upto : ${PER}" >> ${LOG} echo "Syncronization Completed upto : ${PER2}" >> ${LOG} echo "Syncronization Completed upto : ${PER4}" >> ${LOG} echo "Syncronization Completed upto : ${PER6}" >> ${LOG} echo "Syncronization Completed upto : ${PER8}" >> ${LOG} else echo "Syncronization Completed" echo "Syncronization Completed" >> ${LOG} fi ACT=`ssh $INFORMIP -l $INFORMUSR showtask -d $TASK |head -2 |tail -1|awk '{print $6}'` ACT1=`ssh $INFORMIP -l $INFORMUSR showtask -d $TASK1 |head -2 |tail -1|awk '{print $6}'` ACT2=`ssh $INFORMIP -l $INFORMUSR showtask -d $TASK2 |head -2 |tail -1|awk '{print $6}'` ACT3=`ssh $INFORMIP -l $INFORMUSR showtask -d $TASK3 |head -2 |tail -1|awk '{print $6}'` ACT4=`ssh $INFORMIP -l $INFORMUSR showtask -d $TASK4 |head -2 |tail -1|awk '{print $6}'` echo "Resync Task id:$TASK status is $STATUS and $ACT in sync" 2>&1 |sed -e "s/^/$(date) /" echo "Resync Task id:$TASK1 status is $STATUS1 and $ACT1 in sync" 2>&1 |sed -e "s/^/$(date) /" echo "Resync Task id:$TASK2 status is $STATUS2 and $ACT2 in sync" 2>&1 |sed -e "s/^/$(date) /" echo "Resync Task id:$TASK3 status is $STATUS3 and $ACT3 in sync" 2>&1 |sed -e "s/^/$(date) /" echo "Resync Task id:$TASK4 status is $STATUS4 and $ACT4 in sync" 2>&1 |sed -e "s/^/$(date) /" echo "Resync Task id:$TASK status is $STATUS and $ACT in sync" 2>&1 |sed -e "s/^/$(date) /" >> $LOG echo "Resync Task id:$TASK1 status is $STATUS1 and $ACT1 in sync" 2>&1 |sed -e "s/^/$(date) /" >> $LOG echo "Resync Task id:$TASK2 status is $STATUS2 and $ACT2 in sync" 2>&1 |sed -e "s/^/$(date) /" >> $LOG echo "Resync Task id:$TASK3 status is $STATUS3 and $ACT3 in sync" 2>&1 |sed -e "s/^/$(date) /" >> $LOG echo "Resync Task id:$TASK4 status is $STATUS4 and $ACT4 in sync" 2>&1 |sed -e "s/^/$(date) /" >> $LOG if [ "$STATUS" = "done" ] && [ "$STATUS1" = "done" ] && [ "$STATUS2" = "done" ] && [ "$STATUS3" = "done" ] && [ "$STATUS4" = "done" ]; then echo "Resync Completed" 2>&1 |sed -e "s/^/$(date) /" >> ${LOG} break fi sleep 10 done echo "######################### Updating Snap Volume ###############################" 2>&1 |sed -e "s/^/$(date) /" echo "######################### Updating Snap Volume ###############################" 2>&1 |sed -e "s/^/$(date) /" >> ${LOG} ssh $INFORMIP -l $INFORMUSR updatevv -f -ro $VVNAME.ro.rw 2>&1 |sed -e "s/^/$(date) /" ssh $INFORMIP -l $INFORMUSR updatevv -f -ro $VVNAME1.ro.rw 2>&1 |sed -e "s/^/$(date) /" ssh $INFORMIP -l $INFORMUSR updatevv -f -ro $VVNAME2.ro.rw 2>&1 |sed -e "s/^/$(date) /" ssh $INFORMIP -l $INFORMUSR updatevv -f -ro $VVNAME3.ro.rw 2>&1 |sed -e "s/^/$(date) /" ssh $INFORMIP -l $INFORMUSR updatevv -f -ro $VVNAME4.ro.rw 2>&1 |sed -e "s/^/$(date) /" sleep 5 ssh $INFORMIP -l $INFORMUSR createvlun $VVNAME.ro.rw $LUN $MEDIASERVER 2>&1 |sed -e "s/^/$(date) /" ssh $INFORMIP -l $INFORMUSR createvlun $VVNAME1.ro.rw $LUN1 $MEDIASERVER 2>&1 |sed -e "s/^/$(date) /" ssh $INFORMIP -l $INFORMUSR createvlun $VVNAME2.ro.rw $LUN2 $MEDIASERVER 2>&1 |sed -e "s/^/$(date) /" ssh $INFORMIP -l $INFORMUSR createvlun $VVNAME3.ro.rw $LUN3 $MEDIASERVER 2>&1 |sed -e "s/^/$(date) /" ssh $INFORMIP -l $INFORMUSR createvlun $VVNAME4.ro.rw $LUN4 $MEDIASERVER 2>&1 |sed -e "s/^/$(date) /" sleep 5 echo "######################### VG Import Started ###############################" 2>&1 |sed -e "s/^/$(date) /" echo "######################### VG Import Started ###############################" 2>&1 |sed -e "s/^/$(date) /" >> ${LOG} sudo /usr/bin/mkdir /dev/$VGNAME sudo /usr/sbin/mknod /dev/$VGNAME/group c 64 $MINOR sudo /usr/sbin/vgimport -s -v -m /etc/hp3par/map/$VGNAME.map $VGNAME 2>&1 |sed -e "s/^/$(date) /" sudo /usr/sbin/vgchange -c n $VGNAME 2>&1 |sed -e "s/^/$(date) /" sudo /usr/sbin/vgchange -a y $VGNAME 2>&1 |sed -e "s/^/$(date) /" sudo /usr/sbin/fsck $LVNAME 2>&1 |sed -e "s/^/$(date) /" sudo /usr/sbin/mount $LVNAME $MOUNTP 2>&1 |sed -e "s/^/$(date) /" sudo /usr/bin/chown -R oraprod:oinstall $MOUNTP echo "################# UTGB Backup Job Completed ##########################" 2>&1 |sed -e "s/^/$(date) /" echo "########################################################################################" >> ${LOG} echo "################# UTGB Backup Job Completed ##########################" 2>&1 |sed -e "s/^/$(date) /" >> ${LOG} echo "########################################################################################" >> ${LOG} #fi