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

我的环境是Sun solairs10 ,安装 11.2.0.3 RAC遇到的错误。

在dbca中遇到 ora-00904  ora-01613  ora-01618

基本都是这个错误，见下图：

查看安装后的状态

--解决：

1.尝试在第2节点 startup

$ id
uid=1100(oracle) gid=1000(oinstall)
$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Jul 8 15:07:34 2016

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1.0225E+10 bytes
Fixed Size                  2168160 bytes
Variable Size            1644169888 bytes
Database Buffers         8522825728 bytes
Redo Buffers               55697408 bytes
ORA-01618: redo thread 2 is not enabled - cannot mount


SQL> select status from v$instance;

STATUS
------------
STARTED

SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-01618: redo thread 2 is not enabled - cannot mount

--2. 没有thread2. 所以这里在节点1 ，增加日志thread2，2组以上。

SQL> set lines 200
SQL> select * from v$Log; 

    GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIME   NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------ ------------ ------------
        11          1          4 1073741824        512          2 NO  CURRENT                 827423 08-JUL-16      2.8147E+14
        12          1          2 1073741824        512          2 NO  INACTIVE                415498 08-JUL-16          684105 08-JUL-16
        13          1          3 1073741824        512          2 NO  INACTIVE                684105 08-JUL-16          827423 08-JUL-16

SQL> alter database add logfile thread 2('+DATA','+DATA') size 512m;

Database altered.

SQL> alter database add logfile thread 2('+DATA','+DATA') size 512m;

Database altered.

SQL> alter database enable thread 2;

Database altered.

SQL> 

--3. 现在在节点2 ，mount

SQL> set lines 200
SQL>  select * from v$Log;                                          
 select * from v$Log
               *
ERROR at line 1:
ORA-01507: database not mounted


SQL> alter database mount;

Database altered.

SQL> 

--4. 在执行open

SQL> alter database open;

Database altered.

--5.查看2个节点的状态。