Re: RMAN RESTORE TO A DIFFERENT SID

1. restore the rman backup to the different server using the set dbid to the original database backups and then direct the files where you want to restore. Finally after the restore is done on the other server, create the control file and then use nid to change the dbid and the dbname.

If you dont want to use the nid then use the rman duplicate feature to create a clone from the rman backup. then you will have the different dbid as well different name.

Thanks
Nilesh Soni

On Sat, Apr 16, 2011 at 12:31 AM, Guillermo Alan Bort <cicciuxdba_at_gmail.com>wrote:

> John:
>
> No, you can't. There are some options (transportable tablespaces) but I
> think you have to do it from the source.
>
> Best option is to create a new DB in nomount, restore the controlfiles
> (you will need to set the DBID to the same as the old db) and then restore
> the DB and use nid to change the dbid/db_name.
>
> HTH
> Alan.-
>
>
>
> On Fri, Apr 15, 2011 at 3:22 PM, john scott <joscott2011.mail_at_gmail.com>wrote:
>
>> Andriy:
>>
>> Looks like I didn't make it very clear earlier. Sorry for that. My
>> intention was to restore it to a different db_name too. Do you mean to say
>> that I can't restore the backup to a different db_name?
>>
>> Thanks,
>> John
>>
>> ---------- Forwarded message ----------
>> From: andrey dmitrenko <jan2ary_at_gmail.com>
>> Date: Fri, Apr 15, 2011 at 2:13 PM
>> Subject: Re: RMAN RESTORE TO A DIFFERENT SID
>> To: joscott2011.mail_at_gmail.com
>> Cc: oracle-l_at_freelists.org
>>
>>
>> Check this
>> http://download.oracle.com/docs/cd/E11882_01/backup.112/e10642/rcmadvre.htm#i1007814
>>
>> You can use any sid, db_unique_name and directory structure, the only
>> things should be the same are db_name and dbid.
>>
>> Andriy
>>
>>
>>
>

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