Oracle DBA, How To, Error, Cause and Action

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.

No comments:

Post a Comment

Thanks for your comment.