Tuesday, December 3, 2019

deleting old files

#put env code around it
#!/bin/ksh
#      Script:                    mv_logs.ksh
#      POC:                       DBA's
#      Date:                      Aug. 00
#      Description:               Simple log shift script
#
PATH=/bin:/usr/bin:/usr/sbin:/opt/local/bin:/usr/local/bin:/usr/openwin/bin
BASEDIR=`grep oracle /etc/passwd| grep -v bea |cut -d':' -f6`
ORACLE_SID=${1}
ORACLE_HOME=`grep ${ORACLE_SID} /var/opt/oracle/oratab | awk -F: ' {print $2}' -`
export ORACLE_SID ORACLE_HOME
RUNDATE=`date +%Y%m%d`
logf=${BASEDIR}/ksh/logs/purge_logs_${ORACLE_SID}_${RUNDATE}.log
#
find ${BASEDIR}/ksh/logs/ -mtime +181 -exec /bin/rm -f {} \; >>${logf} 2>>${logf}
find ${BASEDIR}/perl/logs/ -mtime +181 -exec /bin/rm -f {} \; >>${logf} 2>>${logf}
find /oracle/admin/${ORACLE_SID}/adump -name "*.aud*" -mtime +181 -exec rm {} \; >>${logf} 2>>${logf}
chmod 600 /oracle/admin/${ORACLE_SID}/adump/*.aud >>${logf} 2>>${logf}
find ${ORACLE_HOME}/rdbms/log/ -name "*.trc" -mtime +181 -exec rm {} \; >>${logf} 2>>${logf}
find ${BASEDIR}/backups/logs/ -mtime +181 -exec /bin/rm -f {} \; >>${logf} 2>>${logf}
rm -f $BASEDIR/perl/alert_${ORACLE_SID}.cnt >>${logf} 2>>${logf}
#
#    End of Job.