Oracle DB Error ORA-01216 thread string is expected to be disabled after CREATE CONTROLFILE

The following is the cause of this error:

A thread that was given during CREATE CONTROLFILE is enabled, but the datafiles indicate that it should be disabled. This is probably because the logs supplied to the CREATE CONTROLFILE are old (from before the disabling of the thread).

Action you can take to resolve this issue: This thread is not required to run the database. The CREATE CONTROLFILE statement can be reissued without the problem thread, and, if desired, the thread can be re-created after the database is open.

Tags: Database, Education, Software

Related