Re: Auditing

From: Nuno Souto <dbvision_at_optusnet.com.au>
Date: Sun, 29 Feb 2004 02:16:37 +1100
Message-ID: <01c101c3fe0d$dea43800$9b00a8c0@dcs001>

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
-----------------------------------------------------------------

Received on Sat Feb 28 2004 - 09:13:56 CST