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

    Login

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top