cancel
Showing results for 
Search instead for 
Did you mean: 

BR0278E - Access denied in oracle backup and redolog backup

Former Member
0 Kudos

Hello All,

I have been trying to take a redolog backup from DB13 and I am getting the below error

BR0278E Command output of 'E: && cd E:\oracle\QAS\102\database && E:\usr\sap\QAS\SYS\exe\uc\NTAMD64\brtools.exe -f copyfile
12.6.2.0\Backup\hostname\QAS initQAS.ora spfil

Access is denied.

BR0280I BRARCHIVE time stamp: 2009-06-24 11.36.34

BR0279E Return code from 'E: && cd E:\oracle\QAS\102\database && E:\usr\sap\QAS\SYS\exe\uc\NTAMD64\brtools.exe -f copyfile
12.6.2.0\Backup\hostname\QAS initQAS.ora spfile

In my findings I understood that it may be a hardware inconsistency from the note 17163.

BR0278E Command output of '%s': %s

BR0278E Kommando-Ausgabe von '%s': %s

Explanation: The error messages of this command are displayed. In most cases they are messages from the cpio or mt commands. The following are examples:

Sample messages:

Message/Explanation

cpio:cannot read...

cpio:read error...

cpio:can't read input...

cpio:I/O Error...

cpio:read failed:I/O Error.

The file to be backed up cannot be read. In most cases, this is due to hardware problems on the disk on which the file is stored.

But if i take the archievlog backup using brtools in command prompt level and its working fine and also its getting completed succefully.

I gave the full rights of administrator, backup operators, saplocal and sapglobal admin . And also the drive was shared and the folder access is given with full authoriusation for the user SAPServiceSID.

I am not sure about the root cause of this problem.Anyone have idea on this please do suggest me.

Yesterday I posted the same thread and thought that it solved my problem and closed the thread as well, Sorry.

Vijay

Accepted Solutions (1)

Accepted Solutions (1)

markus_doehr2
Active Contributor
0 Kudos

> I have been trying to take a redolog backup from DB13 and I am getting the below error

> But if i take the archievlog backup using brtools in command prompt level and its working fine and also its getting completed succefully.

> I gave the full rights of administrator, backup operators, saplocal and sapglobal admin . And also the drive was shared and the folder access is given with full authoriusation for the user SAPServiceSID.

The SAP system runs under SAPService<SID>. So if you execute a backup using DB13 that user must be enabled to access that folder.

- Check that the folder and share permissions are set for SAPService<SID> (do that on the remote/target machine, not on the local SAP machine)

- If the target machine is not in the domain you have to make sure the passwords are identical (since those are two different users then).

Markus

Former Member
0 Kudos

Hello Markus,

I have tried your options but still I am getting the same error. Even I have tried to take the backup in the local machine. But still I am getting the same error kindly see the below one.

BR0278E Command output of 'E: && cd E:\oracle\QAS\102\database && E:\usr\sap\QAS\SYS\exe\uc\NTAMD64\brtools.exe -f copyfile K:\Archivelog_backup\QAS initQAS.ora spfileQAS.ora':

Access is denied.

BR0280I BRARCHIVE time stamp: 2009-06-29 18.00.30

BR0279E Return code from 'E: && cd E:\oracle\QAS\102\database && E:\usr\sap\QAS\SYS\exe\uc\NTAMD64\brtools.exe -f copyfile K:\Archivelog_backup\QAS initQAS.ora spfileQAS.ora': 1

BR0222E Copying init_ora to/from K:\Archivelog_backup\QAS failed due to previous errors

I am sure that i gave full full authorisation to the folder and shared the folder as well.

What I suspect is that few weeks before we added few additional disk in the database drive. This would have crossed this problem?

Kindly suggest me

Vijay

Former Member
0 Kudos

check attached note

[https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=994136]

Answers (4)

Answers (4)

Former Member
0 Kudos

I don't know what happened to this server automatically, The backups are running fine now.

For sure we didn't do any changes and restart of the server as well.

No clue on this

Vijay

Former Member
0 Kudos

Hello Markus,

Yes, I have created the user in target machine and for sure with the same user and also its not locked in both the machine(Even i am taking backup using brtools without error). Problem with DB13.

In DB13 - local backup is also getting failed.

Regards

Vijay

markus_doehr2
Active Contributor
0 Kudos

This message was moderated.

anindya_bose
Active Contributor
0 Kudos

Vijay

You can check Note 684106 - Microsoft runtime DLLs

Former Member
0 Kudos

Hello Markus,

Yes, I can able to access the directory through run command without providing any credentials.

Please correct me if I am wrong.

Regards

Vijay

former_member204746
Active Contributor
0 Kudos

at windows level, login as SAPservice[SID], now, try to run your backup manually.

Former Member
0 Kudos

This message was moderated.

Former Member
0 Kudos

Hi

This may be due to permission problems.

Kindly pls check with " brarchive from command prompt with user <sid>adm. Hope this helps you and also see that

user SAP service<sid> has the same permissions on shares and files.

Hope this may help you

Regards

Sirigiri

Former Member
0 Kudos

Hello All,

The error occured because of the oracle users were locked and I have found the same on alertview.log.

Then I have followed sapnote and unlocked the users as well. But now I am getting the new error as

BR0301W SQL error -1017 at location BrDbConnect-2, SQL statement:

'CONNECT system/*******'

ORA-01017: invalid username/password; logon denied

BR0310W Connect to database instance QAS failed

BR0278E Command output of 'E:\oracle\QAS\102\BIN\sqlplus /nolog':

Access is denied.

BR0280I BRARCHIVE time stamp: 2009-06-30 16.20.59

BR0279E Return code from 'E:\oracle\QAS\102\BIN\sqlplus /nolog': 1

BR0302E SQLPLUS call for database instance QAS failed

BR0303E Determination of Oracle version failed

BR0280I BRARCHIVE time stamp: 2009-06-30 16.21.00

BR0301W SQL error -1017 at location BrDbConnect-2, SQL statement:

So, I am working on this issue by following the note 400241 and hope this will work out.

Regards

Vijay

Former Member
0 Kudos

Hello All,

Sorry for the late update.

I have followed the note 400241 but still not able to solve the issue. I am not able to take the backup from DB13 by using a local drive and also in the network drive. Both are getting failed due to the same reason

BR0278E Command output of 'E: && cd E:\oracle\QAS\102\database && E:\usr\sap\QAS\SYS\exe\uc\NTAMD64\brtools.exe -f copyfile
21.10.5.10\backup\Test_NEW\QAS initQAS.ora spfi

Access is denied.

I am sure I have created the service user in network drive with the same password but still no luck, even its getting failed if i try to take a local backup.

Services are running under SAPSeriveSID user and this user is also not locked.

For the past one month I am taking the backup using the BRTOOLS and dont know why this is getting failed in DB13.

Any suggestion are highly appreciable.

Regards

Vijay

markus_doehr2
Active Contributor
0 Kudos

> I am sure I have created the service user in network drive with the same password but still no luck, even its getting failed if i try to take a local backup.

Did you create it on the target machine?

Markus

former_member204746
Active Contributor
0 Kudos

user SAPserviceQAS must be able to read/write to
12.6.2.0\Backup\hostname

is K: a network drive? if this is the case, it will not work.

Former Member
0 Kudos

Hello,

Thanks for your quick reply.

But this is not solved my problem. SAPservice is having read and write access on the K: local drive which is the backup folder and also having full authorisation for all the administrator.

Our brtools version is 38. But I updated the patch to 41 and tried the backup. Still I am getting the same error as like posted above post

Any inputs to solve my issue.

Regards

Vijay

former_member204746
Active Contributor
0 Kudos

Are you able to run the brarchive command at OS level using user QASADM?

anindya_bose
Active Contributor
0 Kudos

Hi Vijay

Where are you taking your redolog backup? Any external disk or disk on some other server?

Thanks and Regards

Anindya