Determine Number of Blocks Corrupted

You have a database. You have a datafile and some blocks are corrupted in the datafile. What statement will you issue to know how many blocks are corrupted?

Questions by Pragati.rch

Showing Answers 1 - 6 of 6 Answers

hemant.agarwal03

  • Mar 12th, 2008
 

You can check the "V_$DATABASE_BLOCK_CORRUPTION" view to determine the corrupted blocks.

  Was this answer useful?  Yes

kunal1017

  • Apr 1st, 2008
 

you can use the DBVERIFY utility to check the corruption in datafiles so that you can now number of blocks corrupted.Here is the procedure :
On o/s prompt login as oracle user :
$ dbv file= 'datafile name'

now in the output check for the line ' number of pages corrupted' . It tells you about the number of datablocks corrupted in that datafile.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions