on 06-25-2009 2:30 PM
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
> 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.