DBVERIFY getting failed..

[Former Member]

hi,

on my production server checkdb is working fine, but while running DBVERIFY it is throwing permission error for datafiles

ERROR:

BR0058I BRBACKUP action ID: beansfpp

BR0059I BRBACKUP function ID: dbv

BR0110I Backup mode: ALL

BR0077I Database files for backup:

BR0061I 216 files found for backup, total size 2479881.688 MB

BR0143I Backup type: online

BR0140I Number of parallel copy processes: 8

BR0149I Only database verification using DBVERIFY - no backup

BR0134I Unattended mode with 'force' active - no operator confirmation allowed

BR0395I Verifying /oracle/R3P/sapdata7/r3p_118/r3p.data118 using DBVERIFY...

BR0395I Verifying /oracle/R3P/sapdata8/r3p_95/r3p.data95 using DBVERIFY...

BR0395I Verifying /oracle/R3P/sapdata6/r3p_128/r3p.data128 using DBVERIFY...

BR0395I Verifying /oracle/R3P/sapdata1/r3pmseg_19/r3pmseg.data19 using DBVERIFY...

BR0395I Verifying /oracle/R3P/sapdata5/r3p_115/r3p.data115 using DBVERIFY...

BR0395I Verifying /oracle/R3P/sapdata7/r3p_120/r3p.data120 using DBVERIFY...

BR0395I Verifying /oracle/R3P/sapdata8/r3pcoep_14/r3pcoep.data14 using DBVERIFY...

BR0395I Verifying /oracle/R3P/sapdata4/r3p_9/r3p.data9 using DBVERIFY...

BR0278E Command output of '/oracle/R3P/102_64/bin/dbv file=/oracle/R3P/sapdata8/r3p_95/r3p.data95 blocksize=8192':

414064 : map : Permission Denied

414064 : map : Permission Denied

DBVERIFY: Release 10.2.0.4.0 - Production on Sun May 10 08:22:26 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

DBV-00100: Specified FILE (/oracle/R3P/sapdata8/r3p_95/r3p.data95) not accessible

BR0280I BRBACKUP time stamp: 2009-05-10 08.22.26

BR0279E Return code from '/oracle/R3P/102_64/bin/dbv file=/oracle/R3P/sapdata8/r3p_95/r3p.data95 blocksize=8192': 1

BR0397E Verification of /oracle/R3P/sapdata8/r3p_95/r3p.data95 using DBVERIFY failed due to previous errors

BR0363E Verification of backup of /oracle/R3P/sapdata8/r3p_113/r3p.data113 failed due to previous errors

BR0363E Verification of backup of /oracle/R3P/sapdata8/r3p_122/r3p.data122 failed due to previous errors

BR0363E Verification of backup of /oracle/R3P/sapdata8/r3p_123/r3p.data123 failed due to previous errors

BR0363E Verification of backup of /oracle/R3P/sapdata8/r3p_124/r3p.data124 failed due to previous errors

BR0363E Verification of backup of /oracle/R3P/sapdata8/r3p_125/r3p.data125 failed due to previous errors

system: ecc6.0

OS AIX 5.3

please suggest

-Gokul

[Former Member · Accepted solution]

Hi Gokul,

Pl send the sapdba role and sapconn role log.

Regards,

Rahul.

[Former Member]

Hi,

Check your login ID ?? is it ORA<SID>.

u can try with this command through orasid login

dbv FILE=<FILENAME> logfile=<logfileName>

check below file BR0279E Return code from '/oracle/R3P/102_64/bin/dbv file=/oracle/R3P/sapdata8/r3p_95/r3p.data95 blocksize=8192': 1

check owner,group & permission of /oracle/R3P/sapdata8/r3p_95/r3p.data95'.

for more detail of dbv

http://www.oracleutilities.com/OSUtil/dbv.html

surendra

[Former Member]

Thanks everybody....

the problem resolved,

sol:

shutdown database run--> dbverify for single file with brtools ( which was successful)

again started database and the issue found resolved.

-Gokul Chitode

[Former Member]

414064 : map : Permission Denied
414064 : map : Permission Denied
DBVERIFY: Release 10.2.0.4.0 - Production on Sun May 10 08:22:26 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
DBV-00100: Specified FILE (/oracle/R3P/sapdata8/r3p_95/r3p.data95) not accessible

Looks like permission issue. Check file /oracle/R3P/sapdata8/r3p_95/r3p.data95 exists and have the permission for the same.

[Former Member]

Hi,

We are facing the issue on DRS server, the same on production server is working fine.

i have checked as per note 533614 brtools version is BRTOOLS 7.00 (38)

and the same version is working fine on PRD server. permission on PRD and DRS file system are same..

please suggest

Regards,

Gokul

[JPReyes]

Specified FILE (/oracle/R3P/sapdata8/r3p_95/r3p.data95) not accessible

That doesn't seem to be a problem with the Brtools version but a problem with permissions on the filesystem... check that the file exists and it should belong to ora<sid> with permission 755...

Regards

Juan