Re: How to restore to a new database

On Mon, 20 Oct 2008 10:21:41 -0700 (PDT), Richard <RSL101_at_gmail.com> wrote:

>This is cool. Maybe I can find my way out of the forest. Do I need to
>have a catalog in RMAN in source or target machine ?
>
>Also what key phrase when I search tahiti.oracle.com ?
>
>Thank You very much !

Question 1: No, you don't. Every RMAN session records info in your controlfile. If you have a catalog it is also recorded in the catalog. If you have that autobackup controlfile and the dbid, you should be OK.

For the moment, you shouldn't try to rename the database! You can always do that afterwards.

You should look for a scenario 'Restoring the database to a different host'
The procedure I outlined in my initial reply doesn't contain the full commands, but the mainline of it should be OK. set dbid ...
set until time '....'
set newname ....

restore controlfile from autobackup;
restore database;
recover database using backup controlfile;

That should be about it.

Good luck.

--
Sybrand Bakker
Senior Oracle DBA