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

liiinuuux發表於2014-01-27
thread
現象：
RAC建庫的時候，由於節點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 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 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.

然後開啟節點2
SQL> alter database mount;

Database altered.

SQL> alter database open;

Database altered.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26239116/viewspace-1075976/，如需轉載，請註明出處，否則將追究法律責任。

相關文章