#!/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
## -------------------------------------------------------------------------------
Monday, March 8, 2010
Subscribe to:
Post Comments (Atom)




No comments:
Post a Comment