ORACLE10GRAC+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中.(我此处就是变成了back 打头)
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 nomount pfile='/u01/app/init.ora';
create SPFILE='+DG1/orcl/spfilehanmi.ora' from pfile='/u01/app/init.ora';
shutdown immediate;
startup open;
大功告成.
SQL> select name from v$controlfile;
NAME
--------------------------------------------------------------------------------
+DATA/rac1/controlfile/current.260.745250819
+DATA/rac1/controlfile/backup.268.745936451
+DATA/rac1/controlfile/backup.269.745936467
source: http://hi.baidu.com/yanyu203020/blog/item/8d52e1ad4be8aad97cd92ad5.html#0
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7583803/viewspace-722633/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7583803/viewspace-722633/