首页 > 开发 > 综合 > 正文

由于节点2的redo出问题,导致节点2实例不能mount。

2024-07-21 02:52:07
字体:
来源:转载
供稿:网友
由于节点2的redo出问题,导致节点2实例不能mount。SQL> alter database mount;alter database mount*ERROR at line 1:ORA-01618: redo thread 2 is not enabled - cannot mount错误说明:[Oracle@rac2 bin]$ oerr ora 0161801618, 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 add logfile thread 2 ('+DATA1') size .....;Database altered.SQL> alter database add logfile thread 2 ('+DATA1') size .....;Database altered.SQL> alter database enable thread 2;Database altered.然后打开节点2SQL> alter database mount;Database altered.SQL> alter database open;Database altered.
发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表