Re: Any-body faced this earlier ??

From: <jkstill_at_cybcon.com>
Date: Mon, 29 Jan 2001 08:00:59 -0800 (PST)
Message-Id: <10756.127723@fatcity.com>

Rajesh,

I can't explain why you got the error.

One thing I may be able to help you with though should this happen again, is a better approach than trying to recreate your controlfiles first thing.

Since you already knew that you had a bad controlfile, you should have copied all of the controlfiles to a temporary location.

Then one by one, copy one of the copies of the controlfiles to the locations of the online controlfiles, and attempt to start the database.

e.g.

  cp /u01/oradata/mydb/controlfile_01.ctl /tmp
  cp /u02/oradata/mydb/controlfile_02.ctl /tmp
  cp /u03/oradata/mydb/controlfile_03.ctl /tmp

  cp /tmp/controlfile_01.ctl /u01/oradata/mydb/controlfile_01.ctl

  cp /tmp/controlfile_01.ctl /u01/oradata/mydb/controlfile_02.ctl   cp /tmp/controlfile_01.ctl /u01/oradata/mydb/controlfile_03.ctl

  attempt to startup database

  cp /tmp/controlfile_02.ctl /u01/oradata/mydb/controlfile_01.ctl
  cp /tmp/controlfile_02.ctl /u01/oradata/mydb/controlfile_02.ctl
  cp /tmp/controlfile_02.ctl /u01/oradata/mydb/controlfile_03.ctl

  attempt to startup database

....

That said, it may not have worked in this case. You appear to have a bad file '/data4/oradata/BDCRL/bdcr01.dbf'.

The symptoms would cause me to suspect that there is a hardware problem. Have you checked that possibility?

Jared

On Sun, 28 Jan 2001, Rajesh Dayal wrote:

> 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 :-((
Received on Mon Jan 29 2001 - 10:00:59 CST