ITPub博客

首页 > 数据库 > Oracle > AIX6.1系统下RAC11gR2启动节点实例遭遇ORA-00205

AIX6.1系统下RAC11gR2启动节点实例遭遇ORA-00205

原创 Oracle 作者:fengsongtao123 时间:2016-05-20 15:50:20 0 删除 编辑
故障:启动RAC一个实例节点时报错ORA-00205,如下

bash-3.2$ srvctl start instance -d db01 -i DB011
PRCR-1013 : Failed to start resource ora.db01.db
PRCR-1064 : Failed to start resource ora.db01.db on node db1
ORA-00205: error in identifying control file, check alert log for more info
CRS-2674: Start of 'ora.db01.db' on 'db1' failed


问题分析:

查看警告日志文件发现如下信息:
......
This instance was first to mount
Fri May 20 15:00:10 2016
Errors in file /oracle/app/oracle/diag/rdbms/db01/DB011/trace/DB011_ckpt_11993214.trc  (incident=10961):
ORA-00227: corrupt block detected in control file: (block 1, # blocks 1)
ORA-00202: control file: '+DATA/db01/controlfile/current.297.912339151'
Incident details in: /oracle/app/oracle/diag/rdbms/db01/DB011/incident/incdir_10961/DB011_ckpt_11993214_i10961.trc
Fri May 20 15:00:23 2016
Trace dumping is performing id=[cdmp_20160520150023]
Fri May 20 15:00:23 2016
ORA-00227: corrupt block detected in control file: (block 1, # blocks 1)
ORA-00202: control file: '+DATA/db01/controlfile/current.297.912339151'
Fri May 20 15:00:23 2016
ORA-205 signalled during: ALTER DATABASE   MOUNT...
Fri May 20 15:01:04 2016
Sweep [inc][10961]: completed
Sweep [inc2][10961]: completed


由以上信息可知控制文件current.297.912339151损坏

查看数据库控制文件情况

SQL> show parameter control

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time        integer     7
control_files                        string      +DATA/db01/controlfile/current
                                                 .297.912339151, +DATA/db01/con
                                                 trolfile/current.296.912339151
control_management_pack_access       string      DIAGNOSTIC+TUNING



解决:

数据库有两个控制文件,可以将损坏的删除,然后从好的再拷贝一份

ASMCMD> cp Current.296.912339151 control01.ctl  

由于新的控制文件名字改变了,所以需要修改spfile文件中*.control_files参数

备注:
ASMCMD> cp Current.296.912339151 Current.297.912339151  --在拷贝到ASM上的时候不要指定文件后面的数值,这是Oracle的ASM用来进行标识的信息。
copying +data/db01/CONTROLFILE/Current.296.912339151 -> +data/db01/CONTROLFILE/Current.297.912339151
ASMCMD-08016: copy source->'+data/db01/CONTROLFILE/Current.296.912339151' and target->'+data/db01/CONTROLFILE/Current.297.912339151' failed
ORA-19505: failed to identify file "+data/db01/CONTROLFILE/Current.297.912339151"
ORA-17502: ksfdcre:4 Failed to create file +data/db01/CONTROLFILE/Current.297.912339151
ORA-15046: ASM file name '+data/db01/CONTROLFILE/Current.297.912339151' is not in single-file creation form
ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 397
ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute)

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/30373263/viewspace-2103845/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2015-07-25

  • 博文量
    96
  • 访问量
    259430