#! bin/bash
ORACLE_SID="$1"
limit=$2

export $ORACLE_SID
fdir=/tmp/log
export $fdir

export ORACLE_HOME=`grep $ORACLE_SID: /etc/oratab |awk -F: '{print $2}'`
sqlplus -s "/ as sysdba" <<EOF >$fdir/fravalue
@$fdir/arclg_db.sql
EOF

fradest=`cat $fdir/fravalue |awk '{print $1}'`
spaceused=`cat $fdir/fravalue |awk '{print $2}'`

if [ $spaceused -gt $limit ]; then
  echo "time to delete archivelogs to free up space"
  find $fradest/$ORACLE_SID/archivelog -type f -maxdepth 2 -printf "%T@\t%p\n"|
     sort -k1,1n |
      cut -f2- |
       sed '$d' |
        rm -rf

 else
     echo "Not required to delete logs.. lots of space"
 fi