Recovering All Corrupted Blocks in Oracle

Recovering All Corrupted Blocks in Oracle

You can recover all corrupted blocks with a single command in Rman. All database blocks corruptions are reported to V$DATABASE_BLOCK_CORRUPTION.

To recover all the data blocks who are listed in above view. Follow these steps:

Run Rman

After connected to Rman with Connect Target command type the following command:

Recover Corruption List;

All data block will be recovered and will be removed from the above mentioned view.