Re: Recover rman backups to a new instance?

On Tue, 10 Aug 2004 15:57:24 +0200, akush <Berlin3010_at_web.de> wrote:

> Hello!
>
> i am a newbie at oracle and try to understand how i can manage the
> backups of my oracle db.
>
> i think about the situation that the database or the server totally
> crashed and i have to complete reinstall oracle. What i have are all the
> backup files ( controlfile, spfile, the archive logs, redo logs and
> backup sets stored on an extra backup file server ).
>
> Now when i create a new database instance i have the problem that this
> instance has a another dbid as the original database. And all
> backupfiles that rman made will be rejected.
>
> So what are the steps when i want to recreate the database and restore
> all data from the backup files ( not to copy the tablespaces files
> directly )?

It would simply be something like

set newname for /u01/data/system01.dbf to /u6/system.dbf set newname for /another/original/name to /another/new/one [and so on for all files]
restore database;
switch datafile all;
recover database;

You don't create a new database, in other words, and then hope RMAN sorts out the DBIDs for you. You simply create a new *instance* on the new machine and then get RMAN to use that to restore everything straight off the backup tapes into the new locations you've specified.

If the new machine has the same directories etc as the original, you would simply 'restore database' and then 'recover database': if the old paths and filenames are still valid for the new machine, then all that 'set newname' stuff is not needed.

Regards
HJR
>
> i am a little bit confused about these backups.
>
> thanks for help
> akush
>
>

-- 
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/