Q

ORA-1157 error with Oracle 8i database restore

I have backed up an Oracle 8i database (Windows-based) with Brightstor software. I restored it and I get an ORA-1157 error.

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?
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

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close