Member Avatar for mully
mully 0 Newbie Poster

hope someone can help...

I am trying to run a script via cron. the script runs fine interactively when logged in as oracle user. The script should run a hot back up of the database(oracle, RHEL3) of course the oracle sid and home path are set when running it manually. but when i run it as a cron job, it fails with error: egrep -c -e "^$ORACLE_SID:" $ORATAB
++ egrep -c -e '^:'
+ ''
+ echo 'ERROR:Database not in Oratab File '
/var/opt/mpower/bin/resback.sh: line 537: ${ERROR_FILE}: ambiguous redirect
+ exit

there is an entry in /etc/oratab for the db in question. I have also tried to run the .bash_profile in the script to supply the variables, i also tried to set them as cinstants in the script but no joy either.

i know its a big ask, but i have attached the script i am running it reads from the HOT BACKUP section of the script.

cheers

#!/bin/sh

 #date       03/12/1998
#purpose
#            This script has been written to backup a database either in online
#            or offline mode 
#                              $1   
#            Usage= resback.sh HOT SER
set -vx

TERM=linux
export TERM

/home/oratest/.bash_profile

#set ORACLE_SID=MKPEUR
#set ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1


################################################################
##                   Saves File                     ##
################################################################

#####################
# Force log switch  #
#####################
switch_logs()
{
        echo "Forcing logfile switch "
        sqlplus -s $USERNAME/$PASSWD << EOF
        alter system switch logfile;
EOF
}

################################################################
##                   COLD DATABASE BACKUP                     ##
################################################################
COLD_BK()
{

        echo "COLD BACKUP METHOD CHOSEN"

##  Shutdown database
 
        $MP_TOP/bin/stop10g.sh

 
##  Make sure database is not running

        sqlplus -s $USERNAME/$PASSWD > $MP_BACK/login$ORACLE_SID.orbk << EOF
EOF


        if [ `grep -c ORA-01034 $MP_BACK/login$ORACLE_SID.orbk` -ne 1 ]
        then
                echo "ERROR Database is still running BACKUP TERMINATED"
                exit 1
        fi


########################################################
# Startup Database in RESTRICTED session mode
########################################################
        sqlplus '/ as sysdba' << EOF
        startup
        alter system enable restricted session;
        exit
EOF 

########################################################
# determine the datafiles associated with the database # 
########################################################

        sqlplus -s $USERNAME/$PASSWD  > $MP_BACK/dblist$ORACLE_SID.orbk <<EOF
        set pagesize 0
        set linesize 2048
        set heading off
        set feedback off
        select file_name from dba_data_files ;
        exit
EOF

########################################################     
# determine the redo, &  control file locations        #
########################################################

        sqlplus -s $USERNAME/$PASSWD  > $MP_BACK/redoctl$ORACLE_SID.orbk  << EOF
        set pagesize 0
        set linesize 2048
        set heading off
        set feedback off
        select member from v\$logfile;
        select name from v\$controlfile;
        exit
EOF

#############################################################
# Check for ORACLE ERROR getting the list of database files #
#############################################################
#
        if [ `egrep -c ORA- $MP_BACK/dblist$ORACLE_SID.orbk` -ne 0 ]
        then
                echo " Warning: Aborting SQLPlus error" | tee -a ${ERROR_FILE}
                echo "" >>${ERROR_FILE}
                sed -e 's/ [ ]*$//' $MP_BACK/dblist$ORACLE_SID.orbk >>${ERROR_FILE}
                exit 1
        else
                echo "                                            "
                echo "Successfully got the list of database files "
                echo "                                            "
        fi

############################################################
#  Check for errors getting the redo and Control Files    #
############################################################

        if [ `egrep -c ORA- $MP_BACK/redoctl$ORACLE_SID.orbk` -ne 0 ]
        then
                echo " Warning: Aborting SQLPlus error" | tee -a ${ERROR_FILE}
                echo "" >>${ERROR_FILE}
                sed -e 's/ [ ]*$//' $MP_BACK/redoctl$ORACLE_SID.orbk >>${ERROR_FILE}
                exit 1
        else
                echo "                                            "
                echo "Successfully got the name of redo and control files " 
                echo "                                            "
        fi

########################################################
#  SHUTDOWN THE DATABASE   #
########################################################
#

        sqlplus '/ as sysdba' << EOF
        shutdown immediate
        exit
EOF


###############################################
# Read each line in dblist and redoctl and SAVE           #
###############################################
        cat $MP_BACK/dblist$ORACLE_SID.orbk $MP_BACK/redoctl${ORACLE_SID}.orbk | while read DBFILE
        do

           ZIPNAME=`basename $DBFILE`
           export ZIPNAME
           $ZIP $DBFILE > $RECOVER_DIR$ZIPNAME.gz
           echo "file has been GZIPPED to $RECOVER_DIR$ZIPNAME.gz"

        done

    
#
#####################################################
# Copy the init$ORACLE_SID.ora to the backup area   #
#####################################################
#
        cp /u01/app/oracle/product/10.2.0/db_1/admin/$ORACLE_SID/pfile/config${ORACLE_SID}.ora $RECOVER_DIR 

        cp /u01/app/oracle/product/10.2.0/db_1/admin/$ORACLE_SID/pfile/init${ORACLE_SID}.ora $RECOVER_DIR 
                




########################################################
# Restart the database- added by Mark Mulhern 17/9/2007#
########################################################
#
	/var/opt/mpower/bin/start10g.sh

}

################################################################
##                   HOT DATABASE BACKUP                      ##
################################################################



HOT_BK()
{


        echo "HOT BACKUP METHOD CHOSEN"


#ORACLE_SID=MKPEUR
#ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1

#echo $ORACLE_SID
#echo $ORACLE_HOME


 
##  Make sure database is running

        sqlplus -s $USERNAME/$PASSWD > $MP_BACK/login$ORACLE_SID.orbk << EOF
EOF


        if [ `grep -c ORA-01034 $MP_BACK/login$ORACLE_SID.orbk` -ne 0 ]
        then
                echo "ERROR Database is not running BACKUP TERMINATED"
                exit 1
        fi

##################################
# Get Current Log Sequence Number#
#################################

        echo "Getting Starting Log Sequence Number "
        sqlplus -s $USERNAME/$PASSWD > $MP_BACK/begseq$ORACLE_SID.orbk << EOF
        set pagesize 0
        set linesize 2048
        set heading off
        set feedback off
        select sequence# from v\$log where status ='CURRENT';
   exit
EOF

        if [ `egrep -c ORA- $MP_BACK/begseq$ORACLE_SID.orbk` -ne 0 ]
        then
                echo " Warning: Aborting SQLPlus error" | tee -a ${ERROR_FILE}
                echo "" >>${ERROR_FILE}
                sed -e 's/ [ ]*$//' $MP_BACK/begseq$ORACLE_SID.orbk >>${ERROR_FILE}
                exit 1
        else
                echo "                                                " 
                echo "Successfully got Starting log sequence number   "
                echo "                                                "
        fi


        switch_logs

#################################
# Get a list of all tablespaces #
#################################

        sqlplus -s $USERNAME/$PASSWD  > $MP_BACK/tslist$ORACLE_SID.orbk  << EOF
        set pagesize 0
        set linesize 2048
        set heading off
        set feedback off
        select tablespace_name from dba_tablespaces where tablespace_name <> 'TEMP';
	exit
EOF

##########################################################
# Check for ORACLE ERRORS getting the tablespace listing #
##########################################################

        if [ `egrep -c ORA- $MP_BACK/tslist$ORACLE_SID.orbk` -ne 0 ]
        then
                echo " Warning: Aborting SQLPlus error" | tee -a ${ERROR_FILE}
                echo "" >>${ERROR_FILE}
                sed -e 's/ [ ]*$//' $MP_BACK/tslist$ORACLE_SID.orbk >>${ERROR_FILE}
                exit 1
        else 
                echo "Successfully got the list of Oracle tablespaces "
        fi

##########################################################################
# For each tablespace                                                    #
# alter the tablespace to begin backup                                   #
# copy the associated datafiles per tablespace to the backup location    #
# alter the tablespace to end backup                                     #
##########################################################################

        # this is used to trap errors in a cat | while loop so that it will exit
        # properly
        ERROR_TRAP_FILE=$MP_BACK/${ORACLE_SID}.error_trap
        export ERROR_TRAP_FILE
        rm -f $ERROR_TRAP_FILE

        cat $MP_BACK/tslist$ORACLE_SID.orbk | while read TABLESPACE
        do
                sqlplus -s $USERNAME/$PASSWD > $MP_BACK/mesg$ORACLE_SID.orbk  <<EOF
                set pagesize 0
                set linesize 2048
                set heading off
                set feedback off
                alter tablespace  $TABLESPACE  begin backup ;
                exit
EOF

###########################
# Check for ORACLE ERRORS # 
###########################
 
                if [ `egrep -c ORA- $MP_BACK/mesg$ORACLE_SID.orbk` -ne 0 ]
                then
                        echo " Warning: SQLPlus error altering tablespace" | tee -a ${ERROR_FILE}
                        echo "" >>${ERROR_FILE}
                        sed -e 's/ [ ]*$//' $MP_BACK/mesg$ORACLE_SID.orbk >>${ERROR_FILE}

                        echo "Error" >> $ERROR_TRAP_FILE

                        exit 1
                else 
                        echo "alter tablespace $TABLESPACE begin backup "
                fi


##########################################################
# determine the datafiles associated with the tablespace # 
##########################################################

                sqlplus -s $USERNAME/$PASSWD  > $MP_BACK/dblist$ORACLE_SID.orbk <<EOF
                set pagesize 0
                set linesize 2048
                set heading off
                set feedback off
                select file_name from dba_data_files where tablespace_name = '$TABLESPACE';
                exit
EOF

#############################################################
# Check for ORACLE ERROR getting the list of database files #
######
  • 1 Contributor
  • 0 Replies
  • 61 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.