DB Full Backup failed in db13 - oracle system

[Former Member]

Dear All,

We are using SAP ECC 6.0 unicode system with Database Oracle 10.2.0.2. I am trying to get a valid full database backup for this system in DB13. We are using Disk ( shared network device ) for taking the backup. It was working fine earlier. But now the Backup is getting failed, i have mentioned the action log below. Please someone help me in this.

BR0051I BRBACKUP 7.00 (31)

BR0055I Start of database backup: beaoucqa.fnd 2009-05-15 21.00.56

BR0484I BRBACKUP log file: H:\oracle\DEV\sapbackup\beaoucqa.fnd

BR0252W Function remove() failed for 'E:\oracle\DEV\102\database\sapDEV.ora' at location BrInitOraCreate-1

BR0253W errno 13: Permission denied

BR0252W Function remove() failed for 'E:\oracle\DEV\102\database\sapDEV.ora' at location BrInitOraCopy-7

BR0253W errno 13: Permission denied

BR0166I Parameter 'control_files' not found in file E:\oracle\DEV\102\database\initDEV.ora - default assumed

BR0165E Parameter 'control_file_record_keep_time' is not set in E:\oracle\DEV\102\database\initDEV.ora

BR0056I End of database backup: beaoucqa.fnd 2009-05-15 21.01.05

BR0280I BRBACKUP time stamp: 2009-05-15 21.01.05

BR0054I BRBACKUP terminated with errors

BR0280I BRBACKUP time stamp: 2009-05-15 21.01.05

BR0291I BRARCHIVE will be started with options '-U -jid FLLOG20090515210000 -d disk -c force -p initdev.sap -cds'

BR0280I BRBACKUP time stamp: 2009-05-15 21.01.11

BR0292I Execution of BRARCHIVE finished with return code 3

Thanks

Raj

[JPReyes · Accepted solution]

Set parameters control_files and control_file_record_keep_time=30 in init<sid>.ora and also check the "shared network device" permissions and try it again.

Regards

Juan

[Former Member · Accepted solution]

Dear Juan,

Thanks for your suggestion. I have checked the mentioned parameters and already it was set to values mentioned below .

-

---

control_file_record_keep_time=30

control_files='H:\oracle\DEV\origlogA\cntrl\cntlrDEV.dbf','H:\oracle\DEV\origlogB\cntrl\cntrlDEV.dbf','H:\oracle\DEV\sapdata1\cntrl\cntrlDEV.dbf'

-

---

Also i have checked the path 'H:\oracle\DEV\origlogA\cntrl\ ' the cntrlDEV.dbf is in place.

Please suggest me

Thanks

Raj

[Former Member · Accepted solution]

Looks like a problem with permissions.

SAP note 1173159 might help.

[Former Member · Accepted solution]

Hi Joe/Juan/All

I have given the permissions as per the note mentioned by Joe, but i am getting another error . I have attached the error log below. I have checked the services Oracle listener and OracleserviceDEV are running under administrator account. Could some one please help me in this ?

-

---

BR0280I BRBACKUP time stamp: 2009-05-27 22.56.08

BR0063I 53 of 53 files processed - 115676.414 MB of 115676.414 MB done

BR0204I Percentage done: 100.00%, estimated end time: 22:56

BR0001I **************************************************

BR0280I BRBACKUP time stamp: 2009-05-27 22.56.08

BR0317I 'Alter tablespace SYSTEM end backup' successful

BR0280I BRBACKUP time stamp: 2009-05-27 22.56.12

BR0530I Cataloging backups of all database files...

BR0278E Command output of 'E:\oracle\DEV\102\BIN\rman nocatalog':

Recovery Manager: Release 10.2.0.2.0 - Production on Wed May 27 22:56:14 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

RMAN>

RMAN> connect target *

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

ORA-12640: Authentication adapter initialization failed

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> 2

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of catalog command at 05/27/2009 22:56:15

RMAN-06171: not connected to target database

RMAN>

Recovery Manager complete.

BR0280I BRBACKUP time stamp: 2009-05-27 22.56.15

BR0279E Return code from 'E:\oracle\DEV\102\BIN\rman nocatalog': 1

BR0536E RMAN call for database instance DEV failed

BR0280I BRBACKUP time stamp: 2009-05-27 22.56.15

BR0532E Cataloging backups of all database files failed

BR0056I End of database backup: bearaxbh.fnd 2009-05-27 22.56.15

BR0280I BRBACKUP time stamp: 2009-05-27 22.56.15

BR0054I BRBACKUP terminated with errors

-

---

Thanks

Raj

[Former Member · Accepted solution]

Hi

ORA-12640: Authentication adapter initialization failed refers to failure of authentication services line in the file tnsnames.ora, try to modify SQLNET.ORA, start the database with SQL*Plus after the service is started, or start the service as a specific user. You may have to enable the trace to determine the exact error.

Ravi

[Former Member]

Issue is with oracle paramter and it's resolved with the help of SAPsupport. Thanks for all.

[Former Member]

Hi Raja,

i am having exactly the same error, could you please be so kind to share what actions where done?

Greatings

[Former Member]

Please share with the fix. I am having same problem

[Former Member]

Please share with the fix. I am having same problem

[Former Member]

Pls check the permission for the database directory....

[Former Member]

what is your rman script?

[Former Member]

Dear Ravi,

Kindly suggest me what i need to change in .ora file to give authentication .

Thanks

Raj

[Former Member]

Hi

You may either remove the line from SQLNET.ORA:

sqlnet.authentication_services=(NTS)

OR change it to

sqlnet.authentication_services=(NONE)

This is a workaround for windows, try it and update the thread.

Ravi

Edited by: ravi raj on May 29, 2009 10:10 AM