Today's Birthday
Quote of the Day
This Day in History

Monday, March 8, 2010

sample rman_config.ksh file

#!/bin/ksh

##
## Script Name: rman_config.ksh
## Author : Ramakrishna Nemani
##
## Set your rman & shell environment using this script
##
##

##

## Make sure ORACLE_SID is passed as an argument
##

if (( $# < 1 ))
then
echo
echo Error Missing Arguement, Please supply Oracle Sid
echo
echo Usage: $0 ORACLE_SID
echo
exit
fi

export ORACLE_SID=$1
LOG_DIR="."

##
## Make sure no other rman process is running for this ORACLE_SID
##

LOCKFILE="${LOG_DIR}/$ORACLE_SID.lock"

while [ 1 ]
do

if [  -e  $LOCKFILE ]
then

##
## Some rman process is running. Check again after 3 minutes
##
sleep 80
else

##
## No rman process is running. Create the lock file
##
echo Do not remove this file. This is a lock file for $ORACLE_SID > $LOCKFILE
break
fi

done

CURR_DATE=`date +"%Y%m%d_%H%M%S"`

##
## using two seperate files instead of one
## The LOGFILE will have log from just the latest run
## The ARCFILE will have cumulative log
##

## LOGFILE="${LOG_DIR}/rman_config_$CURR_DATE.$ORACLE_SID.log"

LOGFILE="${LOG_DIR}/rman_config.$ORACLE_SID.log"
ARCFILE="${LOG_DIR}/rman_config.$ORACLE_SID.arc"

##
## Run rman config commands
##

rman <<EOF  > $LOGFILE
connect target / ;

CONFIGURE RETENTION POLICY TO REDUNDANCY 7 ;
CONFIGURE BACKUP OPTIMIZATION ON;

CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP
FORMAT FOR DEVICE TYPE DISK TO 'controlfile_%F';

CONFIGURE DEFAULT DEVICE TYPE TO DISK ;

CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET ;

CONFIGURE DEVICE TYPE sbt PARALLELISM 4 BACKUP TYPE TO BACKUPSET ;

EOF

cat $LOGFILE >> $ARCFILE

##
## Remove lock file to allow other rman processs for
## this ORACLE_SID to run
##

rm $LOCKFILE

## -------------------------------------------------------------------------------
## End of  rman_config.ksh
## -------------------------------------------------------------------------------

No comments:

Post a Comment