git.gag.com Git - debian/amanda/blob - contrib/dbbackup.ksh

   1 #!/bin/ksh
   2 #
   3 # Wrapper script to set environment and run dbbackup.tcl.
   4 #
   5
   6 #  user defined variables below
   7 adm=/var/backup
   8 mailuser=backup
   9 dbhomescript=/opt/oracle/bin/dbhome
  10
  11 export ORACLE_SID=cc
  12
  13 #  no need to change anything below here
  14 pgm=${0##*/}
  15
  16 if [[ ! -x ${adm}/dbbackup.tcl ]]
  17 then
  18         msg="${pgm}: cannot execute ${adm}/dbbackup.tcl"
  19         /usr/bin/mailx -s "${msg}" ${mailuser} < /dev/null
  20         print -u2 ${msg}
  21         exit 1
  22 fi
  23
  24 if [[ ! -x $dbhomescript ]]
  25 then
  26         msg="${pgm}: cannot execute $dbhomescript"
  27         /usr/bin/mailx -s "${msg}" ${mailuser} < /dev/null
  28         print -u2 ${msg}
  29         exit 1
  30 fi
  31
  32 timestamp=$(date "+%Y-%m-%d.%T")
  33 log=${adm}/dbbackup.log.${timestamp}
  34 err=${adm}/dbbackup.err.${timestamp}
  35 rm -f ${log} ${err}
  36
  37 find ${adm}/. -name "dbbackup.log.*" -mtime +30 -print | xargs rm -f
  38 find ${adm}/. -name "dbbackup.err.*" -mtime +30 -print | xargs rm -f
  39
  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
  43
  44 ( ${adm}/dbbackup.tcl 2>&1 || touch ${err} 2>&1 ) | tee $log
  45
  46 if [[ -f ${err} ]]
  47 then
  48         msg="${pgm}: dbbackup.tcl failed"
  49         /usr/bin/mailx -s "${msg}" ${mailuser} < ${log}
  50         print -u2 ${msg}
  51         exit 1
  52 fi
  53
  54 exit 0