sample rman_del.ksh file

#!/bin/ksh

##
## script name : rman_del.ksh
## Author : Ramakrishna Nemani
## This script deletes obsolete backups
## for the specified ORACLE_SID
##
. ~/.profile
. /apps/oracle/admin/rman/rmanids.sh

##
## Make sure ORACLE_SID is passed as an argument
##

if (( $# < 1 ))
then
echo
echo Error Missing Arguement, Please supply Oracle Sid
echo
echo Usage: $0 ORACLE_SID
echo
exit
fi

export ORACLE_SID=$1

LOG_DIR="/apps/oracle/admin/rman"
LOCKFILE="${LOG_DIR}/$ORACLE_SID.lock"
EMAIL_INFO_FILE="${LOG_DIR}/${ORACLE_SID}_email.cfg"
SENDER="rman@`hostname"
CURR_DATE=`date +"%Y%m%d_%H%M%S"`
##
## using two seperate files instead of one for keeping the logs
## The LOGFILE will have log from just the latest run
## The LOGARCFILE will have the cumulative log
##

## LOGFILE="${LOG_DIR}/rman_del_$CURR_DATE.log"

LOGFILE="${LOG_DIR}/rman_del.$ORACLE_SID.log"
LOGARCFILE="${LOG_DIR}/rman_del.$ORACLE_SID.log.arc"

##
## using two seperate files instead of one for keeping the errors
## The EMAILFILE will have errors if any from just the latest run
## The EMAILARCFILE will have the cumulative errors
##

EMAILFILE="${LOG_DIR}/rman_del.$ORACLE_SID.email"
EMAILARCFILE="${LOG_DIR}/rman_del.$ORACLE_SID.email.arc"

##
## Make sure no other rman process is running for this ORACLE_SID
##

echo --------------------------------------------------------- > $LOGFILE
date >> $LOGFILE
echo ---------------- rman_del.ksh started ------------------ >> $LOGFILE

while [ 1 ]
do

if [  -e  $LOCKFILE ]
then

##
## Some rman process is running. Check again after 3 minutes
##
echo "$LOCKFILE exists. Will check again after 3 minutes" >> $LOGFILE
echo  >> $LOGFILE
sleep 180

else

##
## No rman process is running. Create a lock file
##

echo Do not remove this file. This is a lock file for $ORACLE_SID > $LOCKFILE
break
fi

done

rman <<EOF   >> $LOGFILE
connect target ${rmanid}/${rmanpw} ;

CONFIGURE DEVICE TYPE sbt PARALLELISM 4 ;
CONFIGURE CHANNEL DEVICE TYPE sbt
PARMS 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'
FORMAT '%u_%p_%c' ;

SHOW ALL ;
DELETE NOPROMPT OBSOLETE;

CONFIGURE DEVICE TYPE sbt clear ;
CONFIGURE CHANNEL DEVICE TYPE sbt clear ;
REPORT SCHEMA ;

EXIT ;

EOF

rmanstatus=$?

if (( $rmanstatus > 0 ))
then
if [ ! -e  $EMAIL_INFO_FILE ]
then
echo "To:rnemani@na.cokecce.com" > $EMAIL_INFO_FILE
fi

cat $EMAIL_INFO_FILE > $EMAILFILE
echo "Subject: The $0 script failed in the backup step for $ORACLE_SID !!!" >> $EMAILFILE

echo >> $EMAILFILE
date >> $EMAILFILE
echo  "rman error!!! ..." >> $EMAILFILE
echo  "Not removed the lock file : $LOCKFILE " >> $EMAILFILE
echo  "Please fix the error and remove the lock file" >> $EMAILFILE
echo  "before re-running the script again!!!" >> $EMAILFILE
echo >> $EMAILFILE

grep -i 'RMAN-'  $LOGFILE >> $EMAILFILE
grep -i 'ORA-'   $LOGFILE >> $EMAILFILE
grep -i 'sbt'    $LOGFILE >> $EMAILFILE
grep -i 'tsm'    $LOGFILE >> $EMAILFILE

sendmail -F "$SENDER" -t < $EMAILFILE

cat $EMAILFILE >> $EMAILARCFILE

exit 12
fi
##
## sync up the rman catalog
##
rman << EOF >> $LOGFILE
CONNECT TARGET ${rmanid}/${rmanpw} ;
CONNECT CATALOG ${catlid}/${catlpw}@${ORACLE_CATL} ;
RESYNC CATALOG;
EOF

rmanstatus=$?

if (( $rmanstatus > 0 ))
then
if [ ! -e  $EMAIL_INFO_FILE ]
then
echo "To:rnemani@na.cokecce.com" > $EMAIL_INFO_FILE
fi

cat $EMAIL_INFO_FILE > $EMAILFILE
echo "Subject: The $0 script failed in the resync step for $ORACLE_SID !!!" >> $EMAILFILE

echo >> $EMAILFILE
date >> $EMAILFILE
echo  "rman error!!! ..." >> $EMAILFILE
echo  "Not removed the lock file : $LOCKFILE " >> $EMAILFILE
echo  "Please fix the error and remove the lock file" >> $EMAILFILE
echo  "before re-running the script again!!!" >> $EMAILFILE
echo >> $EMAILFILE

grep -i 'RMAN-'  $LOGFILE >> $EMAILFILE
grep -i 'ORA-'   $LOGFILE >> $EMAILFILE
grep -i 'sbt'    $LOGFILE >> $EMAILFILE
grep -i 'tsm'    $LOGFILE >> $EMAILFILE

sendmail -F "$SENDER" -t < $EMAILFILE

cat $EMAILFILE >> $EMAILARCFILE

exit 12
fi

echo -------------------------------------------------------------- >> $LOGFILE
date >> $LOGFILE
echo ---------------- rman_del.ksh completed ---------------- >> $LOGFILE
echo >> $LOGFILE

cat $EMAIL_INFO_FILE > $EMAILFILE
echo "Subject: The $0 script completed successfully for $ORACLE_SID !!!" >> $EMAILFILE
cat $LOGFILE >> $EMAILFILE

sendmail -F "$SENDER" -t < $EMAILFILE

cat $EMAILFILE >> $EMAILARCFILE

cat $LOGFILE >> $LOGARCFILE

##
## Remove lock file to allow other rman processs for
## this ORACLE_SID to run
##

rm $LOCKFILE

## ---------------------------------------------------------------------
## End of  rman_del.ksh
## ---------------------------------------------------------------------