Re: DB restore problem

If you don't want to take down your production environment then you could create a clone and
perform the recovery on the clone DB.

1. Restore system, temp, rollback and the tablespace you missed the first time to another place. (I guess you don't even need temp & rollback - but to be on the safe side ...)
2. Recreate the control file - rename the db - leave out all missing datafiles
3. recover database until cancel using backup controlfile
4. open the db (resetlogs)
5. -> 2 options
   • export all data from the recovered tablespace, recreate tablespace on production and import into your production DB
   • use transportable tablespace and plug the recovered tablespace into production (i've never done it this way ... but it should be possible)

I see no reason why you should take down your production environment and recover from scratch - unless you think it's easier that way ...

"Peter" <zouzou_at_zou.com> wrote in message news:Xk2k8.3502$a04.17659_at_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 - 09:49:59 CST