Shell Programming and Scripting

 
#this shell will loadd all the LOG files data in oracle
# The below line will copy the logs to respective forlder so tha ETL will read the LOGS from there.
  NEWDIR=RIO_16-Oct-2012
        cd /ersdg3/ERS/ERS_INPUT_LOGS/RIO/LOGS/
 if [ -d $NEWDIR ]; then
         echo "Directory exis $NEWDIR"
 else
          mkdir /ersdg3/ERS/ERS_INPUT_LOGS/RIO/LOGS/$NEWDIR
 fi
 cd /ersdg3/ERS/ERS_INPUT_LOGS/RIO/rio_archive/$NEWDIR/
 #touch -t `date +%Y%m%d0000` dummy
 #find . -newer dummy -type f  |
 while read fname
 do
     mv $fname /ersdg3/ERS/ERS_INPUT_LOGS/RIO/LOGS/$NEWDIR
 done
 cd /ersdg3/ERS/ERS_INPUT_LOGS/RIO/LOGS/$NEWDIR
 for i in *.LOG
 do
 wc -l $i | awk '{ print $1"|"$2"|RIO" }'
 done>RIO_AUDIT_REC.TXT

while read fname
do
     mv $fname /ersdg3/ERS/ERS_INPUT_LOGS/RIO/LOGS/$NEWDIR
done < input_file

while read fname
 do
     mv $fname /ersdg3/ERS/ERS_INPUT_LOGS/RIO/LOGS/$NEWDIR
 done<RIO_AUDIT_REC.TXT

 for i in *.LOG
 do
 wc -l $i | awk '{ print $1"|"$2"|RIO" }'
 done