1748209 Members
2796 Online
108759 Solutions
New Discussion юеВ

Re: cold backup scripts

 
reddy_6
New Member

cold backup scripts

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
4 REPLIES 4
Warren_9
Honored Contributor

Re: cold backup scripts

what is the error?
reddy_6
New Member

Re: cold backup scripts

i am attaching the log file.

thanks
renarios
Trusted Contributor

Re: cold backup scripts

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
Nothing is more successfull as failure
reddy_6
New Member

Re: cold backup scripts

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