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

       最近换了块固态盘，顺便给系统重新安装了次，弄个集群环境，在安装的过程中，由于本人的眼误导致在设置redo log 大小的时候出现下面情况：

在安装的过程中报了几个错误，本人一致忽略。完成的时候去检查。

 select name,state,type,total_mb,free_mb,usable_file_mb,offline_disks from v$asm_diskgroup;
NAME			       STATE	   TYPE     TOTAL_MB	FREE_MB USABLE_FILE_MB OFFLINE_DISKS
------------------------------ ----------- ------ ---------- ---------- -------------- -------------
DATA			       MOUNTED	   EXTERN      20473	  17142 	 17142		   0

[oracle@asmlib1 ~]$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.3.0 Production on Sat Aug 9 08:54:30 2014


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


SQL> select group#,sequence#,bytes,members,status from v$log;


    GROUP#  SEQUENCE#      BYTES    MEMBERS STATUS
---------- ---------- ---------- ---------- ----------------
     1     16  134217728      2 CURRENT
     2     14  134217728      2 INACTIVE
     5     15  134217728      2 INACTIVE


SQL> select  GROUP# , THREAD#, MEMBERS , STATUS      from v$log;


    GROUP#    THREAD#    MEMBERS STATUS
---------- ---------- ---------- ----------------
     1      1          2 CURRENT
     2      1          2 INACTIVE
     5      1          2 INACTIVE


SQL> alter database add logfile THREAD 2 group 3 ('+DATA') size 128m;


Database altered.


SQL> alter database add logfile THREAD 2 group 4 ('+DATA') size 128m;


Database altered.


SQL> alter database add logfile THREAD 2 group 6 ('+DATA') size 128m;


Database altered.


SQL> select group#,sequence#,bytes,members,status from v$log;


    GROUP#  SEQUENCE#      BYTES    MEMBERS STATUS
---------- ---------- ---------- ---------- ----------------
     1     16  134217728      2 CURRENT
     2     14  134217728      2 INACTIVE
     3      0  134217728      1 UNUSED
     4      0  134217728      1 UNUSED
     5     15  134217728      2 INACTIVE
     6      0  134217728      1 UNUSED


6 rows selected.


SQL> select  GROUP# , THREAD#, MEMBERS , STATUS      from v$log;


    GROUP#    THREAD#    MEMBERS STATUS
---------- ---------- ---------- ----------------
     1      1          2 CURRENT
     2      1          2 INACTIVE
     3      2          1 UNUSED
     4      2          1 UNUSED
     5      1          2 INACTIVE
     6      2          1 UNUSED


6 rows selected.


SQL>  alter system switch logfile;


System altered.


SQL> /


System altered.


SQL> /
/


System altered.


SQL> 
System altered.


SQL> /


System altered.


SQL> /


System altered.


SQL>  alter system checkpoint;


System altered.


SQL> select group#,sequence#,bytes,members,status from v$log;


    GROUP#  SEQUENCE#      BYTES    MEMBERS STATUS
---------- ---------- ---------- ---------- ----------------
     1     22  134217728      2 CURRENT
     2     20  134217728      2 INACTIVE
     3      0  134217728      1 UNUSED
     4      0  134217728      1 UNUSED
     5     21  134217728      2 INACTIVE
     6      0  134217728      1 UNUSED


6 rows selected.


SQL> 


[oracle@asmlib2 ~]$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.3.0 Production on Sat Aug 9 08:59:15 2014


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


Connected to an idle instance.


SQL> startup
ORACLE instance started.


Total System Global Area  839282688 bytes
Fixed Size          2233000 bytes
Variable Size         650120536 bytes
Database Buffers      180355072 bytes
Redo Buffers            6574080 bytes
<span style="color:#ff0000;">ORA-01618: redo thread 2 is not enabled - cannot mount</span>
SQL> select status from v$instance;


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

看下ora-01618的错误说明

[oracle@asmlib2 ~]$ oerr ora 01618
01618, 00000, "redo thread %s is not enabled - cannot mount"
// *Cause:  The INIT.ORA parameter "thread" requests a thread that is not
//          enabled. A thread must be enabled before it can be mounted.
// *Action: Shutdown the instance, change the INIT.ORA parameter and startup
//          mounting a different thread. If the database is open in another
//          instance then the thread may be enabled.

启用（节点一）

SQL> alter database <span style="color:#ff0000;">enable</span> thread 2;

Database altered.

节点2上去打开数据库

SQL> alter database mount;

Database altered.

SQL> alter database open;

Database altered.

SQL>  select group#,sequence#,bytes,members,status from v$log;


    GROUP#  SEQUENCE#<span style="white-space:pre">	</span>   BYTES    MEMBERS STATUS
---------- ---------- ---------- ---------- ----------------
<span style="white-space:pre">	</span> 1<span style="white-space:pre">	</span>   34  134217728<span style="white-space:pre">	</span>  2 CURRENT
<span style="white-space:pre">	</span> 2<span style="white-space:pre">	</span>   32  134217728<span style="white-space:pre">	</span>  2 INACTIVE
<span style="white-space:pre">	</span> 3<span style="white-space:pre">	</span>    4  134217728<span style="white-space:pre">	</span>  1 INACTIVE
<span style="white-space:pre">	</span> 4<span style="white-space:pre">	</span>    5  134217728<span style="white-space:pre">	</span>  1 CURRENT
<span style="white-space:pre">	</span> 5<span style="white-space:pre">	</span>   33  134217728<span style="white-space:pre">	</span>  2 INACTIVE
<span style="white-space:pre">	</span> 6<span style="white-space:pre">	</span>    3  134217728<span style="white-space:pre">	</span>  1 INACTIVE


6 rows selected.