Db verify failing -> BR0223E Last copy process failed

[Former Member]

Dear all,

hello,

My DBVERIFY job fails with the following logs:

DBV-00100: Specified FILE (/oracle/QAS/sapdata1/sr3701x_2/sr3701x.data2) not accessible

BR0280I BRBACKUP time stamp: 2013-04-13 14.50.58

BR0279E Return code from '/oracle/QAS/112_64/bin/dbv file=/oracle/QAS/sapdata1/sr3701x_2/sr3701x.data2 blocksize=8192': 1

BR0397E Verification of /oracle/QAS/sapdata1/sr3701x_2/sr3701x.data2 using DBVERIFY failed due to previous errors

BR0278E Command output of '/oracle/QAS/112_64/bin/dbv file=/oracle/QAS/sapdata1/sr3_1/sr3.data1 blocksize=8192':

DBVERIFY: Release 11.2.0.3.0 - Production on Sat Apr 13 14:50:57 2013

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

DBV-00100: Specified FILE (/oracle/QAS/sapdata1/sr3_1/sr3.data1) not accessible

BR0280I BRBACKUP time stamp: 2013-04-13 14.50.58

BR0279E Return code from '/oracle/QAS/112_64/bin/dbv file=/oracle/QAS/sapdata1/sr3_1/sr3.data1 blocksize=8192': 1

BR0397E Verification of /oracle/QAS/sapdata1/sr3_1/sr3.data1 using DBVERIFY failed due to previous errors

BR0278E Command output of '/oracle/QAS/112_64/bin/dbv file=/oracle/QAS/sapdata1/sr3_4/sr3.data4 blocksize=8192':

DBVERIFY: Release 11.2.0.3.0 - Production on Sat Apr 13 14:50:58 2013

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

DBV-00100: Specified FILE (/oracle/QAS/sapdata1/sr3_4/sr3.data4) not accessible

BR0280I BRBACKUP time stamp: 2013-04-13 14.50.58

BR0279E Return code from '/oracle/QAS/112_64/bin/dbv file=/oracle/QAS/sapdata1/sr3_4/sr3.data4 blocksize=8192': 1

BR0397E Verification of /oracle/QAS/sapdata1/sr3_4/sr3.data4 using DBVERIFY failed due to previous errors

BR0278E Command output of '/oracle/QAS/112_64/bin/dbv file=/oracle/QAS/sapdata1/system_1/system.data1 blocksize=8192':

DBVERIFY: Release 11.2.0.3.0 - Production on Sat Apr 13 14:50:58 2013

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

DBV-00100: Specified FILE (/oracle/QAS/sapdata1/system_1/system.data1) not accessible

BR0280I BRBACKUP time stamp: 2013-04-13 14.50.58

BR0279E Return code from '/oracle/QAS/112_64/bin/dbv file=/oracle/QAS/sapdata1/system_1/system.data1 blocksize=8192': 1

BR0397E Verification of /oracle/QAS/sapdata1/system_1/system.data1 using DBVERIFY failed due to previous errors

BR0363E Verification of backup of /oracle/QAS/sapdata1/sr3usr_1/sr3usr.data1 failed due to previous errors

BR0363E Verification of backup of /oracle/QAS/sapdata1/sysaux_1/sysaux.data1 failed due to previous errors

I set even 777 and oraSID user to the files and directories in: /oracle/QAS/sapdata1

But it still fails, I think it is not a problem related to the owner or rights of those files.

As well, R3trans is OK:

R3trans -d

This is R3trans version 6.23 (release 720 - 15.05.12 - 20:12:03).

unicode enabled version

R3trans finished (0000).

No other errors on the system, but this job fails.

Please advise.

Thanks,

J.

[former_member206552]

Hi Jordan

have you tried running rman VALIDATE CHECK LOGICAL DATABASE . If rman find block corruption, it populates v$database_block_corruption and you can then just use rman to recover the specific corrupted blocks. You can parallelize the RMAN VALIDATE by opening multiple channels.

http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmvalid.htm

please also see

http://damir-vadas.blogspot.de/2010/01/dbv-00100-11gr1-bug.html

best regards

marius

[former_member188883]

Hi Jordan,

Perform following checks

1) Owner of the data files should be orasid:dba

2) Permission on the data files should be 755

3) You are able to perform brbackup using brtools

4) You are using latest brtools from SAP service marketplace which should be 7.20 or higher

Regards,

Deepak Kori