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@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 -----------------------------------------------------------------
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]"
---------------------------------------------------------------- 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 -----------------------------------------------------------------
