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

This error was reported when two linux Red Hat 4 hosts were used to build RAC (10 Gb). The problem was solved later.

I just set up RAC, can open Node 1, open Node 2, this error is reported, view the log of Node 1 as follows:

SQL>Select * from v $ Log;// Logs with only Node 1 but without Node 2

GROUP # THREAD # SEQUENCE # bytes members arc status FIRST_CHANGE # FIRST_TIM
-------------------------------------------------------------------------------------------
1 1 2 52428800 2 no inactive 473022 02-APR-12
2 1 3 52428800 2 no current 500037 02-APR-12

Create a log group for node 2 on node 1

SQL>Alter database add logfile thread 2
2('+ Dg1', '+ recovery') size 10 m;

Database altered.

Create a group of logs again, and there are two groups of logs in the same way as node 1.

SQL>Alter database add logfile thread 2
2('+ Dg1', '+ recovery') size 10 m;

Database altered.

After adding the database, I opened the database on node 2, but still reported this error, and the following operation was executed on node 1.

SQL>Alter database enable thread 2;

Database altered.

SQL>

For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12