Showing posts with label ORA-01172: recovery of thread string stuck at block string of file string. Show all posts
Showing posts with label ORA-01172: recovery of thread string stuck at block string of file string. Show all posts

Wednesday, 11 January 2012

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

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.