Shell Programming and Scripting

#set -x
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1;export NLS_LANG
ORACLE_HOME=/u02/app/oracle/product/11g/db_1;export ORACLE_HOME
PATH=.:$ORACLE_HOME/bin:/usr/local/bin:${PATH};export PATH
ORADAY=`date +%w`;export ORADAY
ORADATE=`date +"%d%h"`;export ORADATE
ORATAB=/etc/oratab;export ORATAB
# ARCHIVE_DIR is the directory that Oracle put the archive log files into defined in init.ora (Source)
ARCHIVE_DIR=/u01/app/oracle/admin/orcl/arch/test;export ARCHIVE_DIR
# ARCHIVE_COPY_DIR is the name of the directory on the target machine 
ARCHIVE_COPY_DIR=/home/oracle/Test/arch;export ARCHIVE_COPY_DIR
# find most recent file on target machine
MOST_RECENT_COPIED_FILE=`ls -1t ${ARCHIVE_COPY_DIR}/or*.dbf | head -1`;export MOST_RECENT_COPIED_FILE
echo ==\> Most Recent File in ${ARCHIVE_COPY_DIR} is ${MOST_RECENT_COPIED_FILE} \<==
#get only the file name, no path name
MOST_RECENT_COPIED_FILE_1=`echo ${MOST_RECENT_COPIED_FILE} | awk -F_ '{print $3}' -`;export MOST_RECENT_COPIED_FILE_1
MOST_RECENT_COPIED_FILE_NAME=`echo ${MOST_RECENT_COPIED_FILE_1} | awk -F. '{print $1}' -`;export MOST_RECENT_COPIED_FILE_NAME
echo Most Recent Copied File Name ${MOST_RECENT_COPIED_FILE_NAME}
# get the most recent log file
ftp -nv 134.251.61.237 << EOF
user oracle oracle12
cd /u01/app/oracle/admin/orcl/arch/test
mls orcl*.dbf /home/oracle/Test/arch/slarch.lst
y
quit
EOF
MOST_CURRENT_FILE_1=`cat slarch.lst|tail -1`;export MOST_CURRENT_FILE_1
MOST_CURRENT_FILE_2=`echo ${MOST_CURRENT_FILE_1} | awk -F_ '{print $3}' -`;export MOST_CURRENT_FILE_2
MOST_CURRENT_FILE=`echo ${MOST_CURRENT_FILE_2} | awk -F. '{print $1}' -`;export MOST_CURRENT_FILE
# we are finding the difference of archives from source and target leaving the latest one from source.  And if the difference
# is greater than zero, then there are no archives to ftp from source
diff=`expr $MOST_CURRENT_FILE - $MOST_RECENT_COPIED_FILE_NAME - 1`;export diff
if [ $diff -gt 0 ]
then
archformat1=orcl_1_;export archformat1
archformat2=.dbf;export archformat2
rm /home/oracle/Test/arch/recent_files.lis
rm /home/oracle/Test/archftpmsg.log
for ((  i = 1 ;  i <= $diff;  i++  ))
do
MOST_RECENT_COPIED_FILE_NAME=` expr $MOST_RECENT_COPIED_FILE_NAME + 1`;export MOST_RECENT_COPIED_FILE_NAME
# making the list of files to be ftp'd 
echo $archformat1$MOST_RECENT_COPIED_FILE_NAME$archformat2 >> recent_files.lis
done
# reading from recent_files.lis and ftp'ing the archives one by one
cat /home/oracle/Test/arch/recent_files.lis | while read LINE
do
sleep 90
case $LINE in
\#*) ;;
*)
FILE_TO_SEND=`echo $LINE`;export FILE_TO_SEND
echo ==\> File to send is ${FILE_TO_SEND} \<==
echo sending $FILE_TO_SEND...
ftp -n -v -i 134.251.61.237  <<EOF
user oracle oracle12
bin
cd ${ARCHIVE_DIR}
pwd
lcd ${ARCHIVE_COPY_DIR}
get ${FILE_TO_SEND}
bye
EOF
echo finished sending $FILE_TO_SEND...
esac
done
else
echo "No files to ftp" > ftpmsg.log
fi