Question if quite interesting and though of sharing it with you. Here what i did, my old diskgroup is +DATA and wanted to move to +FRA.
I did something like
SQL>show parameter control_files
control_files string +DATA/ORCL/controlfile/current.110.293846193
SQL>alter system set CONTROL_FILES = '+FRA' scope=spfile
SQL>shutdown
rman target /
RMAN>startup nomount
RMAN>restore controlfile from '/+DATA/ORCL/controlfile/current.110.293846193';
RMAN>alter database mount;
RMAN> alter database open;
Worked great for me. Thanks
ReplyDelete