oracle指定控制文件启动 ORA-00205: error in identifying control file, check alert log for more info

SQL> startup
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size 2220200 bytes
Variable Size 708841304 bytes
Database Buffers 352321536 bytes
Redo Buffers 5554176 bytes
ORA-00205: error in identifying control file, check alert log for more info

 

查看日志发现 启动的时候指定的控制文件指定错了，更改oracle 的启动控制文件

tail -f /u01/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log  

 

. 查看告警日志
这个问题通常与控制文件有关。请检查Oracle的告警日志（通常位于[Oracle Home]/diag/rdbms/[db_name]/[Instance_name]/trace目录下，文件名通常是alert_[Instance_name].log），以获取更多信息。

 

 

 

SQL> SELECT name FROM v$controlfile;

no rows selected

SQL> ALTER SYSTEM SET control_files = '/u01/app/oracle/oradata/orcl/control01.ctl' SCOPE=SPFILE;

System altered.

ORACLE instance shut down.

SQL> startup
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size 2220200 bytes
Variable Size 708841304 bytes
Database Buffers 352321536 bytes
Redo Buffers 5554176 bytes
Database mounted.
Database opened.