| Database not starting [message #427447] |
Thu, 22 October 2009 12:13  |
MR[T]
Messages: 41
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 #427457 is a reply to message #427455] |
Thu, 22 October 2009 13:13  |
Michel Cadot
Messages: 29417
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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 #427618 is a reply to message #427617] |
Fri, 23 October 2009 10:04 |
Michel Cadot
Messages: 29417
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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]
|
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
