How to fix the Oracle error ORA-38858: cannot mark redo thread string as enabled?

In this post, you’ll learn more about the Oracle ErrorORA-38858: cannot mark redo thread string as enabled with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-38858: cannot mark redo thread string as enabled

Reason for the Error ORA-38858: cannot mark redo thread string as enabled

The open resetlogs or standby activation operation failed because it needs to mark a redo thread as enabled. However, the control file was recreated with a MAXINSTANCES value smaller than the thread number of the redo thread.

How to fix the Error ORA-38858: cannot mark redo thread string as enabled ?

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

Recreate the control file with a larger MAXINSTANCES value.