cancel
Showing results for 
Search instead for 
Did you mean: 

BRARCHIVE / BRBACKUP error

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Windows 2003 server.

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

which operating system user was used to run brconnect?

Former Member
0 Kudos

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 <a href="http://service.sap.com/sap/support/notes/556232">556232</a>

Second one is

ORA-01031: insufficient privileges

Probably you have to apply the sapdba_role. Check note<a href="http://service.sap.com/sap/support/notes/134592">134592</a>

Former Member
0 Kudos

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