| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re:RE: Any-body faced this earlier ??
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 <Rajesh_at_ohitelecom.com>
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-----
jkstill_at_cybcon.com
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.ctlcp /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: jkstill_at_cybcon.com 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: ListGuru_at_fatcity.com (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: Rajesh_at_ohitelecom.com 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: ListGuru_at_fatcity.com (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: dgoulet_at_vicr.com 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: ListGuru_at_fatcity.com (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).Received on Tue Jan 30 2001 - 09:05:44 CST
 |
 |