Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news.glorb.com!cyclone1.gnilink.net!gnilink.net!peer01.cox.net!cox.net!p01!fed1read03.POSTED!not-for-mail
From: AnaCDent <anacedent@hotmail.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: My oracle server is stuck in Started (NO MOUNT) mode!!
References: <j5_bc.15592$kc2.318335@nnrp1.uunet.ca>
In-Reply-To: <j5_bc.15592$kc2.318335@nnrp1.uunet.ca>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 25
Message-ID: <7j_bc.114778$Bg.69830@fed1read03>
Date: Sun, 04 Apr 2004 13:34:10 -0700
NNTP-Posting-Host: 68.7.204.31
X-Complaints-To: abuse@cox.net
X-Trace: fed1read03 1081110851 68.7.204.31 (Sun, 04 Apr 2004 16:34:11 EDT)
NNTP-Posting-Date: Sun, 04 Apr 2004 16:34:11 EDT
Organization: Cox Communications
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:258905

Don Vaillancourt wrote:
> My oracle server for some reason is stuck in Started (No Mount) mode.
> 
> 
> When I try to mount it I get the following error:
> 
> 
> ORA-00204: error in reading (block 3, # blocks 1) of controlfile
> ORA-00202: controlfile: 'C:\ORACLE\ORADATA\PRISM\CONTROL01.CTL'
> ORA-27091: skgfqio: unable to queue I/O
> ORA-27070: skgfdisp: async read/write failed
> OSD-04006: ReadFile() failure, unable to read from file
> O/S-Error: (OS 23) Data error (cyclic redundancy check)

Take a cold backup of your system before doing anything else.
You should have more than 1 control file.
What are the complete pathnames for all the control files?
It appears that you have a disk problem.
Can you verify at the OS level if all is OK with this disk?
Rename the suspect file out of the way.
COPY one of the other control files to be named the same
as the one being reported with the problem.
Then try to startup the DB again.
What happens?