Home » RDBMS Server » Server Administration » Control file corrupt (Oracle 10g R2)
Control file corrupt [message #504679] Wed, 27 April 2011 05:36 Go to next message
mahmud732
Messages: 82
Registered: October 2009
Location: Dhaka
Member
Dear all,

I am using oracle 10g R2. Somehow control file is corrupted and database is not open. and there is no backup of control file. Now i need to open the database without recreating the database. How does it possible.
Please help me.


Regards

Mahmud

Report message to a moderator

Re: Control file corrupt [message #504685 is a reply to message #504679] Wed, 27 April 2011 06:22 Go to previous messageGo to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
if you know all your datafiles you can create your control file.

1. Start DB in nomount.
2. Create control file.
2. Alter database open.

Cheers
Ridhi

Report message to a moderator

Re: Control file corrupt [message #504692 is a reply to message #504679] Wed, 27 April 2011 06:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Copy another control file into the corrupted one and startup the database.

Regards
Michel

Report message to a moderator

Re: Control file corrupt [message #505762 is a reply to message #504692] Wed, 04 May 2011 14:25 Go to previous messageGo to next message
malalation
Messages: 12
Registered: April 2011
Junior Member
Quote:
Copy another control file into the corrupted one and startup the database.


You can use a valid control file since the control file is multiplexed!

To view the paths of your control files, check the parameter control_files:

SQL> show parameter control_files


This should give you the paths of your database control files separated by commas.

Report message to a moderator

Re: Control file corrupt [message #508345 is a reply to message #505762] Fri, 20 May 2011 07:43 Go to previous messageGo to next message
venkatgargeyagmailcom
Messages: 20
Registered: October 2010
Location: hyderabad
Junior Member
If you are controlfile is traced then

in trace file you find as

create controlfile........
max datafiles.....
ma redolog members.......

etc

copy it to a new file e.g newcon.ctl

startup nomount

run the newcon.ctl file
alter database open;

Report message to a moderator

Re: Control file corrupt [message #508347 is a reply to message #508345] Fri, 20 May 2011 07:52 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No need to do all of these, don't you read what we have posted?

Regards
Michel

Report message to a moderator

Previous Topic: controlfile
Next Topic: insufficent privliges to other user(exclude sys)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 01 12:27:34 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.