OraFAQ Forum: Server Administration » ORA-01507: database not mounted (merged)

Home » RDBMS Server » Server Administration » ORA-01507: database not mounted (merged)

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

ORA-01507: database not mounted (merged) [message #386098]

Thu, 12 February 2009 12:06

piraba
Messages: 2
Registered: February 2009
Location: colombo

Junior Member

of control file
ORA-00202: control file:
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\EMPLOYEE\CONTROL03.CTL'
ORA-27091: unable to queue I/O
ORA-27070: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 23) Data error (cyclic redundancy check).

how can i fix this error?
please anybody help me.

Report message to a moderator

Re: ORA-01507: database not mounted [message #386099 is a reply to message #386098]

Thu, 12 February 2009 12:14

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

shutdown the database, drop the control file, remove it from the control file list and restart.

Regards
Michel

Report message to a moderator

ORA-01507: database not mounted [message #386101 is a reply to message #386098]

Thu, 12 February 2009 12:25

piraba
Messages: 2
Registered: February 2009
Location: colombo

Junior Member

SQL> connect / as sysdba
Connected.
SQL> shutdown immediate
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 205523844 bytes
Database Buffers 398458880 bytes
Redo Buffers 7135232 bytes
ORA-00204: error in reading (block 3, # blocks Cool of control file
ORA-00202: control file:
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\EMPLOYEE\CONTROL03.CTL'
ORA-27091: unable to queue I/O
ORA-27070: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 23) Data error (cyclic redundancy check).

how can i fix this error?
please anybody help me.

Report message to a moderator

Re: ORA-01507: database not mounted [message #386105 is a reply to message #386101]

Thu, 12 February 2009 12:43

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Same answer as in other topic.
Do not crosspost your question but read OraFAQ Forum Guide
In particular, "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Regards
Michel

Report message to a moderator

Previous Topic:	Should I pass or keep this alert message?
Next Topic:	DB Link

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 15:34:25 CST 2024