Re: ADR file archive tools

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Tue, 25 Nov 2008 10:17:01 +0100
Message-ID: <486b2b610811250117u54ad33f1w4d7c1f48524f894b@mail.gmail.com>


Thought through ? :)

SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
stefan_at_speedy:~$ adrci

ADRCI: Release 11.1.0.6.0 - Beta on Tue Nov 25 10:15:57 2008

Copyright (c) 1982, 2007, Oracle. All rights reserved.

ADR base = "/u00/app/oracle"
adrci>

Whoever thought about it, though that releasing a beta software with the production release is a good thing too :-)


Stefan P Knecht
Senior Consultant
Systems Engineering

OPITZ CONSULTING Schweiz GmbH
Seestrasse 97
CH-8800 Thalwil

Mobile +41-79-571 36 27
stefan.knecht_at_opitz-consulting.ch
http://www.opitz-consulting.ch

OCP 9i/10g SCSA SCNA


On Tue, Nov 25, 2008 at 3:33 AM, Ray Stell <stellr_at_cns.vt.edu> wrote:

>
> Thank you, I was, in particular looking for how to archive the
> listener.log data, which I see no mention of in purge.
>
> The purge section of:
> http://download.oracle.com/docs/cd/B28359_01/server.111/b28319/adrci.htm
> says:
> [-type {ALERT|INCIDENT|TRACE|CDUMP|HM}]
>
> Specifies the type of diagnostic data to purge (alert log messages,
> incident data, trace files (including dumps), core files, or Health
> Monitor run data and reports).
>
> I'm thinking they forgot about this monster.
>
> Calling all clues!
>
>
>
> On Mon, Nov 24, 2008 at 11:40:57PM +0000, Niall Litchfield wrote:
> > I believe that you are intended to use ADRCI and in particular the PURGE
> > command. Frankly I don't see how this innovation was thought through at
> all,
> > nor how the user testing in the Beta program managed to avoid picking up
> > that existing scripts would screw up and that extra maintenance and
> security
> > risks would be exposed, but maybe that's just me.
> >
> > Niall.
> >
> > On Mon, Nov 24, 2008 at 11:29 PM, Ray Stell <stellr_at_cns.vt.edu> wrote:
> >
> > > The ADR stuff in 11g does not seem to have an obvious tool to manage
> > > the files that are generated. The Frequently Asked Questions, Doc
> > > ID: Note:453125.1, doesn't mention how to archive the files. I don't
> > > see anything in the elaborate documentation on Automatic Diagnostic
> > > Repository. Does anyone have a pointer on how to protect the
> filesystem
> > > from this bloat? Maybe the OS cmds are supposed to be used, but
> that's
> > > not usually how things work.
> > >
> > > Lot's of coverage on how to look at the files, nothing on protecting
> > > oneself
> > > from them. Maybe it's all automagic and I don't have to fuss with it,
> > > yeah,
> > > that's it.
> > > --
> > > http://www.freelists.org/webpage/oracle-l
> > >
> > >
> > >
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > http://www.orawin.info
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 25 2008 - 03:17:01 CST

Original text of this message