Q

Retrieving database records from backup files

We reinstalled the operating system in our system and took a backup of all database files of the old database (control, redolog, dbf), and now I have installed Oracle again in our system. Kindly tell me how I retrieve the records from the 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.
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

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close