Re: SQL Backtrack
2000-02-24 15:48:43
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
|
|
|