Re: help: Restore database to a different disk group

From: <johnbhurley_at_sbcglobal.net>
Date: Thu, 5 Mar 2009 11:26:27 -0800 (PST)
Message-ID: <bf64b650-5723-4462-8fda-4042db71a759_at_p6g2000pre.googlegroups.com>

On Mar 5, 1:37 pm, emdproduct..._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

Have you tried scripting it out via some scripting technology so you don't have to do it manually? Received on Thu Mar 05 2009 - 13:26:27 CST