BR0253E errno 13: Permission denied

[Former Member]

Hi, Experts

I am facing below mentioned Error during Whole database online + redo log backup (DB13). Can anybody share the knowledge to solve this problem?

Error :

BR0002I BRARCHIVE 7.00 (24)

BR0006I Start of offline redo log processing: adzavgra.cds 2008-10-16 17.01.42

BR0484I BRARCHIVE log file: /oracle/SHP/saparch/adzavgra.cds

BR0101I Parameters

Name Value

oracle_sid SHP

oracle_home /oracle/SHP/102_64

oracle_profile /oracle/SHP/102_64/dbs/initSHP.ora

sapdata_home /oracle/SHP

sap_profile /oracle/SHP/102_64/dbs/initSHP.sap

backup_dev_type tape

compress hardware

tape_copy_cmd dd

cpio_flags -ovB

cpio_in_flags -iuvB

dd_flags obs=64k bs=64k

dd_in_flags ibs=64k bs=64k

rewind mt -f $ rew

rewind_offline mt -f $ offl

tape_size 58587.927 MB

tape_address /dev/rmt/0mn

tape_address_rew /dev/rmt/0m

volume_archive SHPDA1610

expir_period 30

tape_use_count 100

archive_dupl_del only

system_info shpadm/shpadm shreprdb HP-UX B.11.23 U ia64

oracle_info SHP 10.2.0.2.0 8192 5733 51743973 shreprdb UTF8 UTF8

sap_info 700 SAPSR3 0002LK0003SHP0011D09281342360013NetWeaver_ORA

make_info hpia64 OCI_102 Apr 21 2007

command_line /usr/sap/SHP/SYS/exe/run/brarchive +bdzavgra.ant,45940288171,SHPDA1610,51 -jid ALLOG20081016163842 -d tape -c force -p initSHP.sap -cds

BR0252E Function fopen() failed for '/oracle/SHP/saparch/archSHP.log' at location arch_copy_delete-6

BR0253E errno 13: Permission denied

BR0121E Processing of log file /oracle/SHP/saparch/archSHP.log failed

BR0016I 0 offline redo log files processed, total size 0.000 MB

BR0252W Function fopen() failed for '/oracle/SHP/saparch/archSHP.log' at location BrCleanup-8

BR0253W errno 13: Permission denied

BR0121W Processing of log file /oracle/SHP/saparch/archSHP.log failed

BR0007I End of offline redo log processing: adzavgra.cds 2008-10-16 17.01.42

BR0280I BRARCHIVE time stamp: 2008-10-16 17.01.42

BR0005I BRARCHIVE terminated with errors

Thanks in advance

Regards

[markus_doehr2 · Accepted solution]

Did you execute

./saproot.sh <SID>

after you updated the BR*tools?

It seems that the s-bit is not set and hence the program running under the wrong permissions.

Markus

[former_member204746]

DB13 uses Os user [sid]adm,

easy solution is to add Os user [sid]adm in OS group "dba"

[Former Member]

Hi experts,

I am getting a similar error amongst others. This is the detailed log when i attempt to take backup of online redo logs via db13 or brtools.

23.10.2008 11:33:22 Job started

23.10.2008 11:33:22 Step 001 started (program RSDBAJOB, variant &0000000000034, user ID )

23.10.2008 11:33:22 Execute logical command BRARCHIVE On host NGD

23.10.2008 11:33:22 Parameters:-u / -jid LOG__20081023113322 -c force -p initNGD.sap -ds -w

23.10.2008 11:33:24 BR0002I BRARCHIVE 7.00 (31)

23.10.2008 11:33:24 BR0128W Option '-w' ignored for '-ds'

23.10.2008 11:33:24 BR0006I Start of offline redo log processing: adzcdofa.dsv 2008-10-23 11.33.22

23.10.2008 11:33:24 BR0484I BRARCHIVE log file: D:\oracle\NGD\saparch\adzcdofa.dsv

23.10.2008 11:33:24 BR0252W Function remove() failed for 'D:\oracle\product\10.2.0\db_1\database\sapNGD.ora' at location BrInitOraCopy-7

23.10.2008 11:33:24 BR0253W errno 13: Permission denied

23.10.2008 11:33:24 BR0166I Parameter 'log_archive_dest' not found infile D:\oracle\product\10.2.0\db_1\database\initNGD.ora - default assumed

23.10.2008 11:33:24

23.10.2008 11:33:24 BR0013W No offline redo log files found for processing

23.10.2008 11:33:24

23.10.2008 11:33:24 BR0007I End of offline redo log processing: adzcdofa.dsv 2008-10-23 11.33.24

23.10.2008 11:33:24 BR0280I BRARCHIVE time stamp: 2008-10-23 11.33.24

23.10.2008 11:33:24 BR0004I BRARCHIVE completed successfully with warnings

23.10.2008 11:33:24 External program terminated with exit code 1

23.10.2008 11:33:24 BRARCHIVE returned error status E

23.10.2008 11:33:25 Job finished

OS user <sid>adm is part of the group ORA_SID_DBA (Windows).

Please not the errors BR0252W and BR0166I as well.

Your prompt feedback is appreciated.

Regards.

Edited by: Akintunde Olorunsola on Oct 23, 2008 1:28 PM

[Former Member]

You need to check SAPserviceSID user authorizations on this folder, in NEXT time OPEN NEW THREAD ...

Also as you can see:

BR0166I Parameter 'log_archive_dest' not found infile D:\oracle\product\10.2.0\db_1\database\initNGD.ora

Regards

[Former Member]

Hi,

Try once by adding <sapsid>adm user in ORA_<DBSID>_OPER & ORA_DBA groups.

and also look at the 'log_archive_dest' as it is giving the error that the parameter is not defined in the inti<SID>.sap

Raj

[Former Member]

please check the permissions on the file:

/oracle/SHP/saparch/archSHP.log

make sure it is 755 and owner of the file is ora<sid>:sapsys

thanx