OH, I don't think I'd have gone that far. Sometimes there is no alternative to
"shutdown abort", but one should allow an immediate to run for a few minutes
first before resorting to the "sledge hammer". Be nice to your DB, but in the
end it has to obey your commands.
Dick Goulet
____________________Reply Separator____________________
Author: Rajesh Dayal <[EMAIL PROTECTED]>
Date: 1/29/2001 8:45 PM
Hi Jared,
Yes you are right. I did try to open the database
with every single control file. I made another approach,
I kept only one control file's name in INIT.ora at one
time and commented out others. But this didn't work out
as well. Also tried to swap the order of datafile names
in CONTROL FILE creation script, but for every first
datafile it gave the same error....
Any-Way "YOU LEARN EVERY DAY .....". I have strongly
advised the "Local DBA" not to use that option, (At most
SHUTDOWN IMMEDIATE).
Thanks Every-Body ....
Rajesh
-----Original Message-----
[EMAIL PROTECTED]
Sent: Monday, January 29, 2001 8:00 PM
To: Multiple recipients of list ORACLE-L
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 :-((
>
> Thanks for your time,
> Rajesh
> --
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rajesh Dayal
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
