cancel
Showing results for 
Search instead for 
Did you mean: 

DBVERIFY has detected corrupt blocks

pr_srinivas
Contributor
0 Kudos

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 ??

Accepted Solutions (0)

Answers (4)

Answers (4)

lbreddemann
Active Contributor
0 Kudos

HI there!

Please: DO NOT perform a recovery just to try out if it works!

Chances are quite big, that you'll break more than you fix by that. That kind of recommendation has led to numerous system down situations!

The other thing is: please don't use DBVERIFY if there's no absolute reason for this.
Use RMAN verification instead. It's available for years now with the BRTOOLS.
It's way faster, it's far easier to use when corruptions are found and has much less impact to your system performance. (just check my blogs on this...)

DBV is an external program that has been designed to check offline datafiles. It can easily be that the file error is just due to some file system lock on the file...

And no, if DBV as a program on its own throws an I/O error, then the BRTOOLS don't have anything to do with that. No reason to change them here (well, at least not for this reason - having the current version in place is  a good idea nevertheless...).

regards,

Lars

Former Member
0 Kudos

Hi,

Please check and follow  below notes

Note 99962 - Error messages when using DBVERIFY

Note 99962 - Error messages when using DBVERIFY

   1. The problem may be with BR*Tools. update them to latest level.

   2. Perform DBVERIFY repeatedly to confirm the corruption on same block.

     Perform an offline verification of the relevant files if necessary.

       If Oracle Block is actually corrupted, Remove Oracle blocks with a restore/recovery or with a reorganization of the relevant tablespace.

Check The note: Note 365481 - Block corruptions

Also check this thread http://scn.sap.com/thread/968975

Regards,

Venkata S Pagolu.

Former Member
0 Kudos

is there another errors appear at operating system during brtools checking. check errpt command. check oracle alert for extra error besides the one appeared in brtools/

Former Member
0 Kudos

Hi Srinivas,

At the first step, be sure that "/oracle/P60/sapdata1/p60usr_1/p60usr.data1" does not have any problem at the source system. After that we can go through with the steps, below;

1) Execute the commands, below in order to understand that your hardware can handle the operation. It shouldn't return an error code.

dd if=/oracle/P60/sapdata1/p60usr_1/p60usr.data1 of=/dev/null bs=8192

2) Try to resize the datafile in order to understand that is there any inconsistency between the file size value on the header and the physical filesize, by using brtools.

3) Try to recover datafile, with the statement, below;

SQL> RECOVER DATAFILE '/oracle/P60/sapdata1/p60usr_1/p60usr.data1';

4) You may try to restore single file, from your same backup

Your second and third questions are pointing to the same answer.

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

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

Because the system faced with an error during the operation. Then, it is uncessarry to execute further steps.

Best regards,

Orkun Gedik