RE: Rman restore from backup on disk

You can restore the database on a different server and the same name and then recreate the controlfile by using SET instead of REUSE to rename it (obviously changing the init file parameters and name).

e.g. CREATE CONTROLFILE SET DATABASE "CPNMKEV" RESETLOGS ARCHIVELOG

I wrote a document for my last organization which steps through cloning via this process including using nid to change the DBID if you're interested. I've learned some things since then which make it somewhat simplistic but it has the syntax you would need.

You can restore on the same server with the same name and a different namespace (I believe that's the term) but I haven't done that in years.

HTH, Kevin

On Tue, 2008-02-26 at 10:46 -0500, Joel.Patterson_at_crowley.com wrote:
> Hmmm. The Problem came about because of a clone. They want to keep
> the clone, but they need some data out of the database that disappeared.
>
> I want to restore the database that disappeared without bothering the
> existing clone.
>
> (I can use another server, and recover, but I'm looking for the answer.
> ie put on same server alongside existing cloned database, but with
> different name).
>
> 2nd topic but related:
> With a cold backup, (or user created online backups), I can just restore
> the needed tablespaces/datafiles I want by editing the trace file first.
> How about with RMAN?
>
>
> Joel Patterson
> Database Administrator
> joel.patterson_at_crowley.com
> x72546
> 904 727-2546

--
http://www.freelists.org/webpage/oracle-l