You will have to know things like where your datafiles are. Once you have successfully issued the CREATE CONTROLFILE...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
command, then you can do the following:
RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
Specify CANCEL when you have applied all of your redo logs for recovery. Then specify:
ALTER DATABASE OPEN RESETLOGS;
Next, take a backup of your database. If you have succeeded, you do not want to go through this again.
Read this Q & A for more information on what happens with the RECOVER DATABASE with a backup controlfile command.
Finally, examine your backup needs. You should be backing up your control file along with your datafiles.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
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.