ORA-01613: instance UNNAMED_INSTANCE_3 (thread 3) only has 0 logs – at least 2 logs required to enable.

I got ” ORA-01613: instance UNNAMED_INSTANCE_3 (thread 3) only has 0 logs – at least 2 logs required to enable. ” error in the Oracle database.

ORA-01613: instance UNNAMED_INSTANCE_3 (thread 3) only has 0 logs – at least 2 logs required to enable.

Details of error are as follows.

SQL> alter database enable public thread 3;
alter database enable public thread 3
*
ERROR at line 1:
ORA-01613: instance UNNAMED_INSTANCE_3 (thread 3) only has 0 logs - at least 2
logs required to enable.


SQL> alter database enable public thread 4;
alter database enable public thread 4
*
ERROR at line 1:
ORA-01613: instance UNNAMED_INSTANCE_4 (thread 4) only has 0 logs - at least 2
logs required to enable.


SQL>

instance UNNAMED_INSTANCE_3 (thread 3) only has 0 logs – at least 2 logs required to enable.

This ORA-01613 errors are related with the missing logfiles of new added Oracle nodes.

I got ORA-01613 error, because logfiles for the thread 3 and 4 should be added as follows.

SQL> alter database add logfile thread 3 group 11;

Database altered.

SQL> alter database add logfile thread 3 group 12; 

Database altered. 

SQL> 

SQL> alter database add logfile thread 4 group 13;

Database altered.

SQL>

SQL> alter database add logfile thread 4 group 14; 

Database altered. 

SQL>

Now you can try to enable thread 3 and 4 as follows.

SQL> alter database enable public thread 3;

Database altered.

SQL> alter database enable public thread 4;

Database altered.

SQL>

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/