You are here: Home // Oracle 11g // ORA-01197: thread string only contains one log

ORA-01197: thread string only contains one log

Cause: 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. See the solution below.

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

Database version: Oracle 11g Release 2 (11.2)

Tags: ,

Leave a Reply

Copyright © 2009 Oracle Error Codes Database. All rights reserved.
Powered by WordPress.
Promotes: odchudzanie meble do łazienek kalibracja kolorów randki angielski dla dzieci Lublin