By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
We worked with an Oracle 8i database. One day we reinstalled the operating system in our system, and at that time I took a backup of all database files of the old database (control, redolog, dbf), and now I have installed Oracle again in our system. The problem is I want to connect the existing databse with the newly installed Oracle. Kindly tell me how I retrieve the records from the backup files.
If I understand your situation correctly, you took a backup of your database before you reinstalled the operating system and the Oracle software on your database server. Now you want to recover the database onto this server and be able to open and use it. If the backup was performed correctly and you have all the required components, you should be able to copy the database files, redo log files, control files and temp files back to their original locations, along with the initialization parameter file and simply open the database normally. If your operating system is Windows, you will first need to re-create the database service. I am assuming that an offline backup was taken, as opposed to an online backup. If you took an online backup, you will also need to recover archived redo logs and perform some recovery prior to opening the database.
Dig Deeper on Oracle database backup and recovery
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ...continue reading
Can I use /var/opt/oracle/oratab to specify listener information?continue reading
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error:
"Error in invoking target install of makefile /opt/oracle/...../*.mk."continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.