Re: Datafile not available.

From: Pavel Polcar <pavel.polcar_at_berit.cz>
Date: 1997/12/10
Message-ID: <01bd0576$79e236b0$62c3657e@polcar_nt4002>#1/1

Hi,

I once got into a similar mess so if you don't find anything more elegant, the following might help:

Create a new controlfile with the CREATE CONTROLFILE command where you put all the
files except the one that gives you problems. You should be able to start the database then
and drop and recreate the temporary tablespace. It helped in my case.

Pavel

Yuji Shimono <shimsoft_at_foxinternet.net> wrote in article <348DC503.8DD5482_at_foxinternet.net>...
> I had to recover a database from a backup. After recovery I had to do a
> resetlogs in order to open the database. Apparently, one of the
> datafiles was offline at the time the resetlogs was done. When I try to
> bring that database online, I get the error that the datafile is from
> before the last resetlogs and to restore a current copy of the
> datafile. I don't have a more recent copy since it never got reset.
> This datafile is in a temporary tablespace which contains another
> datafile which is okay. Is there a way to recover the datafile or can I
> drop the tablespace and recreate it again using the same names?
>
>
Received on Wed Dec 10 1997 - 00:00:00 CST