标题: 数据库启动报ORA-00205: error in identifying control file, check alert log for... [打印本页] 作者: jiawang 时间: 2018-8-28 14:32 标题: 数据库启动报ORA-00205: error in identifying control file, check alert log for... os版本:rhel 7.3
DB版本：12.2.0.1
问题现象：
[oracle@localhost bin]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Tue Aug 28 14:07:28 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup;
ORACLE instance started.
Total System Global Area 1543503872 bytes
Fixed Size 8621040 bytes
Variable Size 989856784 bytes
Database Buffers 536870912 bytes
Redo Buffers 8155136 bytes
ORA-00205: error in identifying control file, check alert log for more info
查看alter日志：
[root@localhost ~]# cd /u01/app/diag/rdbms/orcl/orcl/trace
[root@localhost trace]# ls *al*
alert_orcl.log
[root@localhost trace]# tail -300 alert_orcl.log
2018-08-28T14:07:38.902713+08:00
ALTER DATABASE MOUNT
2018-08-28T14:07:39.325443+08:00
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/fast_recovery_area/orcl/control02.ctl'
ORA-27086: unable to lock file - already in use
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: 8
Additional information: 71054
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oradata/orcl/control01.ctl'
ORA-27086: unable to lock file - already in use
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: 8
Additional information: 71054
报错原因：服务器异常崩溃导致的
解决办法：找到$ORACLE_HOME/dbs下的lkORCL锁文件删除，再重启数据库。
[oracle@localhost dbs]$ cd /u01/app/product/12.2.0/db_1/dbs
[oracle@localhost dbs]$ ll
total 28
-rw-rw----. 1 oracle dba 1544 Aug 28 14:07 hc_orcl.dat
-rw-r--r--. 1 oracle dba 3079 May 15 2015 init.ora
-rw-r-----. 1 oracle dba 558 Aug 28 13:18 initorcl.ora
-rw-r-----. 1 oracle dba 24 Aug 28 11:21 lkORCL
-rw-r-----. 1 oracle dba 4608 Aug 28 11:20 orapworcl
-rw-r-----. 1 oracle dba 3584 Aug 28 14:07 spfileorcl.ora
[oracle@localhost dbs]$ rm lkORCL
[oracle@localhost dbs]$
[oracle@localhost bin]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Tue Aug 28 14:16:46 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production