Backup to Tape using Netbackup

Backup to Tape using Netbackup

---

#!/bin/ksh
#
# Title :       database_backup_nbu.ksh
# Description : Backs up the database to tape via the NetBackup API.
#
# Copyright :   ABCdba.com 2010
#

export ORACLE_SID=<sid name>
export ORACLE_HOME=<full pathname to ORACLE_HOME>
export PATH=$PATH:$ORACLE_HOME/bin
export NLS_DATE_FORMAT="DD-MON-YYYY:HH24:MI:SS"
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export DATE=`date '+%d%m%y_%H%M%S'`
export LOG=<full pathname to backup log directory>
export LOGFILE=${LOG}/rman_${ORACLE_SID}_tape_backup_db_${DATE}.log
$ORACLE_HOME/bin/rman log=$LOGFILE <<eof

connect target /;

run {
allocate channel ch1 type  'sbt_tape'  parms="ENV=(NB_ORA_CLASS=<NetBackup policy name>)" ;
allocate channel ch2 type  'sbt_tape'  parms="ENV=(NB_ORA_CLASS=<NetBackup policy name>)" ;
allocate channel ch3 type  'sbt_tape'  parms="ENV=(NB_ORA_CLASS=<NetBackup policy name>)" ;
allocate channel ch4 type  'sbt_tape'  parms="ENV=(NB_ORA_CLASS=<NetBackup policy name>)" ;
backup incremental level 0 filesperset 5 database format 'rman_${ORACLE_SID}_${DATE}_%U_%t' plus archivelog;
backup current controlfile format 'rman_${ORACLE_SID}_cntlfile_${DATE}.cf' ;
release channel ch1;
release channel ch2;
release channel ch3;
release channel ch4;
}

eof
exit