首页 > 数据库 > Oracle > 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 --> 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='*'; 启动数据库
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/15480802/viewspace-761275/ ,如需转载,请注明出处,否则将追究法律责任。