Wednesday, March 28, 2012

How to move controlfile to different diskgroup in ASM?

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;

1 comment: