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

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

[oracle@rac1 ~]$ srvctl status database -d rac -fInstance rac1 is running on node rac1Instance 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.dbPRCR-1064 : Failed to start resource ora.rac.db on node rac2CRS-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 2016Copyright (c) 1982, 2011, Oracle.  All rights reserved.Connected to an idle instance.SYS@RAC2> startupORACLE instance started.Total System Global Area  584568832 bytesFixed Size                  2230552 bytesVariable Size             247465704 bytesDatabase Buffers          331350016 bytesRedo 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 2016Copyright (c) 1982, 2011, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Data Mining and Real Application Testing optionsSYS@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 forceORACLE instance started.Total System Global Area  584568832 bytesFixed Size                  2230552 bytesVariable Size             247465704 bytesDatabase Buffers          331350016 bytesRedo Buffers                3522560 bytesDatabase mounted.Database opened.

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