Script to take Oracle DB full backup using networker

Script

Script on Unix server to take Oracle DB full backup using networker

File name: full_bkp_ORCL.sh

 

LOGDATE=`date +”%m_%d_%y_%H_%M”`
export LOGDATE

ORAENV_ASK=NO
ORACLE_SID=$1
export ORACLE_SID
. /usr/local/bin/oraenv >/dev/null
DB=${ORACLE_SID}
export ORACLE_HOME=/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1
export LIBPATH=$ORACLE_HOME/lib:$LIBPATH
LOGFILE=/home/oracle/NWR/${ORACLE_SID}_incr_0_${LOGDATE}.log
exec > $LOGFILE 2>&1

echo “Start of $DB incremental level 0 backup ” $LOGDATE

$ORACLE_HOME/bin/rman target / <<EOF

configure controlfile autobackup on;
configure retention policy to recovery window of 14 days;
configure default device type to sbt;

run
{
allocate channel c1 type ‘SBT_TAPE’;
allocate channel c2 type ‘SBT_TAPE’;
send ‘NSR_ENV=(NSR_SERVER=NWRSRVR.ajara.tech, NSR_DATA_VOLUME_POOL=NWRVOLPOOL.ajara.tech)’;
backup incremental level 0 tag “LVL0_30days” as compressed backupset database filesperset 128 Keep UNTIL TIME ‘SYSDATE+30’;
release channel c1;
release channel c2;
}

exit
EOF
CNT=`egrep -i “ORA-|RMAN-|TNS-” ${LOGFILE}| wc -l`
if [ ${CNT} -gt 0 ]
then
echo “RMAN backup of ${DB} may be completed with Warning/Errors ” $LOGDATE
else
echo “Backup of ${DB} Completed Successfully.” $LOGDATE
fi

exit

 

 

 

See also

Oracle database restore and recovery scripts