Re: ADR file archive tools

  • From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
  • To: stellr@xxxxxxxxxx
  • Date: Tue, 25 Nov 2008 10:17:01 +0100

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@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@xxxxxxxxxxxxxxxxxxx
http://www.opitz-consulting.ch

OCP 9i/10g SCSA SCNA
=========================


On Tue, Nov 25, 2008 at 3:33 AM, Ray Stell <stellr@xxxxxxxxxx> 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@xxxxxxxxxx> 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.
> > > --
> > > //www.freelists.org/webpage/oracle-l
> > >
> > >
> > >
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > http://www.orawin.info
> --
> //www.freelists.org/webpage/oracle-l
>
>
>

Other related posts: