Re: Oracle screws up Sun host

From: Tim Kearsley <tim.kearsley_at_milton-keynes.gov.uk>
Date: 22 Apr 2003 06:16:06 -0700
Message-ID: <725736ef.0304220516.3c759f81@posting.google.com>

Rick Denoire <100.17706_at_germanynet.de> wrote in message news:<f3u8av41h4fpp9f79tvb3cgfsdd4qh7hvi_at_4ax.com>...

> I try to stay by the rules which say not to use shutdown abort
> unnecessarily. Well, I only know it is necessary when it does not work
> any more.

Hi Rick,

You shouldn't be afraid to use shutdown abort. I've not known it ever to cause a problem. What happens is that Oracle performs instance recovery when it starts up following a shutdown abort. I've not known this to fail. We routinely use a shutdown abort followed immediately by a startup and then a shutdown (either normal or immediate) in backup scripts to ensure that the Oracle server does shut down prior to doing a cold backup. These have run for years with no problem (at least none caused by the shutdown abort!).

Regards,

Tim Kearsley
Database Manager
Milton Keynes Council Received on Tue Apr 22 2003 - 08:16:06 CDT