On 9/16/06, Peter Hitchman <pjhoraclel_at_gmail.com> wrote:
>
>
> Hi,
> 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
> processes.
> 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
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Sep 18 2006 - 03:58:28 CDT
