OraFAQ Forum: Server Administration » Database not starting

Home » RDBMS Server » Server Administration » Database not starting

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database not starting [message #427447]

Thu, 22 October 2009 12:13

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]

Report message to a moderator

Re: Database not starting [message #427449 is a reply to message #427447]

Thu, 22 October 2009 12:31

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: Database not starting [message #427455 is a reply to message #427447]

Thu, 22 October 2009 12:57

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

Report message to a moderator

Re: Database not starting [message #427456 is a reply to message #427455]

Thu, 22 October 2009 13:04

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: Database not starting [message #427457 is a reply to message #427455]

Thu, 22 October 2009 13:13

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: Database not starting [message #427617 is a reply to message #427457]

Fri, 23 October 2009 09:38

halim
Messages: 100
Registered: September 2008

Senior Member

Or

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

Regards
Halim

Report message to a moderator

Re: Database not starting [message #427618 is a reply to message #427617]

Fri, 23 October 2009 10:04

Michel Cadot
Messages: 68665
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