How to fix the Oracle error ORA-01380: Instance string (thread string) has less than two string block size log files?

In this post, you’ll learn more about the Oracle ErrorORA-01380: Instance string (thread string) has less than two string block size log files with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-01380: Instance string (thread string) has less than two string block size log files

Reason for the Error ORA-01380: Instance string (thread string) has less than two string block size log files

One of the following occurred: (1) An attempt was made to switch to specified block size logs for all threads. (2) An attemp was made to open a thread.

How to fix the Error ORA-01380: Instance string (thread string) has less than two string block size log files ?

You can fix this error in Oracle by following the below steps

Add log files to the thread that signals error, and try again.