ORA-00205

ORA-00205: error in identifying control file, check alert log for more info

翻译为：控制文件的错误，请检查警报日志中获得更多信息

通过：/oracle/diag/rdbms/alert/log.xml文件中找出实例启动日志

[oracle@oracle ~]$ cd /oracle/app/diag/rdbms/
[oracle@oracle rdbms]$ ls
orcl  prod
[oracle@oracle rdbms]$ cd prod
[oracle@oracle prod]$ ls
i_1.mif  prod
[oracle@oracle prod]$ cd prod
[oracle@oracle prod]$ ls
alert  cdump  hm  incident  incpkg  ir  lck  metadata  metadata_dgif  metadata_pv  stage  sweep  trace
[oracle@oracle prod]$ cd alert
[oracle@oracle alert]$ ls
log.xml
[oracle@oracle alert]$ vi log.xml

里面会有如下信息：

ORA-00210: cannot open the specified control file
ORA-00202: control file: '/opt/oracle/oradata/ora11g/control03.ctl'
ORA-27048: skgfifi: file header information is invalid
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/opt/oracle/oradata/ora11g/control02.ctl'
ORA-27048: skgfifi: file header information is invalid

里面有提示control02.ctl与control03.ctl两个控制文件错误

再找到/opt/oracle/diag/rdbms/ora11g/ora11g/trace/ora11g_m000_13970.trc跟踪文件

里面有如下信息：

kcidr_process_controlfile_error:
 IO Check was called but no error was found
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/opt/oracle/oradata/ora11g/control03.ctl'
ORA-27048: skgfifi: file header information is invalid
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/opt/oracle/oradata/ora11g/control02.ctl'
ORA-27048: skgfifi: file header information is invalid

里面提示无法正常打开两个控制文件。

直接拷贝control01.ctl文件进行覆盖control02.ctl与control03.ctl文件

[oracle@oracle prod]$ cp control01.ctl /oracle/app/recovery_area/orcl/control02.ctl
[oracle@oracle prod]$ cp control01.ctl /oracle/app/recovery_area/orcl/control03.ctl
[oracle@oracle prod]$ cd /oracle/app/recovery_area/orcl/
[oracle@oracle orcl]$ ls
control02.ctl  control03.ctl
[oracle@oracle orcl]$ cd /oracle/app/oradata/prod/
[oracle@oracle prod]$ ls
control01.ctl  control03.ctl  disk2  disk4  redo01.log  redo03.log    system01.dbf  undotbs01.dbf
control02.ctl  disk1          disk3  disk5  redo02.log  sysaux01.dbf  temp01.dbf    users01.dbf
[oracle@oracle prod]$ cp control01.ctl /oracle/app/recovery_area/orcl/control01.ctl
[oracle@oracle prod]$ cd /oracle/app/recovery_area/orcl/
[oracle@oracle orcl]$ ls
control01.ctl  control02.ctl  control03.ctl

[oracle@oracle orcl]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 18 17:12:39 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create pfile from spfile;

File created.

SQL> shutdown immediate 
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> startup  pfile='/oracle/app/product/11.2.0/db_1/dbs/initprod.ora'; 
ORACLE instance started.

Total System Global Area  534462464 bytes
Fixed Size          2254952 bytes
Variable Size         444598168 bytes
Database Buffers       83886080 bytes
Redo Buffers            3723264 bytes

Database mounted.
Database opened.

转自[http://blog.csdn.net/hey_a_hao/article/details/6955186]