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

郑全

启动一个RAC节点，就报以下错误：

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

郑全

发现二号节点没有联机日志组，在一号节点，为二号节点增加联机日志文件：
alter database add logfile thread 2 group 21 ('/u02/app/oracle/oradata/ebsdb/u01/ebsdata/group_21a.log','/u02/app/oracle/oradata/ebsdb/u01/ebsdata/group_21b.log') size 1g;
alter database add logfile thread 2 group 22 ('/u02/app/oracle/oradata/ebsdb/u01/ebsdata/group_22a.log','/u02/app/oracle/oradata/ebsdb/u01/ebsdata/group_22b.log') size 1g;
alter database add logfile thread 2 group 23 ('/u02/app/oracle/oradata/ebsdb/u01/ebsdata/group_23a.log','/u02/app/oracle/oradata/ebsdb/u01/ebsdata/group_23b.log') size 1g;
alter database add logfile thread 2 group 24 ('/u02/app/oracle/oradata/ebsdb/u01/ebsdata/group_24a.log','/u02/app/oracle/oradata/ebsdb/u01/ebsdata/group_24b.log') size 1g;
alter database add logfile thread 2 group 25 ('/u02/app/oracle/oradata/ebsdb/u01/ebsdata/group_25a.log','/u02/app/oracle/oradata/ebsdb/u01/ebsdata/group_25b.log') size 1g;
alter database add logfile thread 2 group 26 ('/u02/app/oracle/oradata/ebsdb/u01/ebsdata/group_26a.log','/u02/app/oracle/oradata/ebsdb/u01/ebsdata/group_26b.log') size 1g;

之后，启用二号现成即可。

alter database enable thread 2;

再去启动二号数据库。