故障:启动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/
,如需转载,请注明出处,否则将追究法律责任。