Q
Manage Learn to apply best practices and optimize your operations.

How to perform database recovery with a corrupt control file in Oracle

Learn how to perform database recovery with a corrupt control file in Oracle with these step by step instructions, including how to use the CREATE CONTROLFILE command, from Oracle expert Brian Peasland.

How can I perform a database recovery with a corrupt control file in Oracle?
You'll have to manually create the control file. First, take a backup of your database's files so that you can always start over should something go wrong. Then, STARTUP NOMOUNT the database and issue the CREATE CONTROLFILE command. Read more details on the CREATE CONTROLFILE command here.

You will have to know things like where your datafiles are. Once you have successfully issued the CREATE CONTROLFILE...

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;

SHUTDOWN IMMEDIATE

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.

This was last published in December 2009

Dig Deeper on Oracle database backup and recovery

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close