Ask the Expert

Recover deleted database from data files, control files

We use Oracle 10g Server. We deleted a database from the server because we have capacity problems in the server and that database seemed useless. But later we noticed that it was Requisite Pro which was using that database. Before we had deleted that database from the server, we copied all the datafiles, control files, log files to some folder. So we have all the files. Now my question is how can I recover my database back from the files again? Thanks in advance.

    Requires Free Membership to View

Was the database down when you copied the datafiles? If so, then look at the suggestions in my previous answer "Restoring database on test machine." If the database was up and running when you copied the datafiles, then you have an inconsistent backup. Without archived redo logs, you will not be able to open the database.

This was first published in May 2007

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: