Skip to Content
author's profile photo Former Member
Former Member

BRARCHIVE / BRBACKUP error

Hi,

I am tryting to execute archive log backup thru BRTOOLS or by

executing the following command :

I:\usr\sap\SID\SYS\exe\run\brarchive.exe -p initSID.sap -save_delete -d util_file -r initSID.utl -n 10000 -k no -l E -c -u /

But in either case it terminates with the following error :

-


E:\oracle\SID\920\scripts>I:\usr\sap\SID\SYS\exe\run\brarchive.exe -p initSID.sap -save_delete -d util_file -r initSID.utl -n 10000 -k no -l E -c -u /

BR0002I BRARCHIVE 6.40 (41)

BR0252E Function fopen() failed for 'E:\oracle\SID\920\saparch\adulouau.svd' at location main-6

BR0253E errno 2: No such file or directory

BR0121E Processing of log file E:\oracle\SID\920\saparch\adulouau.svd failed

BR0280I BRARCHIVE time stamp: 2007-01-24 11.53.10

BR0301W SQL error -1031 at location BraDbLogOpen-5

ORA-01031: insufficient privileges

BR0324W Insertion of database log header failed

BR0007I End of offline redo log processing: adulouau.svd 2007-01-24 11.53.08

BR0280I BRARCHIVE time stamp: 2007-01-24 11.53.10

BR0005I BRARCHIVE terminated with errors

-


Specifications of the system :

EP 6.0 on WAS 640.

Oracle : 9.2.

No SAP instance.

Windows 2003 server.

I have already checked

1) The permissions of SIDADM for the directory SAPARCH etc. and it has 'full control'.

2) Permissions of SIDPADM and SAPServiceSID are similar.

3) R3trans -d gives return code 0. So does R3trans -x.

4) The initSID.utl, initSID.sap and initSID.ora files are fine and similar to rest of the systems.

Please advice.

Cheers

Kunal.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 25, 2007 at 05:32 AM

    brarchive seems unable to find the location of saparch.

    Check 1:

    When did this started failing? Where there any changes made?

    I hope saparch is not 100% full

    Check 2:

    Incase, E:\oracle\SID\920\saparch is a mapped drive, check if the mapping is correct. check if you can access the location.

    Check 3:

    Try creating a 'test file' manualy at location 'E:\oracle\SID\920\saparch.

    Check 4:

    Try to use the latest brarchive version. also check permissions for brarchive.

    Regards,

    Ammey Kesarkar

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 25, 2007 at 06:33 AM

    Hello,

    I see two different errors.

    The first one seem to point to wrong environment variables:

    E:\oracle\SID\920\saparch\adulouau.svd

    This is %ORACLE_HOME%\saparch

    I would expect %SAPARCH%; check note 556232http://service.sap.com/sap/support/notes/556232">556232>

    Second one is

    ORA-01031: insufficient privileges

    Probably you have to apply the sapdba_role. Check note134592http://service.sap.com/sap/support/notes/134592">134592>

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 25, 2007 at 04:01 PM

    Hi All,

    Thanks for your reply. I found that SAPDATA_HOME was not set and setting that solved the problem.

    But I can still see the following error in the log:

    BR0301W SQL error -1031 at location BraDbLogOpen-5

    ORA-01031: insufficient privileges

    BR0324W Insertion of database log header failed

    Tho the archive log backups are running fine now.

    What can we do for this error ? I have already executed sapdba_role.sql but that didnt help.

    Once again, its Oracle 9.2 on Windows 2003 server. No ORASID only SIDADM.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2007 at 02:21 PM

    Windows 2003 server.

    Anyways.. I executed sapdba_role wid SIDDB as param and it worked.. no longer gettin the error ..

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.