Oracle 11g ORA-00205：识别控制文件时出错，检查警报日志以获取更多信息
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/29430793/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Oracle 11g ORA-00205: error in identifying control file, check alert log for more info
提问by Mac
I've been having this problem for more than 4 days, I've tried to fix it but it persists!
我已经遇到这个问题超过 4 天了，我试图解决它，但它仍然存在！
The content of the log file $ORACLE_HOME/log/diag/rdbms/<sid>/<SID>/trace/alert_SID.logis:
日志文件的内容$ORACLE_HOME/log/diag/rdbms/<sid>/<SID>/trace/alert_SID.log是：
SQL > ALTER DATABASE MOUNT;
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/intradayv3/position/control1/POSCTL1.ctl'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
ORA-205 signalled during: ALTER DATABASE MOUNT...
Fri Apr 03 12:24:44 2015
Checker run found 1 new persistent data failures
ORA-00210：无法打开指定的控制文件
ORA-00202：控制文件：'/intradayv3
/position/control1/ POSCTL1.ctl' ORA-27037：无法获得文件状态
IBM AIX RISC System/6000 错误：2：没有这样的文件或目录
附加信息：3
ORA-205 在以下期间发出信号：ALTER DATABASE MOUNT...
Fri Apr 03 12:24:44 2015
Checker run found 1 new persistent data failures
回答by ibre5041
check init.ora file(spfile.ora) and check ALL controlfiles listed here. There should be at least three of them. Then exclude the missiin one form the list and try to start the database. You should also check sizes and dates of all control files.
检查 init.ora 文件（spfile.ora）并检查此处列出的所有控制文件。至少应该有三个。然后从列表中排除该任务并尝试启动数据库。您还应该检查所有控制文件的大小和日期。
Your goal is to find at least one usable copy of controlfile to start the database.
您的目标是找到至少一个可用的控制文件副本来启动数据库。
create pfile='/tmp/init.ora' from spfile;
then edit this init.ora file.
然后编辑这个 init.ora 文件。
startup database pfile='/tmp/init.ora' nomount;
alter database mount;
alter database open;
You have to sync init.ora with valid controlfiles you have on the disk. Check their permissions, sizes, modification dates.
您必须将 init.ora 与磁盘上的有效控制文件同步。检查他们的权限、大小、修改日期。
