For corrupted blocks, we can use block media recovery to recover corrupt datablocks with remain the datafile online. If we don’t have backup available, we can recreate the table by skip the corrupted blocks.
Here are steps for block media recover.
Step1. Find out the bad blocks file# and block#
SQL> select * from V$DATABASE_BLOCK_CORRUPTION;
will show all recorded [...]
Filed under: Backup and Recovery | Leave a Comment »
