I recently released a tool in a shell script that aims to help with corrupted blocks.
Of course it can only help with the recovery process itself, as it will still need a good backup of the database.
To identify corrupted blocks and recover them is both critical and time consuming. In addition, it’s not always clear what to do in such situations, for that reason, I’ve created the tool to give administrators a starting point when they face a database corruption.
The tool help with the following:
1. Full database consistency check
2. Identify affected objects
3. Catalog backups with RMAN (required for next step)
4. Execute block level recovery to clean up the database
So the main idea here is to facilitate the process of consistency check and recovery. You can find the tool in the KBA 2205309 and as of now there’s only Linux/Unix version.
Any comments are welcome.