help: Restore database to a different disk group

From: <emdproduction_at_hotmail.com>
Date: Thu, 5 Mar 2009 10:37:32 -0800 (PST)
Message-ID: <f2df6984-89b5-4915-ad35-9edffb7fd38e_at_e18g2000yqo.googlegroups.com>



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 Received on Thu Mar 05 2009 - 12:37:32 CST

Original text of this message