trace file script

Remove the old trace file in oracle using shell script

Normally DBA's are managed several oracle database server & some application server.Every month during maintenance activity we purged the older trace files in udump,bdump,adump and application event log files.
We planned to automated this activity.

Below scripts are purged the trace file greater than 15 days.Once executed the scripts its automatically trigger the mail to user with before purge status & after purge status information.


SCRIPT #1
##############################################################################

REMOVE THE OLD TRACE FILES
CREATED BY RAJABASKAR THANGARAJ 12-12-2008

##############################################################################

$ cat oldtrace_remove.sh

#!/bin/ksh
echo Removing older trace file greater than 15 days .....
#run the environment variable profile
. $HOME/.bash_profile
PATH=/opt/app/oracle/admin
cd $PATH/$ORACLE_SID
RUNDATE=`date "+%d%m%y at %H:%M:%S"`
LOGFILE=/home/oracle/dbatest/raja/archived
# -mtime +15 remove the older trace file greater than 15 days
#change the days depend upons your need
du -m > $LOGFILE/before_purged_size.log
find $PATH/$ORACLE_SID/udump/*.trc -mtime +15 -exec rm {} \;
find $PATH/$ORACLE_SID/bdump/*.trc -mtime +15 -exec rm {} \;
find $PATH/$ORACLE_SID/adump/*.trc -mtime +15 -exec rm {} \;
du -m > $LOGFILE/after_purged_size.log
cat $LOGFILE/beforepurgestmt.log $LOGFILE/before_purged_size.log $LOGFILE/afterpurgestmt.log $LOGFILE/after_purged_size.log
> $LOGFILE/mail.log
mail -s "Status of $ORACLE_SID Old trace file successfully purging on $RUNDATE " raja.baskar@abcde.com < $LOGFILE/mail.log
exit;

********************************************************

SCRIPT #2
*********

Below formatted log files are located in /home/oracle/dbatest/raja/archived.
$ cat beforepurgestmt.log

************************************************
BEFORE PURGING THE TRACE FILE SIZE IN MB

*************************************************

SCRIPT #3

Below formatted log files are located in /home/oracle/dbatest/raja/archived.

$ cat afterpurgestmt.log

********************************************************

AFTER PURGING THE TRACE FILES SUCCESSFULLY.SIZE IN MB

*********************************************************

OUTPUT MAIL FORMAT:
*******************************

SUBJECT: Status of orcl Old trace file successfully purging on 121208 at 19:17:16


CONTENT:

************************************************

BEFORE PURGING THE TRACE FILE SIZE IN MB

*************************************************

1056 ./adump

100 ./scripts

2056 ./cdump

10024 ./dpdump

3824 ./udump

38240 ./bdump

10 ./pfile

********************************************************

AFTER PURGING THE TRACE FILES SUCCESSFULLY.SIZE IN MB

*********************************************************

512 ./adump

1 ./scripts

512 ./cdump

10024 ./dpdump

1024 ./udump

503 ./bdump

10 ./pfile


*******************************************************************************