Re: Auditing

  • From: "Nuno Souto" <dbvision@xxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Sun, 29 Feb 2004 02:16:37 +1100

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@xxxxxxxxxxxxxxx
----- Original Message ----- 
From: "Hemant K Chitale" <hkchital@xxxxxxxxxxxxxx>

> 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: