How to fix the error ORA-00391: All threads must switch to new log format at the same time?

In this post, you’ll learn more about the Oracle ErrorORA-00391: All threads must switch to new log format at the same time with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-00391: All threads must switch to new log format at the same time

Reason for the Error ORA-00391: All threads must switch to new log format at the same time

An attempt to switch the current log of a single thread is not allowed because the compatiblity requirements force a new log format version number. When changing log formats, all threads must switch to the new format at the same time.

How to fix the Error ORA-00391: All threads must switch to new log format at the same time ?

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

Open the database to cause the coordinated log switch. If that is not possible then return to the same software version and compatibility setting last used to open the database.