BACKUP ORACLE DATABASE WITH RMAN AND NETAPP PLUGIN

It is possible to do a full online backup in less than one minute, no matter how big the dabase size is.

Especially with Oracle Standard Edition or Standard Edition One there is no parallel backup possible. For these environments it is possible to reduce the backup window.

In the Netapp community there is an Oracle Netapp Plugin

Following these instructions, we`ve implemented a new backup concept based on this plugin.

There is an important directory and variable: „BACKUP_DIR“.

In this directory the Netapp-Plugin stores its Backup-Catalog and there also lies the config-file:

rman_ntap.conf

FILER=172.27.9.21:oracle/xxxxxxxxxxxxxxxxxxxxxxx
FILERPASS_ENCRYPTED=YES
VOLUMES=172.27.9.21:xcb_vftest_ora
PROTOCOL=nfs
DB_MOUNTPOINT=172.27.9.21:xcb_vftest_ora:/oracle/oradata

In the backup script, we export 2 extra variables for the Netapp-Plugin:

rman_db_full_on­line_backup.sh

#!/bin/sh

################################
# RMAN-Backup-Skript
#
# written by Harald Hackenberger
# harald.hackenberger@ontec.at
#
################################

# Usage Check
#############

if test "$1" == "" ; then
        echo $'\a'Es muss die ORACLE_SID mitgegeben werden
        echo z.B.: $0 TEST
        exit
fi
echo ORACLE_SID=$1

# Set Environment
#################

export PATH=$PATH:/usr/local/bin
export ORACLE_SID=$1
export ORAENV_ASK=NO
export WORKING_DIR=/home/oracle/work/rman_scripts
export LOG_DIR=$WORKING_DIR/logs
export NLS_DATE_FORMAT=HH24:MI:SS_DD.MM.YYYY
export MDATE=`date +%d-%m-%Y`
export BACKUP_DIR=/oracle/product/11204/admin/rman_ntap         <---------
export CONF=rman_ntap.conf                             <---------

. oraenv


# Begin Backup
#################

exec 1>>$WORKING_DIR/backup.log
echo
echo "*** `date` ----> Begin Backup $ORACLE_SID"

$ORACLE_HOME/bin/rman target / cmdfile=$WORKING_DIR/rman_db_full_online_backup.cmd \
log=$LOG_DIR/rman_''$ORACLE_SID''_full_online_backup_$MDATE.log

echo "*** `date` ----> End Backup $ORACLE_SID"

To make a backup now directly on the Netapp with the Netapp-Plugin, you need

• a channel for a RMAN-Tape
• some parameters for this library set as environment

The archives backup remains still as normal backup to disk.

rman_db_full_on­line_backup.cmd

backup archivelog all not backed up 1 times delete input FORMAT "/oracle/backup/archivelog_backup_%d_%D.%M.%Y_%U";

run {
  allocate channel NTAP device type sbt_tape
  PARMS='SBT_LIBRARY=/oracle/product/11204/lib/libobk.so
  ENV=(DELETETYPE=snap,
       BACKUP_DIR=/oracle/product/11204/admin/rman_ntap,
       LD_LIBRARY_PATH=/oracle/product/11204/lib,
       CONF=rman_ntap.conf)'
  debug 1 trace 99;
  backup proxy database;
  delete obsolete;
  release channel NTAP;
  delete obsolete;
}

backup archivelog all not backed up 1 times delete input FORMAT "/oracle/backup/archivelog_backup_%d_%D.%M.%Y_%U";