Re: Creating a database from rman backup

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Wed, 19 May 2010 14:16:56 -0300
Message-ID: <AANLkTilbJh0B-o8uxOvbTPGGqMsVyvQanK5XiqbqHNia_at_mail.gmail.com>

caution: duplicate requires connection between the two servers.

Another option is (i'm guessing the backup is to disk):

• copy the rman backup sets
• start the new instance in NOMOUNT;
• restore controlfile from 'backupset_name'
• set newname for datafile # to '<new_path>';
• restore and recover database using backup controlfile
• create redo log files
• create tempfiles
• open database using retelogs;

if you need to set a new name, use the nid tool to rename it after the resetlogs operation.

hth
Alan.-

On Wed, May 19, 2010 at 2:13 PM, Guillermo Alan Bort <cicciuxdba_at_gmail.com>wrote:

> you can also use the 'set newname for datafile 1 to '<new_path>';
>
> This is a fun excercise, I'd suggest you try it a few times before doing it
> in production, though.
>
>
> pointers: current DB: target,
> new db (must be STARTED): auxiliary
>
> commando: duplicate database to auxiliary;
>
> hth
> Alan.-
>
>
>
> On Wed, May 19, 2010 at 1:03 PM, kathryn axelrod <kat.axe_at_gmail.com>wrote:
>
>> Use RMAN's 'duplicate'.
>> Since the directory paths are different, you will either use 'set newname'
>> or 'db_file_name_convert' & 'log_file_name_convert'
>>
>>
>> http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmdupdb.htm#BGBHBIFE
>>
>>
>> On Wed, May 19, 2010 at 8:45 AM, KRISHNA MOORTHY <
>> krish33moorthy_at_gmail.com> wrote:
>>
>>> Hi All,
>>>
>>> How can I create a database from the RMAN backup
>>>
>>> 1. I have a RMAN complete database backup (includes control file,
>>> datafiles, archived log file )at server A
>>> 2. I have to create a NEW database using the backup at server B
>>> 3. Server A and B does not have connection.
>>> 4. Mount Points of server A and server B is different...
>>>
>>> Can you please provide the steps.
>>>
>>> Regards
>>> Krishna
>>>
>>
>>
>

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

Received on Wed May 19 2010 - 12:16:56 CDT