Oracle Solution for Error ora-01197

Solution for Oracle Error ORA-01197

ORA-01197: thread string only contains one log

What triggered 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.

What should we do to fix it:

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