Re: Anyone have any good RMAN scripts (ksh)

From: John Higgins <JH33378_at_deere.com>
Date: Tue, 18 May 1999 14:56:48 -0500
Message-ID: <3741C600.179F122B@deere.com>

The following (hot backup) script uses Veritas NetBackup for media management. Adjust as needed for other media managers.

We have similar scripts for single data file backup, single tablespace backup, archive log backup and purge, full database point-in-time recovery, single data file recovery, single tablespace recovery.

#! /bin/ksh
. $HOME/rman_deere/set_locale.sh
if [[ $(ps -ef|grep -v grep|grep -c rcvcat) > 0 ]]  then
  print There is another backup running.   print
  print This backup cannot continue.
  exit
fi

###############################################################

cd $HOME/rman_deere
export RMAN_LOG=./log/b_hot_$(date +%Y%m%d_%H%M%S).log export JOB_TYPE="Full Hot"

######################################################

cat <<EOF > ./scripts/backup_hot_sched.scr run {
sql 'alter system checkpoint' ;
allocate channel dev1 type 'SBT_TAPE' ; setlimit channel dev1 kbytes 20000000 ; sql 'alter system checkpoint' ;
backup

     full
     tag hot_full
     filesperset 1
     format 'hot_%d_$(date +%H%M_%d%m)99_%s_%p'
     (database include current controlfile) ;

sql 'alter system archive log current'; backup

    filesperset 1
    format 'al_%d_$(date +%H%M_%d%m)99_%s_%p'     (archivelog until time 'SYSDATE' delete input ) ; release channel dev1 ;

    }

###############################################################

EOF
$CATALOG cmdfile=./scripts/backup_hot_sched.scr msglog=$RMAN_LOG

./mail_status.sh

---

The set_locale.sh script:

export ORACLE_HOME=/oracle/B00
export ORACLE_SID=B00
export ORACLE_DB=B00
export ORACLE_DOMAIN=world

export RMAN_DEERE=$ORACLE_HOME/rman_deere export
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/openv/netbackup/bin:/oracle/B00/rman_deere

export
SHLIB_PATH=$ORACLE_HOME/lib:/usr/openv/netbackup/bin:/oracle/B00/rman_deere

export LIBPATH=$ORACLE_HOME/lib:/usr/openv/netbackup/bin

export TNS_ADMIN=/oracle/B00/rman_deere/network/admin
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
export NLS_DATE_FORMAT='DD-MON-YYYY HH24:MI:SS'
export obackup_tape_SERV=netbackp-2

export obackup_tape_CLASS=obackup_normal_db export obackup_tape_SCHED=obackup_normal_db export
PATH=.:/usr/openv/netbackup/bin:$ORACLE_HOME/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:$ORACLE_HOME/rcvscripts

---

The mail_status.sh script:

if [[ $(grep -i -c "MESSAGE STACK" $RMAN_LOG) > 0 ]]   then

      mailx -s "$ORACLE_SID $JOB_TYPE Backup Failed" jh33378@______ <$RMAN_LOG

      export ERR_LINE="May not be due to Tape error"
      if [[ $(grep -i -c "ORA-19602" $RMAN_LOG) > 0 ]]
         then export ERR_LINE="Database is on NOARCHIVE MODE"
      fi
      if [[ $(grep -i -c "ORA-19502" $RMAN_LOG) > 0 ]]
         then export ERR_LINE="Tape Error - ORA-19502"
      fi
      if [[ $(grep -i -c "ORA-27017" $RMAN_LOG) > 0 ]]
         then export ERR_LINE="Tape Error - ORA-27017"
      fi
      if [[ $(grep -i -c "ORA-27015" $RMAN_LOG) > 0 ]]
          then export ERR_LINE="Tape Error - ORA-27015"
      fi
      if [[ $(grep -i -c "ORA-27007" $RMAN_LOG) > 0 ]]
          then export ERR_LINE="Tape Error - ORA-27007"
      fi

      echo "$ORACLE_SID         $(date +%d-%b-%Y-%H-%M-W%W)


$JOB_TYPE     $RMAN_LOG     Failed     $ERR_LINE"   >> ./log/backup.log



   else
      echo "$ORACLE_SID         $(date +%d-%b-%Y-%H-%M-W%W)


$JOB_TYPE     $RMAN_LOG    Successful" >> ./log/backup.log

 fi
 find $HOME/rman_deere/log -name "*.log" -mtime +40 -exec rm {} \;

---

HTH, John

hr784_at_cleveland.freenet.edu wrote:

> Does anyone have any RMAN korn shell scripts I could possible use as an
> example to starting my own backup schedule.  Any help is much
> appreciated.
>
> David Knollhoff
>
> --== Sent via Deja.com http://www.deja.com/ ==--
> ---Share what you know. Learn what you don't.---

Received on Tue May 18 1999 - 14:56:48 CDT