redolog backup problem

[Former Member]

Dear Team,

During archiving log backup , I am faccing the problem.

Job started

Step 001 started (program RSDBAJOB, variant &0000000000008, user ID BASIS)

Execute logical command BRARCHIVE On host sapprd

Parameters:-u / -jid LOG__20090729213120 -c force -p initPRD.sap.backup -s -v SSS

BR0002I BRARCHIVE 7.00 (18)

BR0252E Function fopen() failed for '/oracle/PRD/saparch/aebcyena.sve' at location main-5

BR0253E errno 13: Permission denied

BR0121E Processing of log file /oracle/PRD/saparch/aebcyena.sve failed

BR0007I End of offline redo log processing: aebcyena.sve 2009-07-29 21.31.38

BR0280I BRARCHIVE time stamp: 2009-07-29 21.31.38

BR0005I BRARCHIVE terminated with errors

External program terminated with exit code 3

BRARCHIVE returned error status E

Job finished

But my Online backup working fine.

Whats the problem.

RAJ

[ashish_vikas · Accepted solution]

Hi Rajpuri,

If i am correct you have to checge the pemission of '/oracle/PRD/saparch' from 755 to say 777. It will solve your problem.

See the problem is that, brarchive is unable to generate aebcyena.sve log file in oracle/PRD/saparch directory due to permission issue and you do not have write permission for anyother user than oraprd and you are running this with SIDadm user. Just give saparch 777 permision and see the difference.

You will see the log file got created with sidadm user id and not with orasid..

thanks

Ashish

[markus_doehr2 · Accepted solution]

> See the problem is that, brarchive is unable to generate aebcyena.sve log file in oracle/PRD/saparch directory due to permission issue and you do not have write permission for anyother user than oraprd and you are running this with SIDadm user. Just give saparch 777 permision and see the difference.

That permission is usually handled by the s-bit on the br*tools. They can be executed as <sid>adm (e. g. using DB13) but the S-bit makes sure that the effective user is ora<SID>.

Those permissions are set using "saproot.sh <SID>" in the kernel directory.

> You will see the log file got created with sidadm user id and not with orasid..

Markus

[ashish_vikas · Accepted solution]

HI Markus,

I'm not sure on s-bits concept ..can u plz explain it.

However in my system also when i run anything it uses SIDadm and not oraadm results in failure of activity :

BR0801I BRCONNECT 7.00 (31)

BR0805I Start of BRCONNECT processing: cebezipu.cln 2009-08-09 11.33.22

BR0252E Function fopen() failed for '/oracle/F50/sapcheck/cebezipu.cln' at location main-11

BR0253E errno 13: Permission denied

BR0121E Processing of log file /oracle/F50/sapcheck/cebezipu.cln failed

BR0806I End of BRCONNECT processing: cebezipu.cln 2009-08-09 11.33.25

BR0280I BRCONNECT time stamp: 2009-08-09 11.33.25

BR0804I BRCONNECT terminated with errors

But if change permission of respective sapcheck/.. it works. So how it determines it will run with SIDadm and when oraadm ?

thanks

Ashish

[markus_doehr2 · Accepted solution]

> I'm not sure on s-bits concept ..can u plz explain it.

read http://en.wikipedia.org/wiki/Sticky_bit

What's the output of

ls -l br*

in your kernel directory?

Markus

[ashish_vikas · Accepted solution]

Hey i go it !

er3as***:f50adm 6> pwd

/sapmnt/F50/exe

er3as102:f50adm 7> ll br*

-rwsrwxr-x 1 oraf50 dba 12263472 Jan 14 2008 brarchive

-rwsrwxr-x 1 oraf50 dba 12662136 Jan 14 2008 brbackup

-rwsrwxr-x 1 f50adm sapsys 15996856 Jan 14 2008 brconnect

-rwxrwxr-x 1 f50adm sapsys 13053624 Jan 14 2008 brrecover

-rwxrwxr-x 1 f50adm sapsys 3646792 Jan 12 2008 brrestore

-rwxrwxr-x 1 f50adm sapsys 16469664 Jan 14 2008 brspace

-rwsrwxr-x 1 oraf50 dba 5417712 Jan 13 2008 brtools

thanks Markus

[fidel_vales · Accepted solution]

>

> Hey i go it ! 
> 
> er3as***:f50adm 6> pwd
> /sapmnt/F50/exe
> er3as102:f50adm 7> ll br*
> -rwsrwxr-x   1 oraf50     dba        12263472 Jan 14  2008 brarchive
> -rwsrwxr-x   1 oraf50     dba        12662136 Jan 14  2008 brbackup
> -rwsrwxr-x   1 f50adm     sapsys     15996856 Jan 14  2008 brconnect
> -rwxrwxr-x   1 f50adm     sapsys     13053624 Jan 14  2008 brrecover
> -rwxrwxr-x   1 f50adm     sapsys     3646792 Jan 12  2008 brrestore
> -rwxrwxr-x   1 f50adm     sapsys     16469664 Jan 14  2008 brspace
> -rwsrwxr-x   1 oraf50     dba        5417712 Jan 13  2008 brtools
> 
> 
> thanks Markus

Hi,

the owners and groups are not correct.

Check the owner, group, and access authorizations in accordance with Note 113747.

[markus_doehr2]

> BR0002I BRARCHIVE 7.00 (18)

Just as advise: I suggest you update your BR*tools. Patchlevel 18 is very old, current is 40.

Markus

[former_member204746]

ask Manu Jain, or one of his duplicate ID.

[Former Member]

who is manu or jain

i am

RAJ

[markus_doehr2]

> BR0002I BRARCHIVE 7.00 (18)

> BR0252E Function fopen() failed for '/oracle/PRD/saparch/aebcyena.sve' at location main-5

> BR0253E errno 13: Permission denied

> BR0121E Processing of log file /oracle/PRD/saparch/aebcyena.sve failed

Did you execute "saproot.sh <SID>" in the kernel directory so that the permissions for "brarchive" are set correctly?

Markus

[Former Member]

how I set permission.

I check in my PRD

drwxr-xr-x 3 oraprd dba 96 Jul 4 01:30 origlogA

drwxr-xr-x 3 oraprd dba 96 Jul 4 01:30 origlogB

drwxr-xr-x 2 oraprd dba 96 Jun 30 14:16 saparch

drwxr-xr-x 2 oraprd dba 1024 Jul 29 16:42 sapbackup

drwxr-xr-x 2 oraprd dba 1024 Jul 4 06:41 sapcheck

drwxr-xr-x 15 oraprd dba 1024 Jul 4 01:29 sapdata1

drwxr-xr-x 12 oraprd dba 1024 Jul 4 01:29 sapdata2

drwxr-xr-x 12 oraprd dba 1024 Jul 4 01:29 sapdata3

drwxr-xr-x 12 oraprd dba 1024 Jul 26 08:13 sapdata4

drwxr-xr-x 3 root dba 96 Jun 29 20:34 sapdata5

drwxr-xr-x 4 oraprd dba 1024 Jul 26 08:32 sapreorg

drwxr-xr-x 4 oraprd dba 96 Jun 30 14:16 saptrace

-rwxr-xr-x 1 oraprd dba 15752 Jan 10 2009 startdb

-rwxr-xr-x 1 oraprd dba 11119 Jan 10 2009 stopdb

1. cd saparch

2. ll

total 0

#

Thanks

RAJ

[Former Member]

my job log is

Job started

Step 001 started (program RSDBAJOB, variant &0000000000011, user ID BASIS)

Execute logical command BRARCHIVE On host sapprd

Parameters:-u / -jid LOG__20090731163619 -c force -p initPRD.sap.backup -s -v AA

BR0002I BRARCHIVE 7.00 (18)

BR0252E Function fopen() failed for '/oracle/PRD/saparch/aebdgzyg.sve' at location main-5

BR0253E errno 13: Permission denied

BR0121E Processing of log file /oracle/PRD/saparch/aebdgzyg.sve failed

BR0007I End of offline redo log processing: aebdgzyg.sve 2009-07-31 16.36.34

BR0280I BRARCHIVE time stamp: 2009-07-31 16.36.34

BR0005I BRARCHIVE terminated with errors

External program terminated with exit code 3

BRARCHIVE returned error status E

Job finished

How I set permission for archive log backup

RAJ

[Former Member]

Hi,

Ensure the permissions for DBA tools BR*Tools are correct as mentioned in Note 113747.

[former_member204746]

To learn how, you go for Unix training. or search SAP notes, or ask Manu Jain, Raj, kalissa or any other duplicate ID that you may have created.

[Former Member]

Hi Warren,

This is a notorious spammer for some time already who has an alergy against doing a search.

Usually we just delete the questions on sight.

Previous questions also indicate that an illegal copy of the software is being used... hence no support.

Cheers,

Julius

[fidel_vales]

Hi,

if

> This is a notorious spammer

and

> an illegal copy of the software is being used.

why the user is not deleted?

[Former Member]

> why the user is not deleted?

We've done that about 50 times already...

See => (you might need additional permissions to see this thread internally)

Recently it stopped for a while; otherwise it will be handed over to SAP Legal.

Cheers,

Julius

[fidel_vales]

Ok,

Just curious