kishoredba

 Profile Answers by kishoredba 

• Jul 21st, 2008

 

using v$block_corruption view u can find which blocks corrupted.

Rman>> block recover datafile <fileid> block <blockid>;

Using the above statement u recover the corrupted blocks.

Thanks & Regards,
Kishore.

oracle56

 Profile Answers by oracle56 

• Aug 24th, 2008

 

First check whether the block is corrupted or not by using this command

sql>select file#, block#  from v$database_block_corruption;

 file#  block
  2        507

the above block is corrupted...

conn to Rman

To recover the block use this command...

Rman>blockrecover dataile 2 block 507;

the above command recover the block 507

Now, just verify it.....

Rman>blockrecover corruption list;

Thks..