We recently did a system refresh from PRD to TEST. After that, our backup failed in TEST with the following error. We are running R/3 4.6C, Oracle 9.2 (with BR tools 6.4).
 
BR0051I BRBACKUP 6.40 (25)
BR0055I Start of database backup: bdtjahza.anf 2006-08-26 10.00.38
BR0280I BRBACKUP time stamp: 2006-08-26 10.00.39
BR0301E SQL error -942 at location BrLicCheck-32
ORA-00942: table or view does not exist
BR0056I End of database backup: bdtjahza.anf 2006-08-26 10.00.39
BR0280I BRBACKUP time stamp: 2006-08-26 10.00.39
BR0054I BRBACKUP terminated with errors

    Requires Free Membership to View

I do not recognize the messages from the backup utility you are using. These are not Oracle messages nor RMAN messages. However, the ORA-00942 error shows your problem. The user the backup utility connects to the database with most likely does not have permissions to select from a table or view. You'll have to figure out which tables or views this utility needs and grant appropriate access for that user.

This was first published in September 2006

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: