ORACLE 10g RAC+ASM 增加控制文件

ORACLE 10g RAC+ASM 增加控制文件

  来源：http://hi.baidu.com/ouleiq/blog/item/2d6542d7c14819d0a144dfb2.html

    ORACLE 10G RAC+ASM 默认只有一个控制文件,如何增加多个控制文件的副本呢,网上的做法是直接恢复控制文件,但在哪里恢复没有说清楚.其实只要复制原来的控制文件即可. 因为如果是恢复来自备份的控制文件,那么就和当前的控制文件不一致. 数据库会打不开.报ORA-00214: control file '+DG1/orcl/controlfile/current.278.723200291' version

1623 inconsistent with file '+DG1/orcl/controlfile/current.305.724357401'

version 1614

下面的方法是直接复制当前控制文件, 方法是利用rman的restore命令.

export ORACLE_SID=+ASM1

asmcmd

cd +DG1/ORCL/CONTROLFILE

ASMCMD> ls

Current.278.723200291


先关闭两个节点.


export ORACLE_SID=orcl2

sqlplus / as sysdba

shutdown immediate;


再到另外一个节点上.


export ORACLE_SID=orcl1

shutdown immediate

startup nomount;

exit


rman target /

restore controlfile to '+DG1/orcl/controlfile/current.307.724358011' from '+DG1/orcl/controlfile/Current.278.723200291' ;

restore controlfile to '+DG1/orcl/controlfile/current.308.724358053' from '+DG1/orcl/controlfile/Current.278.723200291' ;


用oracle自身的控制文件作为源恢复即可, 相当于复制.


注意:restore后你自己命名的控制文件名如果是asm自动管理,可能名字不会按你命的名字来,在asmcmd中确认下正确的控制文件名,再更新到pfile中.



sqlplus / as sysdba

create pfile='/u01/app/init.ora' from spfile;

修改/u01/app/init.ora

将controlfile 修改为*.control_files='+DG1/orcl/controlfile/current.308.724358053','+DG1/orcl/controlfile/current.307.724358011','+DG1/orcl/controlfile/Current.278.723200291'


关闭数据库,以pfile启动, 无需恢复

sqlplus / as sysdba

shutdown immediate;

startup pfile='/u01/app/init.ora'

create spfile from pfile='/u01/app/init.ora';

startup


由于更新操作只进行了一个节点,所以需要在另外节点上也更新spfile; 否则报

ORA-01105: mount is incompatible with mounts by other instances

ORA-01104: number of control files (1) does not equal 3


export ORACLE_SID=orcl2

sqlplus / as sysdba

startup nomount;

create pfile='/u01/app/init.ora' from spfile;

shutdown immediate;

修改pfile

startup pfile='/u01/app/init.ora' from spfile;

create spfile from pfile='/u01/app/init.ora'

startup force;

大功告成. .