cancel
Showing results for 
Search instead for 
Did you mean: 

Online backup by DB13 ended with error not by BRTOOLS

Former Member
0 Kudos

Dear Friends,

I am trying to take online backup by DB13 of my CRM Dev system but it is ended with error , but when i check in SM37 it show finished.

By using BRTOOLS it work proparly but not by DB13.

Other Details :-

OS :- Win 2003 server

DB :- Oracle 10g

error message is :-

-


Detail log: bdxbnwwr.ant

BR0051I BRBACKUP 7.00 (26)

BR0055I Start of database backup: bdxbnwwr.ant 2008-01-19 10.48.21

BR0484I BRBACKUP log file: F:\oracle\CD1\sapbackup\bdxbnwwr.ant

BR0252W Function remove() failed for 'f:\oracle\cd1\102\database\sap.ora' at location BrInitOraCreate-1

BR0253W errno 13: Permission denied

BR0252W Function remove() failed for 'f:\oracle\cd1\102\database\sap.ora' at location BrInitOraCopy-7

BR0253W errno 13: Permission denied

BR0166I Parameter 'control_files' not found in file f:\oracle\cd1\102\database\initCD1.ora - default assumed

BR0252E Function CreateFile() failed for 'G:\ORACLE\CD1\SAPDATA3\TEMP_1\TEMP.DATA1' at location BrFileStatGet-2

BR0253E errno 5: Access is denied.

BR0273E Determination of file status for G:\ORACLE\CD1\SAPDATA3\TEMP_1\TEMP.DATA1 failed

BR0314E Collection of information on database files failed

BR0056I End of database backup: bdxbnwwr.ant 2008-01-19 10.48.45

BR0280I BRBACKUP time stamp: 2008-01-19 10.48.45

BR0054I BRBACKUP terminated with errors

-


So please help on this issue and reply ASAP.

Thanks,

Regards,

Sachin Jadhav

BASIS

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

check whether SIDadm user is part of dba group?

Make sure that directory or executables like SAPDBA,

BRBACKUP, BRARCHIVE, BRRESTORE, BRRECOVER, BRCONNECT

and BRTOOLS have correct authorizations

Please refer the snote: 113747.

Run the sapdaba role to update the proper authorizations

Oracle 10g: sqlplus /nolog @sapdba_role <SID>

(you can get it from \usr\sap\<SID>\SYS\exe\run folder)

what is output?

regards,

kaushal

Answers (5)

Answers (5)

Former Member
0 Kudos

Hello All

I had struggeled with this problem myself for weeks, but found the solution.

SAP Note 40730 - <SID>adm user cannot start database details the following steps that resolved this for me:

Change permissions of the oracle executable in the bin directory to match above requirments :

chown ora<SID> oracle

chgrp dba oracle

chmod 6755 oracle

It may also be worthwile to chech <SID>adm is in the dba group of

/etc/group.

grep dba /etc/group

I was then able to start a backup successfully.

Hope I can score my first few points with this.....

Former Member
0 Kudos

Hello Friends,

I m facing one problem while taking backup form db13. can sombuddy help me to solve this problem following is the log file details

Job started

Step 001 started (program RSDBAJOB, variant &0000000000011, user ID BASIS)

Execute logical command BRBACKUP On host eccqa

Parameters:-u / -jid FLLOG20081015143102 -c force -t online -m full -p initIEQ.sap.wed -a -c force -p initIEQ.s

ap.wed -s

BR0051I BRBACKUP 7.00 (32)

BR0055I Start of database backup: bdzapxni.fnd 2008-10-15 14.31.02

BR0484I BRBACKUP log file: /oracle/IEQ/sapbackup/bdzapxni.fnd

BR0280I BRBACKUP time stamp: 2008-10-15 14.31.02

BR0301E SQL error -27140 at location BrDbConnect-2, SQL statement:

'CONNECT /'

ORA-27140: attach to post/wait facility failed

BR0310E Connect to database instance IEQ failed

BR0280I BRBACKUP time stamp: 2008-10-15 14.31.02

BR0301E SQL error -27140 at location BrDbConnect-2, SQL statement:

'CONNECT /'

ORA-27140: attach to post/wait facility failed

BR0310E Connect to database instance IEQ failed

BR0056I End of database backup: bdzapxni.fnd 2008-10-15 14.31.02

BR0280I BRBACKUP time stamp: 2008-10-15 14.31.02

BR0054I BRBACKUP terminated with errors

BR0280I BRBACKUP time stamp: 2008-10-15 14.31.02

BR0291I BRARCHIVE will be started with options '-U -jid FLLOG20081015143102 -d disk -c force -p initIEQ.sap.wed -s'

BR0002I BRARCHIVE 7.00 (32)

BR0006I Start of offline redo log processing: adzapxni.sve 2008-10-15 14.31.02

BR0484I BRARCHIVE log file: /oracle/IEQ/saparch/adzapxni.sve

BR0280I BRARCHIVE time stamp: 2008-10-15 14.31.02

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

'CONNECT /'

ORA-27140: attach to post/wait facility failed

BR0310W Connect to database instance IEQ failed

BR0280I BRARCHIVE time stamp: 2008-10-15 14.31.02

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

'CONNECT /'

ORA-27140: attach to post/wait facility failed

BR0310W Connect to database instance IEQ failed

BR0278W Command output of '/oracle/IEQ/102_64/bin/sqlplus /nolog < /oracle/IEQ/saparch/.adzapxni.spi':

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Oct 15 14:31:02 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SQL> Connected to an idle instance.

SQL>

SQL> ORA-01034: ORACLE not available

SQL> Disconnected

BR0280I BRARCHIVE time stamp: 2008-10-15 14.31.02

BR0279W Return code from '/oracle/IEQ/102_64/bin/sqlplus /nolog < /oracle/IEQ/saparch/.adzapxni.spi': 0

BR0302W SQLPLUS call for database instance IEQ failed

BR0323W 'Archive log list' for database instance IEQ failed

BR0252E Function fopen() failed for '/oracle/IEQ/saparch/archIEQ.log' at location arch_last_get-1

BR0253E errno 13: Permission denied

BR0016I 0 offline redo log files processed, totalsize 0.000 MB

BR0280I BRARCHIVE time stamp: 2008-10-15 14.31.02

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

'CONNECT /'

ORA-27140: attach to post/wait facility failed

BR0310W Connect to database instance IEQ failed

BR0252W Function fopen() failed for '/oracle/IEQ/saparch/archIEQ.log' at location BrCleanup-8

BR0253W errno 13: Permission denied

BR0121W Processing of log file /oracle/IEQ/saparch/archIEQ.log failed

BR0007I End of offline redo log processing: adzapxni.sve 2008-10-15 14.31.02

BR0280I BRARCHIVE time stamp: 2008-10-15 14.31.02

BR0005I BRARCHIVE terminated with errors

BR0280I BRBACKUP time stamp: 2008-10-15 14.31.02

BR0292I Execution of BRARCHIVE finished with return code 3

External program terminated with exit code 3

BRBACKUP returned error status E

Job finished

it showing me above messege every time ..

Thanks

Vijay

Former Member
0 Kudos

Thanks,

my problem has been resolved and updated in forum.

Thanks again to all for support.

Regards,

Sachin Jadhav

BASIS

Former Member
0 Kudos

Dear Friends,

My problem has been resolved by just adding user permission to error file by comparing to other server (WIn 2003 server).

So thanks for your response showing

Regards,

Sachin JAdhav

BASIS

Former Member
0 Kudos

Dear Sachin,

i also have the same error, when i take online backup (schedule backup) of QAS through BR Tools then the error comes

BR0301E SQL ERROR-1017 AT location BR DBCONNECT-2, SQL statement, and ORA-01017: Invalid username/password, login denied.

BR0310E CONNECT TO DATABASE INSTANCE QAS failed.

Dear sachin, this error is not appear before as i take through this backup since 04 to 05 months, but now this error occurs when i see through dbacockpit.

Regards,

Yasir

Former Member
0 Kudos

Dear Sachin,

i also have the same error, when i take online backup (schedule backup) of QAS through BR Tools then the error comes

BR0301E SQL ERROR-1017 AT location BR DBCONNECT-2, SQL statement, and ORA-01017: Invalid username/password, login denied.

BR0310E CONNECT TO DATABASE INSTANCE QAS failed.

Dear sachin, this error is not appear before as i take through this backup since 04 to 05 months, but now this error occurs when i see through dbacockpit.

Regards,

Yasir

Former Member
0 Kudos

Thanks Sachin,

You are correct, it is user permission problem on that particular file.

Our host is windows, we just added SAPServiceSID user to this file and our problem got solved.

Many thanks,

Mohan.

Former Member
0 Kudos

Hi Frined,

But how can i check "check whether SIDadm user is part of dba group?"

Also "Make sure that directory or executables like SAPDBA, BRBACKUP, BRARCHIVE, BRRESTORE, BRRECOVER, BRCONNECT and BRTOOLS have correct authorizations Please refer the snote: 113747.

" it is related to unix platform and out platform is WIn 2003 server

Can i run "sqlplus /nolog @sapdba_role" directly on commond prompt

OS :- Win 2003 server

DB :- Oracle 10g

Please reply,

Thanks,

Regards,

Sachin

Former Member
0 Kudos

Hi,

yes

run sqlplus /nolog @sapdba_role <SID> directly on commond prompt

what is output?

regards,

kaushal

0 Kudos

Hello,

The error that was reported is:

BR0252W Function remove() failed for 'f:\oracle\cd1\102\database\sap.ora' at location BrInitOraCreate-1

BR0253W errno 13: Permission denied

BR0252W Function remove() failed for 'f:\oracle\cd1\102\database\sap.ora' at location BrInitOraCopy-7

BR0253W errno 13: Permission denied

BR0166I Parameter 'control_files' not found in file f:\oracle\cd1\102\database\initCD1.ora - default assumed

BR0252E Function CreateFile() failed for 'G:\ORACLE\CD1\SAPDATA3\TEMP_1\TEMP.DATA1' at location BrFileStatGet-2

BR0253E errno 5: Access is denied.

Those are OS errors, running sapdba_role will NOT help.

What you have to check is if the user that is running the BRTOOLS have proper authorizations on the files/direcories indicated.

Which user are you connected as?