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.