DB restore problem

From: Peter <zouzou_at_zou.com>
Date: Thu, 14 Mar 2002 09:20:51 -0500
Message-ID: <Xk2k8.3502$a04.17659@tor-nn1.netcom.ca>

I restored part of a db yesterday and forgot one file belonging to a required tablespace.

I did a recovery until time, and open resetlogs. Now the file has been named MISSING0001 by Oracle.

Is there any way now I can recover this missing file, as it belongs to a previous incarnation of the database?
I have the file on disk at this time, but don't know how to recover it.

alter database recover datafile '$1$dga60:[inftmp]FIN_07.dbf' *

ORA-00283: recovery session canceled due to errors
ORA-01190: controlfile or data file 26 is from before the last RESETLOGS
ORA-01110: data file 26: '$1$DGA60:[INFTMP]FIN_07.DBF'

Thanks Received on Thu Mar 14 2002 - 08:20:51 CST