| 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:Any-body faced this earlier ??
Rajesh
Shutdown abort has the subtlety of a crowbar. It is a tool of last resort for me & I'm always afraid of the consequences you've got. Since your on a Unix variant, was any attempt made to find out what was slowing things up? Could you ID a process that was consuming a ton of CPU resources? We use 8.0.4 on HP-UX here and have not seen any unexplainable slowness in the system. Most of the time it's a particular end-user who has done the dirty on us by unleashing the "query from hell". In that case using a "kill -3" on his/her PID usually fixes the problem. You may also want to investigate using PROFILES in your DB. By setting the max amount of time per statement to 10 minutes has helped us in more ways than I care to think.
Dick Goulet
____________________Reply Separator____________________Subject: Any-body faced this earlier ?? Author: Rajesh Dayal <Rajesh_at_ohitelecom.com> Date: 1/28/2001 8:25 PM
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: 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). Received on Mon Jan 29 2001 - 09:12:57 CST
 |
 |