ITPub博客

首页 > 数据库 > Oracle > ASM下迁移控制文件

ASM下迁移控制文件

原创 Oracle 作者:myownstars 时间:2013-05-16 16:51:52 0 删除 编辑
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/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: ASM下迁移spfile
请登录后发表评论 登录
全部评论

注册时间:2010-03-18

  • 博文量
    375
  • 访问量
    3320741