Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Corrupted datafile

Re: Corrupted datafile

From: David Fitzjarrell <oratune_at_aol.com>
Date: Fri, 08 Dec 2000 22:40:55 GMT
Message-ID: <90ro1m$a8i$1@nnrp1.deja.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US