ORA-01618: redo thread 2 is not enabled - cannot mount

检查发现二节点实例没有在运行

[oracle@rac1 ~]$ srvctl status database -d rac -f
Instance rac1 is running on node rac1
Instance rac2 is not running on node rac2

---

查看集群资源状态
[grid@rac2 ~]$ crsctl stat res -t

发现节点二的数据库实例没有启动

启动第二节点的数据库实例
[grid@rac2 ~]$ srvctl start instance -d rac -i rac2

PRCR-1013 : Failed to start resource ora.rac.db
PRCR-1064 : Failed to start resource ora.rac.db on node rac2
CRS-5017: The resource action "ora.rac.db start" encountered the following error: 
ORA-01618: redo thread 2 is not enabled - cannot mount
. For details refer to "(:CLSN00107:)" in  
"/u01/app/11.2.0/grid/log/rac2/agent/crsd/oraagent_oracle/oraagent_oracle.log".
CRS-2674: Start of 'ora.rac.db' on 'rac2' failed

进入第二节点手工启动数据库实例

[oracle@rac2 ~]$ sqlplus / as sysdba;

SQL*Plus: Release 11.2.0.3.0 Production on Fri Aug 26 01:02:26 2016

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

Connected to an idle instance.

SYS@RAC2> startup
ORACLE instance started.

Total System Global Area  584568832 bytes
Fixed Size                  2230552 bytes
Variable Size             247465704 bytes
Database Buffers          331350016 bytes
Redo Buffers                3522560 bytes
**ORA-01618: redo thread 2 is not enabled - cannot mount**
#报错，二节点的redo不是enabled的

在节点一查看redo日志情况

[oracle@rac1 ~]$ sqlplus / as sysdba;

SQL*Plus: Release 11.2.0.3.0 Production on Fri Aug 26 01:04:33 2016

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SYS@RAC1> select * from v$log;

发现没有第二节点的redo，为第二节点实例添加redo，并置为enabled(每个节点的redo至少为两成员)
如果二节点中redo有两成员，则只需要将其置为enabled(alter database enable thread 2;)

SYS@RAC1> alter database add logfile thread 2 '+DATA'; 

Database altered.

SYS@RAC1> alter database add logfile thread 2 '+DATA';

Database altered.

SYS@RAC1> alter database enable thread 2;

Database altered.

在第二节点开启数据库实例

SYS@RAC2> startup force
ORACLE instance started.

Total System Global Area  584568832 bytes
Fixed Size                  2230552 bytes
Variable Size             247465704 bytes
Database Buffers          331350016 bytes
Redo Buffers                3522560 bytes
Database mounted.
Database opened.

数据库实例成功开启，完成
———end———–