I have backed up an Oracle 8i database (Windows-based) with Brightstor software. I restored it and I get an ORA-001157 error. I have noticed that the process is looking for *.ora datafile and I have *.dbf datafile. Do you have any suggestion about it?

    Requires Free Membership to View

The ORA-1157 error is saying that a file is missing. Look in your Alert Log and you will see which file Oracle cannot find. You'll have to restore that file as well.

This was first published in April 2007

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

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