ORA-00204: error in reading (block string, # blocks string) of controlfile

[Former Member]

dear all

when i start db

with command sqlplus "/as sysdba"

at the end it generate an error

C:\Documents and Settings\idsadm>sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Oct 20 12:47:37 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 557842432 bytes

Fixed Size 1250140 bytes

Variable Size 289410212 bytes

Database Buffers 264241152 bytes

Redo Buffers 2940928 bytes

ORA-00204: error in reading (block 3, # blocks 50) of control file

ORA-00202: control file: 'F:\ORACLE\IDS\SAPDATA1\CNTRL\CNTRLIDS.DBF'

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).

[former_member266763]

Solution that worked(SLES Linux):

1. Cut a file cntrlSID.dbf from path /oracle/SID/origlogA to other path (As a copy).

2. Copy cntrlSID.dbf from path /oracle/SID/origlogB/ to /oracle/SID/origlogA/

3. chown -R orasid:dba /oracle/SID/origlogA/cntrlSID.dbf

4.SQL> startup;

[Former Member]

hi imran,

it seems that you oracle database control file is corrupted. get another copy from another place. If this is your production server, you should have it.

ardhian

http://sapbasis.wordpress.com

[Former Member]

i have a copy of that control file but it is looking correcpt,

plz tell me can i create new control file , If yes then send me the Procedure

regard

[former_member227600]

Hi,

ORA-00204: error in reading (block 3, # blocks 50) of control file
ORA-00202: control file: 'F:\ORACLE\IDS\SAPDATA1\CNTRL\CNTRLIDS.DBF'
ORA-27091: unable to queue I/O
ORA-27070: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file

It seems that your control file is corrupted.Remname the control file & copy the control file from another location(make sure your database is shutdown) & try to restart the oracle.

karan

[Former Member]

dear karan & all

i have copied "control file" from another location but now it generate an error

SQL> startup

ORACLE instance started.

Total System Global Area 557842432 bytes

Fixed Size 1250140 bytes

Variable Size 289410212 bytes

Database Buffers 264241152 bytes

Redo Buffers 2940928 bytes

ORA-00211: control file does not match previous control files

ORA-00202: control file: 'F:\ORACLE\IDS\SAPDATA1\CNTRL\CNTRLIDS.DBF'

SQL>

now tell me what can i do

regard

[Former Member]

check note 546006. If you are using an NT system try reeboting server. There are chances that file is already in use