ORA-01618: redo thread 2 is not enabled – cannot mount

dbtut

5 years ago

When opening the database, if there is a redolog group that is not enabled for the corresponding thread, it gives an error as ORA-01618.

To overcome this problem, you need to activate the redo log group created for that thread.

The redo log group can be activated with the following command.

SQL> alter database enable public thread 2;

1	SQL> alter database enable public thread 2;