Oracle RMAN Interview Question:

How to identify the block corruption in RMAN database? How do you fix it?

Submitted by: Administrator

First check whether the block is corrupted or not by using this commandsql>select file#, block# from v$database_block_corruption; file# block 2 507the above block is corrupted...conn to RmanTo recover the block use this command...Rman>blockrecover dataile 2 block 507;the above command recover the block 507Now, just verify it.....Rman>blockrecover corruption list;Thks..
Submitted by: Administrator