Re: Recover rman backups to a new instance?

From: akush <Berlin3010_at_web.de>
Date: Tue, 10 Aug 2004 18:00:37 +0200
Message-ID: <2ns9p6F41vanU1@uni-berlin.de>

Howard J. Rogers wrote:

> 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
>>
>>

>
>
>

Thanks for the answer.

    And what is with these backup sets that rman produces? These are all very big files with very cryptic names. How can i told the rman on the new instance that theses files should be taken for restoring the database?

thxs

    akush Received on Tue Aug 10 2004 - 11:00:37 CDT