Block Media Recovery with RMAN

In this article you identify the blocks that require recovery and then use any available backup to perform the restore and recovery of these blocks.

First create user and grant to it.

 Then create table and put the transactions.

Now go to Rman   and take a backup.                                   

 

And connect to user for seeing block header number.

Okay ill corrupt some datafile to example this.

Now lets look at our table

As you see the table was corrupted

Now lets fix this error.

firstly flush the buffer                                    

We have to use Rman to recover our block

 So, Thats it now you can save your data.