Re: Corrupted Datafile
Date: Sun, 10 Dec 2000 16:09:08 +0800
Message-ID: <90ve12$n2h3_at_imsp212.netvigator.com>
Try shut down your database and startup again. There should have error
messages when you start up your database.
You may type "recover database" in server manager after you startup the
database.
If it shows datafile error, try typing "recover datafile <datafile name>".
Ken
"Anna Sotnichenko" <annasony_at_home.com> ?????
news:3A315AC7.BE5F3F0F_at_home.com...
> 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 Sun Dec 10 2000 - 09:09:08 CET