Re: RMAN RESTORE TO A DIFFERENT SID

  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