Re: Can I restore tablespaces(datafiles) to a new blank database?

TG wrote:
> 9.2.0.6 on Windows server
>
> Here is the situation:
>
> Junior dba wanted to free up some space on a server, so he deleted
> datafiles from a shut down database that he *thought* was his test, not
> his active development database, of course it turns out he deleted the
> wrong set of files and this database was (inexplicably) not backed up.
>
> I go in with a file recovery tool, recover most of the datafiles, and
> more importantly, recover the ones that have the critical info that can
> save a long & costly rebuild of the dev db.
>
> I create a new blank database on another machine, then I thought I could
> rebuild the controlfile with the recovered datafiles from the deleted
> database added. When I created the new database I created it with a
> slightly different name, no problem I think, thinking I could use "set
> database" and alter the init.ora and call it the same as the deleted
> database, so I do the following:
>
> backup control file to trace in new database, shut it down, edit the
> init.ora with new (old) name, startup nomount and try to recreate the
> control file with "set database "newname" resetlogs" and the datafiles
> from the deleted database added at the end of the create controlfile
> script. The new database is being set to the same name as the deleted
> one, but I am getting "ORA-01159: file is not from same database as
> previous files - wrong database id" errors from the added file(s)
>
> I missed something here, do I need to recreate the new database from
> scratch with the same name as the deleted one? Is it possible to do what
> I am attempting? I thought it should be, and this is the only option I
> have in any case.

Hi,

I think you have to use the same name. Recently I have done something similar and created a 'test'-database using the datafiles I've copied from production - nice lesson to learn. These 2 articels of metalink might help:
174226.1
224274.1

regards,
stephan Received on Wed Jul 19 2006 - 02:43:02 CDT