Oracle Solution for Error ora-01172

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

What triggered the Error:

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.

What should we do to fix it:

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.