Re: alter system v shutdown abort

  • From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
  • To: pjhoraclel@xxxxxxxxx
  • Date: Mon, 18 Sep 2006 09:58:28 +0100

On 9/16/06, Peter Hitchman <pjhoraclel@xxxxxxxxx> wrote:

I had a situation like this a few weeks back on a Unix server. I got a
call asking me to "Abort" the database because some killed sessions were not
going away and holding locks etc. My reaction was , you must be kidding, I
abort the database in the middle of the day (with lots of workin sessions on
it) and then cross my fingers and hope it comes back up OK. I must admit I
have yet to do an abort and not see Oracle recover, but when it comes to
production databases I never want to do this unless there is no other
choice. Of course the problem was solved by killing the Unix background
Next time someone suggets aborting the database, quiz them to see if they
actually know the implications.

Whilst I'm with you on the action in the scenario you describe, it seems to
me that if you don't have the faith that Oracle will always recover from an
abort then probably you shouldn't be running oracle in production - after
all you can't be confident that it will recover in the event of a power
outage or server crash.

Niall Litchfield
Oracle DBA

Other related posts: