DBV-00600: Fatal Error during DBVERIFY

[Former Member]

We are experiencing offline backup issues when doing a backup in Oracle version 11.2.0.3

here's part of the logs from DB13

BR0395I Verifying /mnt/backup/DB_BACKUP/SID/daily_offline/bekdefuf/sr3731.data2 using DBVERIFY...

BR0278E Command output of '/oracle/SID/112_64/bin/dbv file=/mnt/backup/DB_BACKUP/SID/daily_offline/bekdefuf/sr3731.data2 blocksize=8192':

DBVERIFY: Release 11.2.0.3.0 - Production on Thu Dec 20 00:40:29 2012

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

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

BR0280I BRBACKUP time stamp: 2012-12-20 00.40.29

BR0279E Return code from '/oracle/SID/112_64/bin/dbv file=/mnt/backup/DB_BACKUP/SID/daily_offline/bekdefuf/sr3731.data2 blocksize=8192': 3

BR0397E Verification of backup of /mnt/backup/DB_BACKUP/SID/daily_offline/bekdefuf/sr3731.data2 using DBVERIFY failed due to previous errors

BR0280I BRBACKUP time stamp: 2012-12-20 00.40.31

BR0304I Starting and opening database instance SID ...

BR0280I BRBACKUP time stamp: 2012-12-20 00.40.54

BR0305I Start and open of database instance SID successful

BR0056I End of database backup: bekdefuf.afd 2012-12-20 00.40.29

BR0280I BRBACKUP time stamp: 2012-12-20 00.40.56

We are running on Suse Linux 64 bit OS.

Any idea guys?

regards

[volker_borowski2]

Hi,

im /mnt is a NFS attached backup location, it might be that only the backup copy was faulty.

Do an online verification again of only the datafile affected

brbackup -m /oracle/???/sapdata?/sr3731_2/sr3731.data2 -t online -w only_dbv

Second: Do RMAN checks in addition.

Notes: 1016173 and 23345

Good luck

Volker

[Former Member]

Weird thing is this error is not consistently showing. Like today the backup was successful. No action was done since the last backup in OS or SAP backup config.

[volker_borowski2]

Then you should surely investigate how the backup target is mounted, and if it is NFS, check if you have somthing flapping on that networkpath to the target.

Volker