Re: Auditing

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Tue, 2 Mar 2004 10:15:51 +0200
Message-ID: <032201c4002e$93fa8160$b8fb23d5@porgand>

In a fresh 10g installation on Linux, AUD$ is still in SYSTEM ts, so is the FGA_LOG$ table :(
It's probably because Oracle wants to keep all SYS objects in SYSTEM tablespace.

Tanel.

Original Message ----- From: "Jared Still" <jkstill_at_cybcon.com> To: "Oracle-L Freelists" <oracle-l_at_freelists.org> Sent: Monday, March 01, 2004 5:32 PM Subject: Re: Auditing

> In 10g aud$ is placed in SYSAUX tbs IIRC.
>
> Jared
>
> On Sat, 2004-02-28 at 07:16, Nuno Souto wrote:
> > Dunno if this is still the case in 10g, but auditing used to be switched
> > on and off from the init.ora file. Which means you can turn it off
> > before attempting the recovery?
> >
> > Cheers
> > Nuno Souto
> > in sunny Sydney, Australia
> > dbvision_at_optusnet.com.au
> > ----- Original Message -----
> > From: "Hemant K Chitale" <hkchital_at_singnet.com.sg>
> >
> > > If I remember correctly, at my site [and this was another DBA] we
lost
> > the
> > > disk
> > > holding the non-SYSTEM Tablespace with the renamed SYS.AUD$ [as
SYS.AUD$$]
> > > table. We did an ALTER DATABASE DATAFILE OFFLINE DROP and recovered
> > > the database and switched off auditing. That should work.
> >
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at http://www.freelists.org/archives/oracle-l/
> > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Mar 02 2004 - 02:12:46 CST