Oracle RMAN Question:
Download Job Interview Questions and Answers PDF
How to identify the block corruption in RMAN database? How do you fix it?
Answers:
Answer #1First 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 #2if 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.
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 Question | Next 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? |