By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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.
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.
Dig Deeper on Oracle database backup and recovery
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.continue reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.continue reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.