[Oracle/백업/복구] Tape에 직접 Backup하는 Script

[정민이]

실무개발자를위한 실무교육 전문교육센터학원
www.oraclejava.co.kr에 오시면 보다 다양한 강좌를 보실 수 있습니다.

#!/bin/ksh

# -------------------------------------------------------------------------
# This is a shell script for making exports directly to tape with a label.
# This label contains the db name and timestamp.
#
# This script also verifies the tape's protection. If the tape is
# protected it will display an error message and ask for a new tape.
#
# Another function lists the tape's label and its contents (option show=y
# of export).
#
# This script also writes a history log with dbname and timestamp.
#
#                              Sergio Klimberg <sklimberg@hotmail.com>
# -------------------------------------------------------------------------

clear
echo '          ORACLE TAPE EXPORTS    '
echo '          -------------------    '
b=' '
while  [ "$b" != "end" ]
do
  echo
  echo "* Enter DB for backup or list / Type 'end' to finish"
  echo ' '
  read b
  if  [ "$b" = "end" ]
    then
      exit
  fi
  echo ' '
  echo "* Mount the tape and hit Enter or type 'list' / Type 'end' to finish"
  echo ' '
  echo '  - Warning , Verify tape is not protected for backup '
  echo '  - If are you going to list the result will appear on screeen and into /tmp/list.txt'
  echo '  '
  read a
  echo '  '
  read a
  if  [ "$a" = "end" ]
    then
      exit
  fi

  mt -t /dev/rmt/0m rew
#
  if  [ "$a" = "list" ]
    then
      echo
      echo "<= Export's Header =>"
      tar tf /dev/rmt/0mn
      echo " "
      echo "* Hit Enter for show the export's remainder / Type 'end' to finish"
      echo ' '
      read c
      if  [ "$c" = "end" ]
      then
          exit
      fi
      echo 'file=/dev/rmt/0m ' >list.imp
      echo 'log=/tmp/list.txt' >>list.imp
      echo 'show=y' >>list.imp
      echo 'volsize=4000M' >>list.imp
      echo 'full=y ' >>list.imp
      echo 'back/xxxxxx@'$b >>list.imp
      imp parfile=list.imp 2>&1
      echo
      echo "Type 'end' to finish "
      read d
      exit
  fi

  HORA="`date '+%d-%m-%y %H:%M:%S'`"
  DESC_EXPORT="EXPORT $b $HORA"
  touch "$DESC_EXPORT"
  tar cvf /dev/rmt/0mn "$DESC_EXPORT" 2>/dev/null
  RTA=$?
  while [ $RTA != 0 ]
  do
      echo "Tape protected , Hit ENTER when it's ready  / Type 'end' to finish"
      read RTA1
      if  [ "$RTA1" = "end" ]
        then
        exit
      fi
      tar cvf /dev/rmt/0mn "$DESC_EXPORT" 2>/dev/null
      RTA=$?
  done

  TIME_START="`date '+%d/%m/%y %H:%M:%S'`"

  echo 'back/xxxxxx@'$b >PARAMETERS.EXP
  echo 'file=/dev/rmt/0m ' >>PARAMETERS.EXP
  echo 'log=export.log' >>PARAMETERS.EXP
  echo 'volsize=4000M' >>PARAMETERS.EXP
  echo 'full=y  ' >>PARAMETERS.EXP
  echo '  '  >>all_export.log
  echo 'EXPORT OF : '$b >>all_export.log
  echo 'START : ' $TIME_START >>all_export.log
  echo '  '  >>all_export.log
  exp parfile=PARAMETERS.EXP 2>&1 | tee -a all_export.log
  echo '  '  >>all_export.log
  TIME_END="`date '+%d/%m/%y %H:%M:%S'`"
  echo 'END : ' $TIME_END >>all_export.log
  echo "$TIME_START | $TIME_END | $b ">>export_resumen.log
  echo ' '

  echo "$TIME_START | $TIME_END | $b ">>export_resumen.log
  echo ' '
  echo Export $b end OK
done