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: 25352
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: 64731
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: service Database Control on Windows
Next Topic: CSS Service
Goto Forum:

Current Time: Sat Apr 29 14:41:35 CDT 2017

Total time taken to generate the page: 0.11781 seconds