#!/bin/ksh
# 
# Wrapper script to set environment and run dbbackup.tcl.
# 

#  user defined variables below
adm=/var/backup
mailuser=backup
dbhomescript=/opt/oracle/bin/dbhome

export ORACLE_SID=cc

#  no need to change anything below here
pgm=${0##*/}

if [[ ! -x ${adm}/dbbackup.tcl ]]
then
	msg="${pgm}: cannot execute ${adm}/dbbackup.tcl"
	/usr/bin/mailx -s "${msg}" ${mailuser} < /dev/null
	print -u2 ${msg}
	exit 1
fi

if [[ ! -x $dbhomescript ]]
then
	msg="${pgm}: cannot execute $dbhomescript"
	/usr/bin/mailx -s "${msg}" ${mailuser} < /dev/null
	print -u2 ${msg}
	exit 1
fi

timestamp=$(date "+%Y-%m-%d.%T")
log=${adm}/dbbackup.log.${timestamp}
err=${adm}/dbbackup.err.${timestamp}
rm -f ${log} ${err}

find ${adm}/. -name "dbbackup.log.*" -mtime +30 -print | xargs rm -f
find ${adm}/. -name "dbbackup.err.*" -mtime +30 -print | xargs rm -f

export ORACLE_HOME=$($dbhomescript "$ORACLE_SID")
export ORA_NLS=$ORACLE_HOME/ocommon/nls/admin/data
export LD_LIBRARY_PATH=$ORACLE_HOME/lib

( ${adm}/dbbackup.tcl 2>&1 || touch ${err} 2>&1 ) | tee $log

if [[ -f ${err} ]]
then
	msg="${pgm}: dbbackup.tcl failed"
	/usr/bin/mailx -s "${msg}" ${mailuser} < ${log}
	print -u2 ${msg}
	exit 1
fi

exit 0