ORA-01197: thread string only contains one log



ORA-01197: thread string only contains one log..

Answer / guest

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.

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NID-00125: Database should have no disabled datafiles

1 Answers  


RMAN-20029: cannot make a snapshot controlfile

1 Answers  


ORA-32128: setDataBuffer called after fetch has started

1 Answers  


ORA-00027: cannot kill current session

1 Answers  


TNS-03601: Failed in route information collection

1 Answers  






ORA-09943: Allocation of memory for password list component failed.

1 Answers  


ORA-10916: TABLESPACE GROUP already specified

1 Answers  


PLS-00581: inheritance is not supported for opaque types

1 Answers  


ORA-19662: archived log thread string sequence string could not be verified

1 Answers  


ORA-06743: TLI Driver: cannot alloc t_bind

1 Answers  


ORA-09987: unable to attach to SGA in READ-ONLY mode

1 Answers  


ORA-31077: invalid attribute "string" specified

1 Answers  


Categories