标题: ORA-01618: redo thread 2 is not enabled - cannot mount [打印本页] 作者: 郑全 时间: 2020-9-24 00:14 标题: 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
作者: 郑全 时间: 2020-9-24 00:53
发现二号节点没有联机日志组，在一号节点，为二号节点增加联机日志文件：
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;