Recovering All Corrupted Blocks in OracleYou 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:
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.