Re: Corrupted datafile

There is another possibility. I have not tried it in your release, but if you have a backup of the the control file ('Alter System Backup Controlfile To Trace' in SQL/English, then you can try removing the file name from the listing in the script.

In some releases, Oracle will note the missing file and generate a 'MISSINGXXX' entry in the dd (XXX=file# from v$datafile).

At this point, you should be able to /have the database up, export the data, blow the tablespace away and rebuild it.

I have done this in V7 with archivelog mode, so I am not sure if it will work for you, but it may be worth a shot.

In article <90ro1m$a8i$1_at_nnrp1.deja.com>,   David Fitzjarrell <oratune_at_aol.com> wrote:
> 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.
>

--
Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.


Sent via Deja.com http://www.deja.com/
Before you buy.