While running whole database online backup+Redo log backup getting below error

[Former Member]

I tried to run to whole database online backup with redo log backup on db13 calendar ..am getting below error message.

#FILE..... /oracle/SID/sapbackup/cntrlSID.dbf

#SAVED.... SID___A0HO9PNET4

BKI1215I: Average transmission rate was 303.532 GB/h (86.338
MB/sec).

BKI1227I: Average compression factor was 1.000.

BKI0020I: End of program at: Thu 21 Nov 2013 03:02:09 AM
EST.

BKI0021I: Elapsed time: 01 min 26 sec.

BKI0024I: Return code is: 0.

BR0280I BRBACKUP time stamp: 2013-11-21 03.02.09

BR0232I 7 of 7 files saved by backup utility

BR0230I Backup utility called successfully

BR0252W Function
kill() failed for '11016:15' at location BrKill-3

BR0253W errno 3: No
such process

BR0278I Command output of '/usr/sap/SID/SYS/exe/run/brconnect':

BR0801I BRCONNECT 7.20 (30)

PID=11016

BR0252E Function
fopen() failed for '/oracle/SID/sapbackup/.user.pas' at location global_set-1

BR0253E errno 13:
Permission denied

BR0074W BRCONNECT
call failed

BR0280I BRBACKUP time stamp: 2013-11-21 03.02.11

BR0317I 'Alter database end backup' successful

BR0280I BRBACKUP time stamp: 2013-11-21 03.02.11

BR0340I Switching to next online redolog file for database
instance SID ...

BR0321I Switch to next online redolog file for database
instance SID successful

BR0117I ARCHIVE LOG LIST after backup for database instance SID

Parameter                      Value

[Reagan]

Hello

Please provide the primary group and the secondary for the sidadm and orasid

id sidadm

id orasid

Also try creating a file in the sapbackup location

su - orasid

touch /oracle/SID/sapbackup/.user.pas

Regards

RB

[Former Member]

Hi RB,

oraSID> id oraSID
uid=37732(oraSID) gid=3777(dba) groups=3777(dba),3373(oper),2231(sapinst)

oraSID> su - SIDadm
Password:

SIDadm> id SIDadm
uid=37731(SIDadm) gid=506(sapsys) groups=506(sapsys),3373(oper),3777(dba),2231(sapinst)

and created "touch /oracle/SID/sapbackup/.user.pas" but it doesn't not work.

[Reagan]

and created "touch /oracle/SID/sapbackup/.user.pas" but it doesn't not work.

What was the output or the error you received ?

Did you get any permission error ? if yes then try this

chmod a+rwx /oracle/SID/sapbackup

Regards

RB

[Former Member]

.user.pas file doesn't exit in the location ....what is the file ? is it required for brbackup ?even i don't see any server.

[ashish_vikas]

please download and apply latest brtools from marketplace.

best regards

ashish

[Reagan]

touch /oracle/SID/sapbackup/.user.pas

This command is creating a file there. It is not checking whether the file is there.

If the command fails then there should be an error and if the error is due to permission then try this:

chmod -R a+rwx /oracle/SID/sapbackup

Regards

RB

[Former Member]

Hello,

Please do not create any file. While we trigger the backup, there are some files created initially and will not be available later.

Try checking the permissions of

1) Users ( interms of Umask= This should be 022 for sidadm and orasid, Ulimit)

2) Directories ( Sapbackup, saparch and oraarch)

3) brtools ( as mentioned in the previous posts)

It is always advisable that we have latest Kernel/brtools. Check if the backup is happening through

1) brtools

2) DB13

3) brbackup command.

Check if you are able to run only the database backup or only a redo log backup.

Thanks,

Nick

[Reagan]

Please do not create any file. While we trigger the backup, there are some files created initially and will not be available later.

The reason behind the file creation is to understand whether the problem is due to a permission issue or not and not to bypass the automatic creation of the file during a backup.

Regards

RR

[Former Member]

Hi,

For all below mentioned files give 755 permission and check it.. And also check the permissions of sapbackup directory & saparch directory.

-rwsrwxr--  1 orasid   sapsys    10022600 Aug 23 2012  brarchive

-rwsrwxr--  1 orasid   sapsys    10251536 Aug 23 2012  brbackup

-rwsrwxr--  1 orasid   sapsys    12179560 Aug 23 2012  brconnect

-rwxr-xr-x  1 sidadm   sapsys    10708840 Aug 23 2012  brrecover

-rwxr-xr-x  1 sidadm   sapsys     4140576 Aug 23 2012  brrestore

-rwxr-xr-x  1 sidadm   sapsys    12778384 Aug 23 2012  brspace

-rwxr-xr-x  1 sidadm   sapsys     4711664 Aug 23 2012  brtools

cheers,

R.Ramkumar

[former_member206552]

Hi Dhavan

Please check the permissions of '/oracle/SID/sapbackup'

Best Regards

Marius

[ashish_vikas]

please also make sure you have set permissions for brtools correctly. (run saproot.sh SID with root user)

113747  - Owners and authorizations for BR*Tools

-rwsrwxr--  1 orasid   sapsys    10022600 Aug 23 2012  brarchive

-rwsrwxr--  1 orasid   sapsys    10251536 Aug 23 2012  brbackup

-rwsrwxr--  1 orasid   sapsys    12179560 Aug 23 2012  brconnect

-rwxr-xr-x  1 sidadm   sapsys    10708840 Aug 23 2012  brrecover

-rwxr-xr-x  1 sidadm   sapsys     4140576 Aug 23 2012  brrestore

-rwxr-xr-x  1 sidadm   sapsys    12778384 Aug 23 2012  brspace

-rwxr-xr-x  1 sidadm   sapsys     4711664 Aug 23 2012  brtools

best regards

ashish

[Former Member]

I had as some owner and authorization but still same issue

-rwsrwxr-x 1 oraSID sapsys  9354455 Feb  4  2013 brarchive

-rwsrwxr-x 1 oraSID sapsys  9472304 Feb  4  2013 brbackup

-rwsrwxr-x 1 oraSID sapsys 11366887 Feb  4  2013 brconnect

-rwxr-xr-x 1 SIDadm sapsys  9922783 Feb  4  2013 brrecover

-rwxr-xr-x 1 SIDadm sapsys  6228006 Feb  4  2013 brrestore

-rwxr-xr-x 1 SIDadm sapsys 11799999 Feb  4  2013 brspace

-rwxr-xr-x 1 SIDadm sapsys  6822466 Feb  4  2013 brtools

[ashish_vikas]

- also make sure /oracle/SID/sapbackup has permission 775 with owner as oraSID:dba

If this also do not solve this problem, you should apply latest brtools per note 1838852. Download it from marketplace and uncar it in kernel directory(make sure to set correct permission again).

best regards

ashish

[Former Member]

I checked permission have drwxrwxr-x  2 orasid dba
4096 Nov 25 03:02 sapbackup and could not see any permission related issue.

While I tried to whole database backup +redo log backup. I don’t see
any issue an brbackup it is working fine. And next move for brarchive so that
time is getting below error message

BR0252W Function

kill() failed for
'11016:15' at location BrKill-3

BR0253W
errno 3: No such process

BR0278I
Command output of '/usr/sap/SID/SYS/exe/run/brconnect':

BR0801I
BRCONNECT 7.20 (30)

PID=11016

BR0252E Fnction

fopen() failed for
'/oracle/SID/sapbackup/.user.pas' at location global_set-1

BR0253E errno 13:Permission denied

BR0074W BRCONNECT

[Former Member]

Hi,

Have you check the note suggested earlier for the patch 31.

Thanks

Rishi Abrol

[Former Member]

Hi Rishi Abrol,

But i have same environmental an non prod ...it is working fine ..anyway i will check the above note .

Thanks,

Dhavan

[former_member206552]

Hi Dhavan

Is this working when you execute the backup from OS ?

brbackup -u / -p initSID.sap -d tape -t online -m all -k no -e 0 -l E -c force

Best Regards

Marius

[Former Member]

Either your brconnect do not have proper permission or '/oracle/SID/sapbackup/.user.pas' do not have persmissions

[Former Member]

Hi,

As you are at patch 30 it looks like that the fix is given in 31 patch.

1838852 - Corrections in BR*Tools 7.20 Patch 31 / 7.40 Patch 1

Thanks

RishI Abrol

[Former Member]

.user.pas file doesn't exit in the location ....what is the file ? is it required for brbackup ?