3 # Wrapper script to set environment and run dbbackup.tcl.
6 # user defined variables below
9 dbhomescript=/opt/oracle/bin/dbhome
13 # no need to change anything below here
16 if [[ ! -x ${adm}/dbbackup.tcl ]]
18 msg="${pgm}: cannot execute ${adm}/dbbackup.tcl"
19 /usr/bin/mailx -s "${msg}" ${mailuser} < /dev/null
24 if [[ ! -x $dbhomescript ]]
26 msg="${pgm}: cannot execute $dbhomescript"
27 /usr/bin/mailx -s "${msg}" ${mailuser} < /dev/null
32 timestamp=$(date "+%Y-%m-%d.%T")
33 log=${adm}/dbbackup.log.${timestamp}
34 err=${adm}/dbbackup.err.${timestamp}
37 find ${adm}/. -name "dbbackup.log.*" -mtime +30 -print | xargs rm -f
38 find ${adm}/. -name "dbbackup.err.*" -mtime +30 -print | xargs rm -f
40 export ORACLE_HOME=$($dbhomescript "$ORACLE_SID")
41 export ORA_NLS=$ORACLE_HOME/ocommon/nls/admin/data
42 export LD_LIBRARY_PATH=$ORACLE_HOME/lib
44 ( ${adm}/dbbackup.tcl 2>&1 || touch ${err} 2>&1 ) | tee $log
48 msg="${pgm}: dbbackup.tcl failed"
49 /usr/bin/mailx -s "${msg}" ${mailuser} < ${log}