Home » Infrastructure » Windows » Repair/Recover Corrupt Control File (Oracle 10G R2 on Win 2003 Server)
Repair/Recover Corrupt Control File [message #389613] Mon, 02 March 2009 22:55 Go to next message
Messages: 5
Registered: March 2007
Junior Member
For Oracle 10G on Windows 2003 Server:

Can anyone point me to information regarding how-to either repair or recover a control file for a database that has corrupted data files? The control files are unusable.

Re: Repair/Recover Corrupt Control File [message #389620 is a reply to message #389613] Mon, 02 March 2009 23:06 Go to previous messageGo to next message
Messages: 25578
Registered: January 2009
Location: SoCal
Senior Member
>The control files are unusable
All of them went bad at the same time?
How did that happen.

You need to help us by following the Posting Guidelines as stated below.
So we can help you & please be consistent & correct in your postings.

What is the state of the DB now?
Re: Repair/Recover Corrupt Control File [message #389622 is a reply to message #389613] Mon, 02 March 2009 23:07 Go to previous message
Michel Cadot
Messages: 65150
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't repair or recover a control file, you can either:
- copy for another current one
- restore a backup one
- recreate it using CREATE CONTROLFILE


[Updated on: Mon, 02 March 2009 23:08]

Report message to a moderator

Previous Topic: CSS Service
Next Topic: 10G Client and windows 2008 server (32bits)
Goto Forum:

Current Time: Mon Aug 21 16:41:53 CDT 2017

Total time taken to generate the page: 0.01771 seconds