The three sample scripts are rman.sh, database.rman, and archivelog.rman. rman.sh is the “parent” script. It is called from cron with one required argument: database or archivelog. This tells rman.sh what it is supposed to do.

$ rman.sh [ database.full.rman | database.inc.rman ]

If called in this manner, rman.sh tells rman to use the command file database. level .rman. This command file tells rman to back up the entire database and switch log files when it is done. The level of the backup is determined by which rman script is called. (database.full does a level-0 backup, and database.inc does a level-1 backup.) If the PARALLELISM parameter at the top of the script is set to a number higher than 1, it backs up multiple instances at one time.

$ rman.sh [ archivelog.full.rman | archivelog.inc.rman ]

If called in this manner, rman.sh tells rman to use the command file archivelog. level .rman. This command file tells rman to back up all archive logs it finds but not to delete them when it is done. (There is an rman option to do this, but I believe it is better to leave the files around for a few days before they are deleted.) Again, the level is determined by which script is called.

Here is the rman.sh script:

#!/bin/sh
#
#######################################################
##Site-specific section (change as appopriate)

PATH=/usr/bin:/usr/sbin:/usr/ucb:/oracle/app/oracle/product/8.0.4/bin:/oracle/opt/
bin:/oracle/opt/rcs:/oracle/app/oracle/olap/olap/bin:/oracle/backupbin
ORACLE_BASE=/oracle/app/oracle
DEBUG=Y                  # Set this to "Y" to turn on set -x for all functions
BINDIR=/oracle/backupbin # Location of this and related programs
ORACLE=oracle            # ID that script will run as
DBAGROUP=dba             # GROUP that should own backup directory
ORATAB=/var/opt/oracle/oratab
ORACLE_HOME=`grep -v '^#' $ORATAB|awk -F':' '{print $2}' |tail -1`
TMP=/var/tmp             # Where temporary and permanent logs are kept
PATH=$PATH:/usr/bin:/usr/sbin:/sbin:/usr/5bin:/bin:$BINDIR
GLOBAL_LOGIN_PASSWD=internal/manager
RMAN_LOGIN_PASSWD=rman/rman
RMAN_SID=admin
ORIG_PATH=$PATH

SID_PARALLELISM=2        # The number of instances to back up simultaneously.

LOGDIR=/oracle/backupbin

Preback() {             #Run prior to backup. 
[ "$DEBUG" = Y ] && set -x
}

Postback() {          #Run after entire backup finishes.
[ "$DEBUG" = Y ] && set -x
}

export BINDIR ORATAB ORACONF TMP PATH ORIG_PATH

##End site-specific configuration section
#######################################################

Usage()
{
echo "Usage: $0: cmdfile
(Substitute 'cmdfile' with an rman cmdfile script (located in $BINDIR)
that will be run by $0. ... e.g. database.rman)"
exit 1
}
 
[ "$DEBUG" = Y ] && set -x

ORACLE_SIDS=`grep -v '^#' $ORATAB|awk -F':' '{print $1}'|grep -v '*'`

[ $# -eq 1 ] || Usage

CMDFILE=$1

PSID=sodfwer98w7uo2krwer987wer

for ORACLE_SID in $ORACLE_SIDS ; do

 CT=`ps -ef|grep -c 'rman.target'`
 while [ $CT -gt $SID_PARALLELISM ] ; do
  # Give the last command a little time to get going and/or fail.
  sleep 15
 
  if [ `ps -ef|grep -c " $PSID "` -gt 1 ] ; then
   # If the command that we just backgrounded is now running, add it to the CT.
   CT=`ps -ef|grep -c 'rman.target'`
   sleep 30
  else
   # If not, break out of this loop cause we'll be here forever.
   break
  fi
 done

  rman cmdfile "${BINDIR}/$CMDFILE" > $LOGDIR/rman.$ORACLE_SID.$CMDFILE.log 2>&1 &
  PSID=$!

done

Here is the rman command file used to perform a level-0 backup:

Run {
target passwd@oracle_sid;
rcvcat passwd@rman_sid;

allocate channel t1 type 'sbt_tape';
allocate channel t2 type 'sbt_tape';
allocate channel t3 type 'sbt_tape';
allocate channel t4 type 'sbt_tape';
backup incremental level 0 format 'backup_test_%t_%s_%p' database ;
sql 'alter system archive log current';}

Here is the rman command file used to back up all level-0 archive logs:

Run {
target passwd@oracle_sid;
rcvcat passwd@rman_sid;
allocate channel t1 type 'sbt_tape';
allocate channel t2 type 'sbt_tape';
allocate channel t3 type 'sbt_tape';
allocate channel t4 type 'sbt_tape';
backup incremental level 0 format 'backup_test_%t_%s_%p' archivelog all ;
sql 'alter system archive log current';}

Here is the rman command file used to perform a level-1 backup:

Run {
target passwd@oracle_sid;
rcvcat passwd@rman_sid;
allocate channel t1 type 'sbt_tape';
allocate channel t2 type 'sbt_tape';
allocate channel t3 type 'sbt_tape';
allocate channel t4 type 'sbt_tape';
backup incremental level 1 format 'backup_test_%t_%s_%p' database ;
sql 'alter system archive log current';}

Here is the rman command file used to back up all level-1 archive logs:

Run {
target passwd@oracle_sid;
rcvcat passwd@rman_sid;
aenteringchannel t1 type 'sbt_tape';
allocate channel t2 type 'sbt_tape';
allocate channel t3 type 'sbt_tape';
allocate channel t4 type 'sbt_tape';
backup incremental level 1 format 'backup_test_%t_%s_%p' archivelog all ;
sql 'alter 
                     system archive log current';}