Wednesday, April 05, 2006

[Example] Shell Script for rotate listener log

#!/bin/sh
# use for default listener name(LISTENER), if 10.2 , support every listener name

export ORACLE_HOME=/oracle/product/10.2.0/db

DATE=`/bin/date +'%Y%m%d'`
#Configure OHOME
OHOME=/oracle/product/10.2.0/db
DIR==${OHOME}/network/log
ODIR=${OHOME}/network/log/old


FILE=${OHOME}/network/admin/listener.ora
if [ -f ${FILE} ]
then
NDIR=`${OHOME}/bin/lsnrctl show log_directory | /bin/grep log_directory | /bin/awk '{print $6}'`
NFILE=`${OHOME}/bin/lsnrctl show log_file | /bin/grep log_file | /bin/awk '{print $6}'`
LOGFILE=${NDIR}/${NFILE}


if [ ! -d ${ODIR} ]
then
/bin/mkdir ${ODIR}
fi

if [ -f ${LOGFILE} ]
then

/bin/mv ${LOGFILE} ${ODIR}/${NFILE}.${DATE}


${OHOME}/bin/lsnrctl set log_status off
${OHOME}/bin/lsnrctl set log_status on
/bin/gzip ${ODIR}/${NFILE}.${DATE}

fi

fi

---------------------

No comments: