Re: How to restore to a new database
Date: Mon, 20 Oct 2008 21:33:49 +0200
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
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;
recover database using backup controlfile;
That should be about it.
-- Sybrand Bakker Senior Oracle DBAReceived on Mon Oct 20 2008 - 14:33:49 CDT