ORA-01618: redo thread 2 is not enabled - cannot mount & ORA-1613 Error
Recently, I installed a new RAC database on a local enviroment. The oracle version is 11.0.2.3. Operating system is OEL 6. When I install, I put all the database files into only one ASM disk group called data. The redundency level is normal which means only about 1/2 of the total space can be used. I assgined about 4G space to the group which turn out to be not enough.
During install the RAC, I choose to create a demo database. This action exhausted the disk group space. So one of the instance , orcl2 on the racnode2 do not have sufficient space to create the redo group. So the database can not be started.
I try to start instance 2 and hit the error like redo thread 2 is not enabled. can not mount instance.
OK. We know that thread and the instance is 1 map 1. One instance has 1 thread. So the thread 2 means intance 2 have a thread but not enabled. So I run below command on instance to enable it.
SQL> Alter Database Enable Public Thread 2; Alter Database Enable Public Thread 2 * ERROR at line 1: ORA-01613: instance UNNAMED_INSTANCE_2 (thread 2) only has 0 logs - at least 2 logs required to enable.
It shows the thread 2 do not have redo log group. Ok lets see the redo log infor.
SQL> select * from v$log 2 / GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME ---------- ---------- ---------- ---------- ---------- ---------- --- -------- ------------- --------- ------------ --------- 1 1 11 52428800 512 1 NO INACTIVE 955179 08-JUN-13 968365 08-JUN-13 2 1 12 52428800 512 1 NO CURRENT 968365 08-JUN-13 2.8147E+14
Oh, we have thread 1. The thread 2 need to be add some redo group.
Let`s do below to add the redo group.
SQL> alter database add logfile thread 2 group 3; alter database add logfile thread 2 group 3 * ERROR at line 1: ORA-00301: error in adding log file '+DATA' - file cannot be created ORA-17502: ksfdcre:4 Failed to create file +DATA ORA-15041: diskgroup "DATA" space exhausted
Oh, yes no space on it. So add some space.
run the asmca to add another disk. here we wont show how to do it.
after add the space we try to add redo group to thread 2.
SQL> alter database add logfile thread 2 group 3; Database altered. SQL> alter database add logfile thread 2 group 4; Database altered. SQL> Alter Database Enable Public Thread 2; Database altered.
Seems the thread is ok now. Then start the instance , no issues this time.