on 03-02-2009 2:01 PM
Hello All,
We are running ECC 6.0 system in Oracle and we have scheduled the Full online backup+redolog backup eery weekend. But the backup fails with the following error
BR0530I Cataloging backups of all database files...
BR0278E Command output of 'E:\oracle\SID\102\BIN\rman nocatalog':
Recovery Manager: Release 10.2.0.2.0 - Production on Sat Feb 28 14:08:26 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN>
RMAN> connect target *
connected to target database: SID (DBID=130858580)
using target database control file instead of recovery catalog
RMAN> *end-of-file*
RMAN>
host command complete
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of catalog command on default channel at 02/28/2009 14:08:31
ORA-19625: error identifying file
xxx.xx.x.xxx\BACKUP\hostname\BEAAGPUK\DIMD.DATA1
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.
RMAN>
Recovery Manager complete.
BR0280I BRBACKUP time stamp: 2009-02-28 14.08.31
BR0279E Return code from 'E:\oracle\SID\102\BIN\rman nocatalog': 1
BR0536E RMAN call for database instance SID failed
BR0280I BRBACKUP time stamp: 2009-02-28 14.08.31
BR0532E Cataloging backups of all database files failed
BR0056I End of database backup: beaagpuk.fnd 2009-02-28 14.08.31
BR0280I BRBACKUP time stamp: 2009-02-28 14.08.31
BR0054I BRBACKUP terminated with errors
I have checked the permission and its fine at OS level. I have also created the SAPServiceSID user in the backup device. Still we face this issue.
Kindly suggest
Regards,
Anand
Hello,
you have to consider that the process that finally accesses the file on the share is an Oracle serverprocess and therefore runs as the user that was entered in the service control panel for the Oracle Service (regardless of the fact that rman itself was started by the sapservice<SID>).
In many cases, this will be the 'local system' user which then can cause problems here depending on your authorization concept.
Best Regards,
Michael
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
Your problem is seem like authentication try following.
>1 You can create a password file using the password file creation utility, ORAPWD.
>2 Set the REMOTE_LOGIN_PASSWORDFILE initialization parameter to
>EXCLUSIVE
Hope it will help you
Abhijeet
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> RMAN-03009: failure of catalog command on default channel at 02/28/2009 14:08:31
> ORA-19625: error identifying file
xxx.xx.x.xxx\BACKUP\hostname\BEAAGPUK\DIMD.DATA1
> ORA-27041: unable to open file
> OSD-04002: unable to open file
> O/S-Error: (OS 5) Access is denied.
> I have checked the permission and its fine at OS level.
"fine" means: SAPService<SID> can read and write that file? There is an OS permission problem still...
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You could try like
- change the local policy so SAPService<SID> can logon interactively
- as whatever logged on user you can do an "runas /user:SAPService<SID> cmd.exe". This will give you a command prompt in the user context of SAPService<SID>
- then you can try to create a file e. g. "notepad
xxx.xx.x.xxx\BACKUP\hostname\BEAAGPUK\TEST.txt"
- enter some random text and save it
Markus
Hello Markus,
As I was in leave for a while I have not followed up this message and sorry for the same.
I am able to access the backup disk with user id SAPService<SID> and i have tried created the folders / files which is successful. I am doing backup with brtools and its success but this fails from DB13.
Kindly help on the same
Regards,
Anand
Hello Markus / Michael,
Thanks for your time and reply
@Markus - I schedule the backup with brtools by logging in as <SID>adm
@Michael - Yes I have checked and all the oracle services are starting with local user account. Shall i change this to administrator? Please suggest
Thanks again
Regards,
Anand
Hello everyone
I have exactly the same problem as described above
>
> The issue is solved and the solution provided by Michael helped.
Can you please write what did you exactly do to solve this problem? I tried to set up permission in many diffrent ways (even giving the full access to the share to Everyone) but it didn't help.
Any help highly appreciate
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
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.