A Oracle DBA's BLOG

Welcome to my ORACLE DBA blog. You will be Amazing!!!

Tuesday, September 9, 2014

Block Media Recovery with RMAN

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.
 

No comments:

Post a Comment