| backup error on oracle 10 [message #401260] |
Sun, 03 May 2009 08:48  |
sia_tm
Messages: 1
Registered: May 2009
Location: USA
|
Junior Member |
|
|
| sia[ 2 votes ] |
| 1. |
|
 2 / 100% |
Hi guys,
Pls advise me in this problem, because my database backup failed.
BR0051I BRBACKUP 7.00 (33)
BR0055I Start of database backup: beamlwnl.fnr 2009-01-03 14.56.13
BR0484I BRBACKUP log file: /oracle/XXX/sapbackup/beamlwnl.fnr
BR0280I BRBACKUP time stamp: 2009-01-03 14.56.15
BR0301W SQL error -1031 at location BrDbfInfoGet-32, SQL statement:
'DELETE FROM SAP_SDBAH WHERE BEG > '10000000000000' AND BEG < '20080329000000''
ORA-01031: insufficient privileges
BR0280I BRBACKUP time stamp: 2009-01-03 14.56.15
BR0301W SQL error -1031 at location BrDbfInfoGet-33, SQL statement:
'DELETE FROM SAP_SDBAD WHERE BEG > '10000000000000' AND BEG < '20080329000000''
ORA-01031: insufficient privileges
BR0280I BRBACKUP time stamp: 2009-01-03 14.56.15
BR0301E SQL error -1031 at location BrComprDurGet-1, SQL statement:
'OPEN curs_11 CURSOR FOR'
'SELECT FUNCT, POS, LINE FROM SAP_SDBAD WHERE BEG = '00000000000001' AND FUNCT IN ('CMP', ' ', '
', 'DUR', 'DUL') ORDER BY FUNCT, POS'
ORA-01031: insufficient privileges
BR0314E Collection of information on database files failed
BR0280I BRBACKUP time stamp: 2009-01-03 14.56.15
BR0301W SQL error -1031 at location BrbDbLogOpen-5, SQL statement:
'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('20090503145613', 'fnr
', 'S12', ' ', '9999', ' ', 'beamlwnl', '7.00 (33)')'
ORA-01031: insufficient privileges
BR0324W Insertion of database log header failed
BR0056I End of database backup: beamlwnl.fnr 2009-01-03 14.56.15
BR0280I BRBACKUP time stamp: 2009-01-03 14.56.15
BR0054I BRBACKUP terminated with errors
I mention that I have Oracle 10.2.0.2.0 and that the permissions for OPS$ users are set correctly:
SQL> select granted_role from dba_role_privs where grantee = 'OPS$XXXADM';
GRANTED_ROLE
------------------------------
SAPDBA
RESOURCE
CONNECT
SQL> select granted_role from dba_role_privs where grantee = 'OPS$ORAXXX';
GRANTED_ROLE
------------------------------
SAPDBA
RESOURCE
CONNECT
Thank you
|
|
|
|
| Re: backup error on oracle 10 [message #401265 is a reply to message #401260] |
Sun, 03 May 2009 09:13  |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Welcome to the forum.
Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).
Regards
Michel
[Updated on: Sun, 03 May 2009 09:13] Report message to a moderator |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
