Oracle Error ORA-01197: thread string only contains one log

Oracle Error Message

ORA-01197: thread string only contains one log

Reason for the Error

During CREATE CONTROLFILE all threads represented in the logs must be represented by at least two logs. A “last log” and a second log. The named thread does not contain two such logs.

Solution

Either find more logs from the named thread. Or use the RESETLOGS option to CREATE CONTROLFILE.