Ask the Expert

Retrieving database records from backup files

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.

    Requires Free Membership to View

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.

This was first published in December 2006

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: