Oracle – Remove Old Trace File In Oracle Using Shell Script

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

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

I Hope this article helped you to understand the remove the old files.Suggestions are welcome.