Re: Corrupted Datafile

Hi Anna,

Maybe you can drop all your indexes resides in corrupted datafile (I guess this will cause Oracle write in tablespace SYSTEM only), and after it Oracle may allow you get offline this datafile being empty?

Regards, Alexander Medvedev

Anna Sotnichenko wrote:

> I run Oracle Workgroup 8.0.5 under Windows NT.
> One of the datafiles containing indexes got corrupted. No backup copy.
> I want to drop this file and recreate indexes but I cannot take it
> offilne.
> What I'm trying to do is to start Oracle without opening database and
> take the file offline, but when I issue ALTER DATABASE ... DATAFILE
> OFFLINE statement I got error message "ORA-01145: offline immediate
> disallowed unless media recovery enabled"
> When I try to issue ALTER DATABASE ARCHIVELOG statement I got error
> message "ORA-00265: instance recovery required, cannot set
> ARCHIVELOG mode"
> Please advise.
> Thanks in advance
>
> Anna
  Received on Sat Dec 09 2000 - 09:16:04 CET