ORA-01172: recovery of thread string stuck at block string
of file string



ORA-01172: recovery of thread string stuck at block string of file string..

Answer / guest

Cause: Crash recovery or instance recovery could not apply a
change to a block because it was not the next change. This
can happen if the block was corrupted and then repaired
during recovery.

Action: Do a RECOVER DATAFILE for the file containing the
block. If this does not resolve the problem then restore the
file from a backup and recover it.

Please add more information about this Error

Is This Answer Correct ?    8 Yes 3 No

Post New Answer

More Oracle Errors Interview Questions

ORA-35578: (SQLOUT11) SQL cursor 'number' cannot be used with CURRENT OF <cursor name> syntax

1 Answers  


ORA-08230: smscre: failed to allocate SGA

1 Answers  


ORA-02487: Error in converting trace data

1 Answers  


ORA-01881: timezone region id number is invalid

1 Answers  


ORA-16546: missing or invalid piece

1 Answers  






ORA-25183: index-organized table top index segment is in a different tablespace

1 Answers  


ORA-26503: internal RepAPI operation failure on object string.string

1 Answers  


ORA-03134: Connections to this server version are no longer supported.

1 Answers  


ORA-13367: wrong orientation for interior/exterior rings

1 Answers  


KUP-04007: end of file reached

1 Answers  


ORA-30751: cannot disable column string from storing objects of type string.string

1 Answers  


PCC-00012: Not in a declare section at line number in file string

1 Answers  


Categories