Simple backup archives script

rman: arc_INST_hostname.sh

#!/usr/bin/ksh
FECHA=$(date +"%d%m%y%H%M")
hostname=`hostname`
export ORACLE_HOME=/optware/oracle/11.2.0.4/db_1
export ORACLE_SID=ORAC256
export PATH=$ORACLE_HOME/bin:$PATH:.:$ORACLE_HOME/OPatch
export ruta=/optware/oracle/dbascripts/backups/logs
export rutafs=/u05/oradata/ORAC256/RMAN_BACKUP
rm -f ${rutafs}/*.arc
rm -f ${ruta}/ReportBKP_${ORACLE_SID}.log
find ${ruta}/*.log -mtime +40 -print | xargs rm -f
rman target / catalog rman11g/rman11g@oracrm11 log=${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log << EOF
run{
  allocate channel ${ORACLE_SID}1 device type disk format '${rutafs}/ARCH_%d_%U.arc' maxpiecesize 5000M;
  allocate channel ${ORACLE_SID}2 device type disk format '${rutafs}/ARCH_%d_%U.arc' maxpiecesize 5000M;
  allocate channel ${ORACLE_SID}3 device type disk format '${rutafs}/ARCH_%d_%U.arc' maxpiecesize 5000M;
  allocate channel ${ORACLE_SID}4 device type disk format '${rutafs}/ARCH_%d_%U.arc' maxpiecesize 5000M;
  allocate channel ${ORACLE_SID}5 device type disk format '${rutafs}/ARCH_%d_%U.arc' maxpiecesize 5000M;
  sql "alter system archive log current";
  backup as compressed backupset archivelog all current controlfile for standby;
  delete noprompt archivelog  until time 'sysdate - 1';
  release channel ${ORACLE_SID}1;
  release channel ${ORACLE_SID}2;
  release channel ${ORACLE_SID}3;
  release channel ${ORACLE_SID}4;
  release channel ${ORACLE_SID}5;
}
exit;
EOF

  cat ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log |grep -e "RMAN-" -e "ORA-"  >> ${ruta}/ReportBKP_${ORACLE_SID}.log

if [ -s ${ruta}/ReportBKP_${ORACLE_SID}.log ]
then
  echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
  echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
  echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
  echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
  echo "The BACKUP log of DB ${ORACLE_SID} present errors..."  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
  echo "---------------------------------------------------" >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
  echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
  echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
  cat ${ruta}/ReportBKP_${ORACLE_SID}.log >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
  echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
  echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
  echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
  echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
  echo "PLEASE REVIEW ERRORS AND TRY AGAIN MANUALLY !!!!!"  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
  echo "-------------------------------------------------"  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
  echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
  echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
  cat ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log|mailx -s "BACKUP ARC FAILED IN $hostname BD ${ORACLE_SID} ! ! !" [email protected],[email protected],[email protected]
  else
    /usr/openv/netbackup/bin/bpbackup -p 47468_prd_ui1y_net_std_linux_su_crebm3400_grp_2a1 -S crebm3400 -s 1m_ui -w 0 -L ${ruta}/bcktape_${ORACLE_SID}_${FECHA}.log ${rutafs}
    echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
    echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
    echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
    echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
    echo "BACKUP TO TAPE ..."  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
    echo "---------------------" >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
    echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
    echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
    cat ${ruta}/bcktape_${ORACLE_SID}_${FECHA}.log >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
    echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
    echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
    cat ${ruta}/bcktape_${ORACLE_SID}_${FECHA}.log |grep -e "error" -e "cannot" >> ${ruta}/ReportBKP_${ORACLE_SID}.log
    if [ -s ${ruta}/ReportBKP_${ORACLE_SID}.log ]
    then
      echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
      echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
      echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
      echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
      echo "The BACKUP log of DB ${ORACLE_SID} present errors..."  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
      echo "---------------------------------------------------" >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
      echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
      echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
      cat ${ruta}/ReportBKP_${ORACLE_SID}.log >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
      echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
      echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
      echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
      echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
      echo "PLEASE REVIEW ERRORS AND TRY AGAIN MANUALLY !!!!!"  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
      echo "-------------------------------------------------"  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
      echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
      echo ""  >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
      cat ${ruta}/ReportBKP_${ORACLE_SID}.log >> ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log
      cat ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log|mailx -s "BACKUP ARC FAILED IN $hostname BD ${ORACLE_SID} ! ! !" [email protected],[email protected],[email protected]
    else
cat ${ruta}/ARCH_${ORACLE_SID}_${FECHA}.log|mailx -s "BACKUP ARC SUCCESSFUL IN $hostname BD ${ORACLE_SID} " [email protected],[email protected],[email protected]
fi
fi