Q
Problem solve Get help with specific problems with your technologies, process and projects.

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.

Dig Deeper on Oracle database backup and recovery

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close