Re: suspicious standard Oracle Linux start/stop script

"Joel Garry" <joel-garry_at_home.com> wrote in message news:91884734.0306011239.5e427b7f_at_posting.google.com...
> "Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message
news:<3ed91f36$0$966$cc9e4d1f_at_news.dial.pipex.com>...
> > How many of these refer to instance recovery rather than media recovery?
> >
>
> Does it make a difference? If you need media recovery, how can you
> avoid instance recovery?

It makes a difference because I'm suggesting that I'm happy for instance recovery to take place. I'm not positing anything about media recovery - in this instance, though isn't really an area where bugs are acceptable as a more general point.

> If any of them affect instance recovery,
> then the simple act of doing a shutdown abort as opposed to shutdown
> immediate stuffs you.

I agree, however I can't see that any of them do imply this.Unless I have misread it 2645378+ does indeed refer to media recovery - which is why it gets picked up in standby. It is also somewhat esoteric in that the underlying bug applies only to LOBS and only seems to occur under high load.

> There is nothing wrong with scripts doing a shutdown abort followed by
> a bounce, _as long as there is something in there to notify someone
> right away if it doesn't work_ and the DBA takes responsibility for
> any problems.

I' d have thought that the DBA ought to be aware of ANY shutdown of the database/server no?

> I still maintain it is extremely bad advice to tell
> newbies that there is nothing different between shutdown abort and
> shutdown immediate. That's just macho posturing to prove you aren't
> afraid of Oracle's recovery mechanism.

I'll accept that, since I didn't go through this whole debate when I made my initial quick post. There *are* differences between the two.

Shutdown Abort

Happens quickly, implies instance recovery on startup.

Shutdown Immediate

Happens slowly, doesn't imply instance recovery.

In an automated script at machine shutdown I'd much rather the former, than risk the latter not completing. I'd also rather never reboot the db server if possible.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK