dbverify job running with error

[Former Member]

Hi Gurus

I have encounter one issue where dbverify job running with error below:

BR0278E Command output of '/oracle/PR2/112_64/bin/dbv file=/oracle/PR2/sapdata4/sr3_42/sr3.data42 blocksize=8192':

DBVERIFY: Release 11.2.0.2.0 - Production on Sat Oct 27 22:00:19 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

DBV-00600: Fatal Error - [20] [27090] [0] [0]

BR0280I BRBACKUP time stamp: 2012-10-27 22.00.19

BR0279E Return code from '/oracle/PR2/112_64/bin/dbv file=/oracle/PR2/sapdata4/sr3_42/sr3.data42 blocksize=8192': 3

BR0397E Verification of /oracle/PR2/sapdata4/sr3_42/sr3.data42 using DBVERIFY failed due to previous errors

BR0363E Verification of backup of /oracle/PR2/sapdata4/sr3_77/sr3.data77 failed due to previous errors

BR0363E Verification of backup of /oracle/PR2/sapdata2/sr3_74/sr3.data74 failed due to previous errors

BR0363E Verification of backup of /oracle/PR2/sapdata4/sr3_72/sr3.data72 failed due to previous errors

BR0363E Verification of backup of /oracle/PR2/sapdata2/sr3_70/sr3.data70 failed due to previous errors

BR0363E Verification of backup of /oracle/PR2/sapdata4/sr3_68/sr3.data68 failed due to previous errors

BR0363E Verification of backup of /oracle/PR2/sapdata2/sr3_66/sr3.data66 failed due to previous errors

Please shed some light. Thanks!

[Former Member · Accepted solution]

Check the Linux kernel parameter fs.aio-max-nr, it should be set to a value of at least 1048576 if not higher (a lot). See this doc http://docs.oracle.com/cd/E11882_01/install.112/e24326/toc.htm#BHCCADGD

Reason - the error is -27090 "Unable to reserve kernel resources for asynchronous disk I/O"

Otherwise, the DBV-00600: Fatal Error - [20] [27090] [0] [0] is some already fixed bug in 11.2.0.2, see if you can test the datafiles on a test system which has the newest(newer) patches.

Anyway, dbverify is horrible and you should be using rman validate which is much faster and does the same 🙂

brbackup -u / -m all -w only_rmv -e <parallel degree> -c

it's not a backup, its full db online verification. See note 1016173

[Former Member · Accepted solution]

Hi Robert,

Thanks for the info. I will try this recommendation and update the result.

Thanks

[Former Member]

What is your oracle version?

Regards,

Roman

[Former Member]

Hi Roman,

the version is

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

Thanks.

[Former Member]

Hi,

Is PR2 system copied from and any other system . If yes during this process did you generate fresh control file from source system.

Did you access the datafiles from OS level and checked status of datafiles.

Thanks,

rahul

[Former Member]

Hi Rahul,

This is production system and it is not copied from other system. i have checked the data file in OS and it looks fine.

Thanks

[Former Member]

Hi,

/oracle/PR2/sapdata4/sr3_42/sr3.data42

please check for the owner of above file , it should be orapr2

pls paste the list(ls -lrt) of sr3_42 directory

Thanks.

[Former Member]

Hi Nikhil,

the files owner is correct

-rw-r----- 1 orapr2 dba 33554440192 2012-11-09 15:04 sr3.data42

Thanks