Re: suspicious standard Oracle Linux start/stop script

"Hans Forbrich" <forbrich_at_telusplanet.net> wrote in message news:3ED66E01.7FF45C70_at_telusplanet.net...
> Sybrand Bakker wrote:
>
> > On Thu, 29 May 2003 16:42:21 +0100, "Niall Litchfield"
> > <n-litchfield_at_audit-commission.gov.uk> wrote:
> >
> > >My advice
> > >
> > >modify the dbshut sql script so it does a shutdown abort. Oracle will
> > >recover on startup.
> > >
> >
> > AAAAAAAAAAAAAAAAAAAARRRRRRRRRRRRRRRRRRRRGGGGGGGGGGGGGGGGGGGGGGGGGGGGG
> >
> > Seems like we need a competition for the most stupid advice offered.
> > There have been quite many the last few days.
> >
> > Sybrand Bakker, Senior Oracle DBA
>
> Sure would be nice if we got some consistency going here ...last week I
> got a severe talking to in this list about saying shutdown abort is a
> no-no.

I hope it wasn't that severe.

The facts are: if your current redo log is safe (multiplexing, anyone?), then shutdown abort is no worse than shutdown immediate, which every DBA seems willing to do at a drop of a hat.

Anyone going 'Arrrrgggggg' needs to explain why Oracle would be prone to losing data in the event of a shutdown abort, but not with a shutdown immediate.

But it's precisely this sort of "inconsistency" that persuades me it's a waste of time posting here. So I won't be doing so in future. If that means you don't feel you've been spoken to severely in future, then I guess that's some kind of bonus.

Cheerio, group: last post!

Regards
HJR Received on Fri May 30 2003 - 07:35:09 CDT