Precisely. I am trying to propose the abort option, but I am not the majority around this place I call work.. :) On a more than dozen times in the last few months, I had to kill oracle processes to get the database to shutdown (with immediate), so the scheduled reboot of the machine will continue... And on a number of occasions, the Sunday reboot actually took the server down (and brought it up) on Monday mornings.... when users complained that they could not get to databases that were shutdown properly with 'shutdown immediate'.....
- Kirti -----Original Message----- Sent: Thursday, April 03, 2003 9:24 AM To: Multiple recipients of list ORACLE-L the problem is, if immediate hangs and you have automated the process... nothing happens. it doesn't time out so you sit. and sit and sit. and hope that whatever is keeping the database active will eventually end. In version 7 (7.3.2) I found that while using a third party monitoring package that had a job in the job queue that ran frequently enough (and you WANT monitoring software to monitor things!) that we could never use a shutdown immediate --- "Pardee, Roy E" <[EMAIL PROTECTED]> wrote: > I am certainly not suggesting that recovery can't handle a crash--I'm > just > trying to make sure that I understand what shutdown abort does. Some > posts > have implied that it's no big deal, which is counter-intuitive to me. > To > me, crashing a program on purpose seems like a drastic measure. No > doubt > desperate times can call for desperate measures, but I would have > guessed > that optimally, you'd try immediate first & then abort if immediate > takes > too long. But I'm just learning this stuff... > > Cheers, > > -Roy > > Roy Pardee > Programmer/Analyst > SWFPAC Lockheed Martin IT > Extension 8487 > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).