pvmehta.com

#!/bin/ksh a=`ps -ef|grep “move_arch_files.ksh”|grep -v grep|wc -l` if [ $a -gt 2 ] then echo “Exiting because of more than 1 Moving archive log script is running ” exit fi # ## Setting Environment information and variables # NODENAME=`hostname` ## change start ORACLE_SID=UAS LOG_FILE=/oracle/scripts/log/MOVE_UAS01.log ARCHMOUNTPOINT=/UASARCH DESTFOLDER=/uocdb7/archlog/UAS ### change end COMFORT_SPACE=75 NO_FILES_MOVED=0 NOTIFY_LIST=’dbaoracle@1800flowers.com’ cp /dev/null $LOG_FILE…

Read More “move_arch_files.ksh /* Good One */” »

echo “The script execution started at `date`” >> $LOG_FILE while [ ${ARCH_SPACE} -ge ${COMFORT_SPACE} ] do FIRST_FILE=`ls -latr $ARCHMOUNTPOINT/*.arc|head -1|awk ‘{print $9}’` # cp -p $FIRST_FILE /blprddb14/archlog/BLINK cp -p $FIRST_FILE $DESTFOLDER CURR_FILE_SZ=`ls -latr $FIRST_FILE|awk ‘{print $5}’` CURR_FL_NAME=`echo $FIRST_FILE |cut -f3 -d’/’` # COPIED_FILE_SZ=`ls -latr /blprddb14/archlog/BLINK/$CURR_FL_NAME |awk ‘{print $5}’` COPIED_FILE_SZ=`ls -latr $DESTFOLDER/$CURR_FL_NAME |awk ‘{print $5}’` if…

Read More “move_arch_files.ksh” »

#ARCH_SPACE=`df -k /UASARCH | tail -1 | awk ‘{print $5’} | sed ‘s/%//g’` ARCH_SPACE=`df -k $ARCHMOUNTPOINT | tail -1 | awk ‘{print $5’} | sed ‘s/%//g’`

COMFORT_SPACE=75 NO_FILES_MOVED=0 NOTIFY_LIST=’dbaoracle@1800flowers.com’ cp /dev/null $LOG_FILE

ORACLE_SID=UAS LOG_FILE=/oracle/scripts/log/MOVE_UAS01.log ARCHMOUNTPOINT=/UASARCH DESTFOLDER=/uocdb7/archlog/UAS

#!/bin/ksh a=`ps -ef|grep “move_arch_files.ksh”|grep -v grep|wc -l` if [ $a -gt 2 ] then echo “Exiting because of more than 1 Moving archive log script is running ” exit fi # ## Setting Environment information and variables # NODENAME=`hostname`