ORA-00333: redo log read error block XXXX count XXXX

For the original Article Please visit: DBALAND

I encountered this Oracle error when connecting to my database after my laptop lost power and subsequently had some severe Blue Screen issues.

According to Oracle, ORA-00333 is caused by an IO error while reading the log described in the accompanying error. The resolution is to restore accessibility to the file, or get another copy of the file.

This certainly ties in with my scenario.

The steps found to recover from this are fine for a test or development environment where data loss is not an issue. You wouldn’t want to follow these for a production environment though as you could well lose data!

So, what does it look like in practise?