Q

No backup, no data

My hard disk crashed and I have not taken any backups. How do I recover the data?

I have used Oracle to store some information. I have not taken any backups. Now the hard disk has crashed. I recovered the database file, control file, *.ora file and log files. How do I get back the data?
I'm sorry to say that your data is most likely lost. If you have not taken any backups then you do not have the files that contain your data. And if you used simple OS utilities to just copy the datafiles, then you most likely have inconsistencies since I'm also going to assume that you are not running in Archive Log mode.

A good backup and recovery strategy is a must for anyone managing a database, of any type! You can recreate the

database from scratch. And you can reconfigure and reinstall software. But it is very hard, and sometimes impossible to recreate data. Backup and recovery are topics that every DBA should be very familiar with for their specific RDBMS.

I would highly recommend reading the Oracle documentation, specifically the Oracle Backup and Recovery Guide to better understand not only how to backup an Oracle database, but how to recover from failures. You can find a copy on Technet.

This was first published in April 2004

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close