Skip to Content
0
Mar 15, 2012 at 10:43 PM

DBVERIFY has detected corrupt blocks

594 Views

Hello Experts

When i run DBVERIFY .. Some files it is not checking with the message
----------------------------------------------------------
The report shows for some file as ( NO DOUBTS-CLEAR)
---------------------------------------------------------

BR0398E DBVERIFY has detected corrupt blocks in /oracle/P60/sapdata1/p60_137/p60.data137
which is understood as This data file is we have to restore from a healthy backup & resotre

-----------------------------------------------------------------
DESIRING YOUR SUGGESSION -1
-----------------------------------------------------------------
Job Log :
BR0278E Command output of '/oracle/P60/112_64/bin/dbv
file=/oracle/P60/sapdata1/p60usr_1/p60usr.data1 blocksize=8192':
DBVERIFY: Release 11.2.0.2.0 - Production on Thu Mar 15 11:20:22 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
DBV-00102: File I/O error on FILE
(/oracle/P60/sapdata1/p60usr_1/p60usr.data1) during end read operation (-1)
BR0280I BRBACKUP time stamp: 2012-03-15 11.20.22
BR0279E Return code from '/oracle/P60/112_64/bin/dbv
file=/oracle/P60/sapdata1/p60usr_1/p60usr.data1 blocksize=8192': 1
BR0397E Verification of /oracle/P60/sapdata1/p60usr_1/p60usr.data1 usingDBVERIFY failed due to previous errors

My Query 1:

We checked from root folder to file all permissions are in place ;
Why DBV-00102: File I/O error may be coming ?????

----------------------------------------------------------------
DESIRING YOUR SUGGESSION -2
-----------------------------------------------------------------

BR0363E Verification of backup of /oracle/P60/sapdata1/p60_15/p60.data15failed due to previous errors

My Query 2 :

Why it is skipping some other data files checking with a reasons failed due to previous reasosn

----------------------------------------------------------------
DESIRING YOUR SUGGESSION -3
-----------------------------------------------------------------



In end it give
BR0063I 157 of 176 files processed - 1409091.227 of 1582671.375 MB done
i.e it skipped 19 files ? Why it will skip ? like ??