Any-body faced this earlier ??

From: Rajesh Dayal <Rajesh_at_ohitelecom.com>
Date: Mon, 29 Jan 2001 08:31:07 +0400
Message-Id: <10755.127695@fatcity.com>

Hi All,

        Yesterday I faced the most awesome incident. One of the sites are running Oracle 8.0.4 on TRU64 UNIX 4.0 f . Just to come out of an "EXTREMELY" slow running Database, the Local DBA Shutdown Aborted the Database.

        After that the Database refused to come up !!! The trace file has following error reported :

Corrupt block relative dba: 0x00000001 file=0. blocknum=1. Completely zero block found during control file header read ORA-227 signalled during: alter database mount... Shutting down instance (abort)

        Realizing corruption of control file, I tried to create the control files. this also failed with following errors:

ORA-01503: CREATE CONTROLFILE failed
ORA-01160: file is not data file
ORA 01110: data file: '/data4/oradata/BDCRL/bdcr01.dbf' 

	Can someone explain that why this shutdown abort

corrupted all the controlfiles and datafiles? Is it just the incompletion of checkpoint causing this corruption? Has anybody experienced this earlier? I am totally stumped :-((

Thanks for your time, Received on Sun Jan 28 2001 - 22:31:07 CST