RMAN Error in DB13

[Former Member]

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

[Former Member · Accepted solution]

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

[former_member220071]

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

[markus_doehr2]

> 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

[Former Member]

Hello Markus,

Thanks for your reply

I have created the SAPServiceSID user at the NAS. The backup goes fine and it fails only when trying to catolog with RMAN. Do you suggest any way of testing the authorization for the SAPServiceSID user?

Regards,

Anand

[markus_doehr2]

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

[Former Member]

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

[Former Member]

Hello All,

Any idea on this error? Please suggest

Regards,

Anand

[markus_doehr2]

> I am doing backup with brtools and its success but this fails from DB13.

Which user did you use when it worked?

Markus

[Former Member]

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

[markus_doehr2]

> @Markus - I schedule the backup with brtools by logging in as <SID>adm

Can you do the same when logging in as SAPService<SID>?

Markus

[Former Member]

Hello Markus / Michael,

The issue is solved and the solution provided by Michael helped. Thanks for your time ans support

Regards,

Anand

[Former Member]

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