| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Auditing
Well, yes . We did unset AUDIT_TRAIL in the init.ora before the startup
for recovery.
Hemant
At 02:16 AM 29-02-04 +1100, you 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
>-----------------------------------------------------------------
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com {last updated 24-Jan-04}
"Failure is not an option.
It comes bundled with the software
[or hardware, as the case may be]"
-- 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:38:32 CST
 |
 |