Re: Autorecovery when oracle crash

From: Hans Wijte <Hans.Wijte_at_mail.ing.nl>
Date: 16 Sep 2004 07:07:54 -0700
Message-ID: <2dec747a.0409160607.3cd03bdf@posting.google.com>

"Nicky" <fuffaspam_at_quipo.it> wrote in message news:<ci77fb$3a9$1_at_newsserver.cilea.it>...
> You're right !
>
> > Oracle version : 9.2i enterprise
> > Operating system verison ... win2k
> > Error message ... taken from alertdb.log:
> ORA-00206: error in writing (block 3, # blocks 1) of controlfile
> ORA-00202: controlfile: 'O:\ORALARC\ORADATA\LARCDB\CONTROL03.CTL'
> ORA-27072: skgfdisp: I/O error
> OSD-04008: WriteFile() non riuscito, impossibile scrivere sul file
> O/S-Error: (OS 1453) Disponibilità insufficiente per completare il
> servizio richiesto.
>

The above error suggests that you have a disk problem; somehow, Oracle can not write to the controlfile located on that disk, either because the disk has gone down the drain, or because the authorizations for the controlfile are
such that Oracle can not write to it, etc. I suggest you fix this problem before trying to install another OS

Hans Wijte Received on Thu Sep 16 2004 - 09:07:54 CDT