Re: restore RMAN backup to different server with different database name????

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Fri, 9 Jul 2010 21:14:13 -0300
Message-ID: <AANLkTik5UuhZ4LLdVaOsnSOzpQT6FrV9JmIp6CIvz7Mc_at_mail.gmail.com>

You can restore the database with the same name and change it afterwards. Although duplicate using until time is much more sensible.

hth
Alan.-

On Fri, Jul 9, 2010 at 4:34 PM, Jay Hostetter <hostetter.jay_at_gmail.com>wrote:

> As Niall stated, duplicate will work. I recently performed a disaster
> recovery test of backups similar to what you are doing. The requirement was
> to NOT connect to the production database (which wouldn't be available in a
> disaster situation).
>
> You probably need to change db_name and/or instance_name in your
> spfile/init.ora.
> After you get your database restored, change the DBNAME with the nid
> utility.
>
> On Fri, Jul 9, 2010 at 3:22 PM, Niall Litchfield <
> niall.litchfield_at_gmail.com> wrote:
>
>> Well duplicate does obey the SET UNTIL and catalog clauses.
>>
>> Niall Litchfield
>>
>> On Jul 9, 2010 8:17 PM, "dba1 mcc" <mccdba1_at_yahoo.com> wrote:
>>
>> we have ORACLE database 10Gr2 and 11GR1 on Linux servers. We plan to take
>> RMAN backup from one server to other server (exactly same configuration on
>> hardware/software). We try to restore RMAN backup on second node but
>> different database name. The reason we don't use "duplicate database" is we
>> are not restore current database data. Customer want restore one week or
>> two weeks ago backup.
>>
>> the procedure we implement are:
>>
>> 1. on second node, create new database location.
>>
>> 2. transfer RMAN backup from node A to node B
>>
>> 3. edit init.ora on new database and put:
>> db_file_name_convert= (...)
>> log_file_name_convert=(...)
>> DB_NAME=newname
>>
>> 4. startup RMAN
>>
>> rman target /
>> startup nomout;
>> restore controlfile from ...
>> start mount;
>> ORA-01103: database name 'db01' in control file is not 'DB02'
>>
>>
>> How to overcome this error?
>>
>> Thanks.
>>
>>
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>

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

Received on Fri Jul 09 2010 - 19:14:13 CDT