topic Re: cold backup scripts in Operating System - HP-UX

cold backup scripts

reddy_6 — Sun, 22 May 2005 18:05:56 GMT

can anyone help me on backup scripts.
im attaching the cold backup script. this scriptis not working on hp system ..after taking the backu[p and while veryfying th e backup it is giving me error.

this script is working fine in sun systems.
i have chanegd the oratab file, /usr/contrib also..but its not working.
can any one help me pls

Re: cold backup scripts

Warren_9 — Sun, 22 May 2005 20:06:01 GMT

what is the error?

Re: cold backup scripts

reddy_6 — Tue, 24 May 2005 09:18:24 GMT

i am attaching the log file.

thanks

Re: cold backup scripts

renarios — Tue, 24 May 2005 09:36:01 GMT

Hi Reddy,

During an export, Oracle sometimes complains about questionable statistics (EXP-00091). This is my filter:

# Check for EXP warnings during export, skip EXP-00091 errors (questionable statistics)
if (( $(grep -v "EXP-00091" ${LOGFILE} |egrep -c ^"ORA-|EXP-" ) > 0 ))

You should edit row 231 from
STAT=`grep -c ^ORA- $LOGFILE`
to
STAT=`grep -v "EXP-00091" ${LOGFILE}|egrep -c ^"ORA-|EXP-"`

Please try that and give feedback.

Cheerio,

Renarios

Re: cold backup scripts

reddy_6 — Wed, 25 May 2005 23:43:32 GMT

hello

i tried by adding the script but its not working.

im not able to take Cold backup on Hp Box. im getting the error while verifying the tar.gz in the script. this script is working fine in Sun boxes.
im attaching the script and the log file ..could you please look into the script and give me the feedback.
if i remove the verify backup script from the block ...the script runs successfully..and im not able to unzip the tar.gz file.
#-----------------------#
# Verifying Backup #
#-----------------------#
ACTION="Verifying Backup"
echo "> `$TIME` $ACTION" | tee -a $LOGFILE

/usr/bin/ls -o `/usr/bin/cat $LSTFILE` >> $LOGFILE 2>&1
STAT=$?
check_error

$ZIP -l $OUTFILE >> $LOGFILE 2>&1
STAT=$?
check_error

echo "< `$TIME` Finished $ACTION" | tee -a $LOGFILE

***********************************************************************************
im attaching the shell script and the log file for ur reference.
oracle version - 8.1.7.0 on hp-ux 11.0 64bit.

thanks in advance