Home » RDBMS Server » Server Administration » Database not starting
Database not starting [message #427447] Thu, 22 October 2009 12:13 Go to next message
MR[T]
Messages: 62
Registered: March 2009
Member
Hello
My database is not starting . When i startup SQL following errors occur .

ORA-00204: error in reading (block 3, # blocks 8) of control file
ORA-00202: control file: 'L:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL'
ORA-27091: unable to queue I/O
ORA-27070: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file



I have no control file backup .

Regards
MR[T]
Re: Database not starting [message #427449 is a reply to message #427447] Thu, 22 October 2009 12:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It seems you have several control files so remove this from the list.

Regards
Michel
Re: Database not starting [message #427455 is a reply to message #427447] Thu, 22 October 2009 12:57 Go to previous messageGo to next message
MR[T]
Messages: 62
Registered: March 2009
Member
Now i am receving this error


ORA-00205: error in identifying control file, check alert log for more info
Re: Database not starting [message #427456 is a reply to message #427455] Thu, 22 October 2009 13:04 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
MR[T
wrote on Thu, 22 October 2009 10:57]Now i am receving this error


ORA-00205: error in identifying control file, check alert log for more info


Since we don't have a copy of YOUR alert log,
you'll have to do this on your own
Re: Database not starting [message #427457 is a reply to message #427455] Thu, 22 October 2009 13:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-00205: error in identifying control file, check alert log for more info
 *Cause:  The system could not find a control file of the specified name and
           size.
 *Action: Check that ALL control files are online and that they are the same
         files that the system created at cold start time.

As I said:
Quote:
so remove this from the list.

That is remove it from init.ora/spfile.

Regards
Michel
Re: Database not starting [message #427617 is a reply to message #427457] Fri, 23 October 2009 09:38 Go to previous messageGo to next message
halim
Messages: 100
Registered: September 2008
Senior Member


Or

Create CONTROL03.CTL in that place
by copy&paste of CONTROL02.CTL


Regards
Halim
Re: Database not starting [message #427618 is a reply to message #427617] Fri, 23 October 2009 10:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As it seems there are I/O errors on the control file disk I think it is not wise to recreate the control at the same place until the error is fixed. This is why I adviced to just remove it from the control file list.

Regards
Michel

[Updated on: Fri, 23 October 2009 10:04]

Report message to a moderator

Re: Database not starting [message #427636 is a reply to message #427618] Fri, 23 October 2009 12:15 Go to previous messageGo to next message
halim
Messages: 100
Registered: September 2008
Senior Member

Yes, wise advice.

Regards
Halim

[Updated on: Fri, 23 October 2009 12:17]

Report message to a moderator

Re: Database not starting [message #427975 is a reply to message #427447] Mon, 26 October 2009 10:17 Go to previous message
MR[T]
Messages: 62
Registered: March 2009
Member
Thanks Everyone
Now my database is working fine Smile


Regards
MR.T

[Updated on: Mon, 26 October 2009 10:18]

Report message to a moderator

Previous Topic: Problem in using Resource Manager
Next Topic: Database Creation with files on different machines
Goto Forum:
  


Current Time: Fri Dec 02 18:19:33 CST 2016

Total time taken to generate the page: 0.39153 seconds