Oracle RMAN Question:

Download Job Interview Questions and Answers PDF

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

RMAN Interview Question
RMAN Interview Question

Answers:

Answer #1
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..

Answer #2
if you get the details of data file & block check one more time by db verify utility.
db file='name.dbf' blocksize=8192;
it will show you all the details of data file.
after that
Rman>blockrecover datafile 1 block 'number';
it will recover.

Download RMAN Interview Questions And Answers PDF

Previous QuestionNext Question
What is RAID?
What is RAID0?
What is RAID1?
What is RAID 10?
Suppose you have taken a manual backup of a datafile using o/s. How RMAN will know about it?