DB version : 11.2.0.3
Platform : RHEL 5.4
I was told that professional DBAs use adrci these days to purge unwanted trace files :)
So, I used it about a month ago , but it didn't remove any log files and I had to manually remove the files then.
This time it is a different issue. purge command itself is not working this time.
Issue description:
=================
DB HOME filesystem became full because ORACLE_HOME/rdbms/log (or ORACLE_HOME/log , can't remember now) directory was getting full by some sort of trace files with the extension .trc
So, I try to purge unwanted files using adrci . But I got the following error . Eventually I had to manually remove the trace files using rm.
$ adrci
ADRCI: Release 11.2.0.3.0 - Production on Mon Nov 26 13:06:26 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/app/oracle/global"
adrci>
adrci>
adrci>
adrci> purge -age 8640 -type TRACE
DIA-48448: This command does not support multiple ADR homes
adrci> show control
DIA-48448: This command does not support multiple ADR homes
adrci> help
HELP [topic]
Available Topics:
CREATE REPORT
ECHO
EXIT
HELP
HOST
IPS
PURGE
RUN
SET BASE
SET BROWSER
SET CONTROL
SET ECHO
SET EDITOR
SET HOMES | HOME | HOMEPATH
SET TERMOUT
SHOW ALERT
SHOW BASE
SHOW CONTROL
SHOW HM_RUN
SHOW HOMES | HOME | HOMEPATH
SHOW INCDIR
SHOW INCIDENT
SHOW PROBLEM
SHOW REPORT
SHOW TRACEFILE
SPOOL
There are other commands intended to be used directly by Oracle, type
"HELP EXTENDED" to see the list
adrci> set home=/u01/app/oracle/product/db/11gR2
DIA-48470: Unknown "SET" command
adrci> set homepath=/u01/app/oracle/product/db/11gR2
DIA-48470: Unknown "SET" command
BTW, This is a RAC DB.