ADSM-L

Re: SQL Backtrack

2000-02-24 15:48:43
Subject: Re: SQL Backtrack
From: Kenton Maguire <Kent_Maguire AT ALLIANZLIFE DOT COM>
Date: Thu, 24 Feb 2000 14:48:43 -0600
We've implemented a simple ksh script that is invoked by the ADSM scheduler.
The script calls the SQLBacktrack backup job, checks the return code, and takes
any appropriate actions (e-mail, page, etc ...).  Error output and job log data
is appended to the $ERR and $LOG variables for historical reference.  This
solution works well for us and took little time to implement.  Example:

su - dbuser "-c /usr/datatools/obacktrack/bin/dtobackup /oracle/datatools/oraca
t -database PROD -cold -shutdown -full -quiet -noprompt" >> $ERR
status=$?

echo "Backup completed with return code:$status on `newdate`." >> $LOG

  if [ $status -ne 0 ]
  then

Kenton
<Prev in Thread] Current Thread [Next in Thread>