Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!pd2nf1so.cg.shawcable.net!residential.shaw.ca!sjc70.webusenet.com!news.webusenet.com!cyclone.bc.net!newsfeed.stanford.edu!postnews1.google.com!not-for-mail From: yls177@hotmail.com (yls177) Newsgroups: comp.databases.oracle.server Subject: database could not be started Date: 8 Aug 2003 17:25:36 -0700 Organization: http://groups.google.com/ Lines: 25 Message-ID: NNTP-Posting-Host: 165.21.154.16 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1060388736 28039 127.0.0.1 (9 Aug 2003 00:25:36 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 9 Aug 2003 00:25:36 GMT Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:240149 this is what actually happens 1) we had scripts to shutdown/startup the database for offline backup in our crontab entries 2) and these scripts had been working fine. 3) but recently, there had been 2 times when the scripts are not working 4) scenario: couldnt startup database therefore go and analyze 5) found that the shutdown script did not shutdown the database. Cos going into svrmgrl, and doing a startup says that "the oracle instance is still running" 5.1) do a ps -ef | grep ora and indeed saw all these oracle processes including the shutdown script entry. 5.2) going back to svrmgrl, did a shutdown immediate. still same result in 5.1 5.3) colleague did a shutdown abort and it works. my questions 1)is that isnt it dangerous to do a shutdown abort. actually, i was thinking about killing all the orace processes. so which is more advisable? 2) what are the valid reasons doing a shutdown abort. thanks