Re: help: Restore database to a different disk group

From: Jerome Vitalis <vitalis..._at_gmail.com>
Date: 10 Mar 2009 14:13:47 GMT
Message-ID: <49b6759b$0$25561$426a34cc_at_news.free.fr>

emdproduction_at_hotmail.com wrote:

> Dear group,

> I need to restore a RMAN backup to a different server, with different
> diskgroup name
> After i shipped all the RMAN backups to the new server, i need to do
> run {
> set newname for datafile 1 to '+NEWDISKG';
> set newname for datafile 2 to '+NEWDISKG';
> set newname for datafile 3 to '+NEWDISKG';
> .......
> restore database;
> }

> after that, i need to do alter system rename logfiles to the new
> diskgroup as well.

> But every time, i need to check is there any new datafile created,
> etc.

> Is there any better way of doing this?

> Thanks for your help

Hi,

Use the duplicate command instead. With the correct db_create_file_dest and db_create_online_log_dest_x parameters for the auxiliary instance, RMAN will take care of the path conversion.

---

échangez opinions et commentaires dans les forums de discussion. http://www.usenetgratuit.com/ Received on Tue Mar 10 2009 - 09:13:47 CDT