removal of ORACLE_BASE/rbdms/ORACLE_SID/alert.xml files [message #536892] |
Fri, 23 December 2011 13:27 |
|
BeefStu
Messages: 208 Registered: October 2011
|
Senior Member |
|
|
I am running Oracle 11.1.0.7 and 11.2.0.2 of various flavors
of UNIX (AIX, SOLARIS, HPUX, LINUX).
I currenlty use adrci to remove TRACE,DUMP,ALERT,... files.
Is there a tool other than "rm" that can be called to clean
up *.XML files
pwd
/u01/app/oracle/diag/rdbms/otapdev/otapdev
-rw-r----- 1 oracle dba 10486112 Apr 17 2010 ./alert/log_1.xml
-rw-r----- 1 oracle dba 10485856 Apr 23 2010 ./alert/log_10.xml
-rw-r----- 1 oracle dba 10485761 Apr 24 2010 ./alert/log_11.xml
-rw-r----- 1 oracle dba 10486111 Apr 27 2010 ./alert/log_12.xml
-rw-r----- 1 oracle dba 10485972 May 6 2010 ./alert/log_13.xml
-rw-r----- 1 oracle dba 10485925 May 9 2010 ./alert/log_14.xml
-rw-r----- 1 oracle dba 10485862 May 12 2010 ./alert/log_15.xml
-rw-r----- 1 oracle dba 10485864 Aug 26 2010 ./alert/log_16.xml
-rw-r----- 1 oracle dba 10485941 Aug 29 2010 ./alert/log_17.xml
-rw-r----- 1 oracle dba 10485770 Sep 1 2010 ./alert/log_18.xml
-rw-r----- 1 oracle dba 10485938 Sep 4 2010 ./alert/log_19.xml
-rw-r----- 1 oracle dba 285 Apr 17 2010 ./alert/log_2.xml
-rw-r----- 1 oracle dba 10486281 Sep 6 2010 ./alert/log_20.xml
Thanks to all who answer. Happy holidays
|
|
|
|
|
|
Re: removal of ORACLE_BASE/rbdms/ORACLE_SID/alert.xml files [message #537289 is a reply to message #536907] |
Tue, 27 December 2011 09:33 |
|
LKBrwn_DBA
Messages: 487 Registered: July 2003 Location: WPB, FL
|
Senior Member |
|
|
If you have setup the purging policies, perhaps this is simpler:
#!/bin/ksh
# cleanup_files.sh
#
export ORACLE_SID=orcl
ORAENV_ASK=NO
. /usr/local/bin/oraenv
HOMEPATH=$(adrci exec="show homes"|grep -v '^ADR Homes:')
echo "spool adrci_`date +%Y%m%d\-%H%M`.log">adrci_cmds.adi
echo "set echo on">>adrci_cmds.adi
for h in $HOMEPATH
do
echo "set homepath $h">>adrci_cmds.adi
echo "purge">>adrci_cmds.adi
done
echo "spool off">>adrci_cmds.adi
echo "quit">>adrci_cmds.adi
adrci script=adrci_cmds.adi
[Updated on: Wed, 04 January 2012 12:50] by Moderator Report message to a moderator
|
|
|
|
|
|
|
|
|
|