Home » Other » Test » backup error on oracle 10
backup error on oracle 10 [message #401260] Sun, 03 May 2009 08:48 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68617
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: backup error on oracle 10 [message #502496 is a reply to message #401260] Wed, 06 April 2011 15:29 Go to previous messageGo to next message
wintzer
Messages: 1
Registered: April 2011
Location: south africa
Junior Member
Hi

How was your problem resolved ? I'm experiencing the same problem

Thanks in anticipation
Re: backup error on oracle 10 [message #502531 is a reply to message #502496] Thu, 07 April 2011 01:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68617
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This "Test" forum is just to test your post and does not intend to answer actual question.
If you have the same problem, post all relevant information in "Backup & Recovery" forum but before read the OraFAQ Forum Guide to know how to post.

Regards
Michel
Re: backup error on oracle 10 [message #505882 is a reply to message #502531] Thu, 05 May 2011 08:02 Go to previous message
alonzo2u
Messages: 1
Registered: May 2011
Junior Member
testing
Previous Topic: to test links
Next Topic: Forum update
Goto Forum:
  


Current Time: Tue Mar 19 02:52:14 CDT 2024