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

ORA-24064: propagation for QUEUE string and DESTINATION string already enabled

1 Answers  


ORA-13043: failed to read metadata from the <layer>_SDOLAYER table

1 Answers  


RMAN-06008: connected to recovery catalog database

1 Answers  


RMAN-04006: error from auxiliary database: string

1 Answers  


LFI-00133: Trying to create file string that already exists.

1 Answers  






AMD-00139: level names parameter not valid

1 Answers  


NNL-00975: Desired data type: string

1 Answers  


PLS-00461: mismatch REPEATABLE information between specification and body of 'string'

1 Answers  


NZE-28864: SSL connection closed gracefully

1 Answers  


DRG-11828: Conflict

1 Answers  


NID-00110: Cannot use REVERT and specify a database name at the same time

1 Answers  


ORA-12672: Database logon failure

1 Answers  


Categories