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.
1 | SQL> alter database enable public thread 2; |