数据库启动报ORA-00205: error in identifying control file, check alert log for...

jiawang

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

SQL>