on 04-13-2013 3:58 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.