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.