Skip to Content
avatar image
Former Member

Online backup by DB13 ended with error not by BRTOOLS

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 24, 2008 at 09:10 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 24, 2008 at 10:23 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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?

  • avatar image
    Former Member
    Jan 24, 2008 at 12:50 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 24, 2008 at 01:04 PM

    Thanks,

    my problem has been resolved and updated in forum.

    Thanks again to all for support.

    Regards,

    Sachin Jadhav

    BASIS

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 15, 2008 at 09:28 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 17, 2009 at 07:56 AM

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

    Add comment
    10|10000 characters needed characters exceeded