Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Corrupted datafile
In our last gripping episode ashish25_at_my-deja.com wrote:
> Hi,
> Try
> alter database ....... datafile offline drop;
> Regards,
> Ashish
>
> In article <3A3156F0.3CFF48FD_at_home.com>,
> Anna Sotnichenko <annasony_at_home.com> 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
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
This is precisely the statement she cannot execute.
Unfortunately, without a cold backup of your database I believe you are out of luck. Since your instance is in NOARCHIVELOG mode you have no hope of media recovery outside of the current redo logs.
Try ALTER TABLESPACE OFFLINE NORMAL. If that should work then issue the ALTER DATABASE DATAFILE .... OFFLINE DROP followed by ALTER TABLESPACE ..... ADD DATAFILE ..... SIZE .... REUSE. If the datafile is corrupt you may want to specify a new datafile and delete the old at the operating system level.
-- David Fitzjarrell Oracle Certified DBA Sent via Deja.com http://www.deja.com/ Before you buy.Received on Fri Dec 08 2000 - 16:40:55 CST