ASM下遷移控制檔案

How to duplicate a controlfile when ASM is involved [ID 345180.1]
Version: 10.1.0.2 to 11.1.0.7 - Release: 10.1 to 11.1
當使用ASM時，有如下方法將控制檔案從檔案系統或ASM
The procedure applies either to duplicate a controlfile into ASM using a controlfile stored in file system or to duplicate a controlfile into ASM using a controlfile already stored in ASM.

1 檔案系統 --》 ASM
建立ASM目錄；修改控制檔案引數；nomount狀態下恢復控制檔案；
alter diskgroup DG1 add directory '+DG1/P10R2/CONTROLFILE';
編輯init.ora或spfile
control_files='+DG1/P10R2/CONTROLFILE/control02.ctl','/oradata2/102b/oradata/P10R2/control01.ctl'
重啟資料庫並nomount，採用RMAN恢復控制檔案
RMAN> restore controlfile to '+DG1/PROD/controlfile/control02.ctl' from '/oradata2/102b/oradata/P10R2/control01.ctl';
Starting restore at 23-DEC-05
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
channel ORA_DISK_1: copied control file copy
Finished restore at 23-DEC-05
啟動資料庫

2 ASM --&gt ASM
修改控制檔案引數；重啟資料庫並nomount，restore引數檔案；
alter system set control_files='+DATA1/v102/controlfile/current.261.637923577','+DATA1' scope=spfile sid='*';
恢復控制檔案
RMAN> restore controlfile from '+DATA1/v102/controlfile/current.261.637923577';
Starting restore at 08-NOV-07
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=147 instance=V1021 devtype=DISK
channel ORA_DISK_1: copied control file copy
output filename=+DATA1/v102/controlfile/current.261.637923577
output filename=+DATA1/v102/controlfile/current.269.638120375
Finished restore at 08-NOV-07
修改控制檔案引數
alter system set control_files='+DATA1/v102/controlfile/current.261.637923577','+DATA1/v102/controlfile/current.269.638120375'  scope=spfile sid='*'; 
啟動資料庫