on 01-24-2007 6:15 PM
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.
Windows 2003 server.
Anyways.. I executed sapdba_role wid SIDDB as param and it worked.. no longer gettin the error ..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.