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...

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

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