RE: shutdown abort warnings

We have had Oracle support tell us that a shutdown abort can in certain rare circumstances cause corruption. The practical reality is the option seems safe as long as you do not use try to make use of the database data files for backup or transporting purposes before Oracle has been restarted and allowed to perform crash recovery.

I would use shutdown immediate and only resort to shutdown abort when the immediate was not working fast enough or a serious problem existed on the database like the day my OPS database started performing recovery for the other failed instance on both instances (not a good thing).

• Mark D Powell -- Phone (313) 592-5148

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Joel.Patterson_at_crowley.com Sent: Wednesday, April 16, 2008 2:46 PM
To: oracle-l_at_freelists.org
Subject: shutdown abort warnings

I was reading (and contributed my .02£), to the forum discussion awhile ago concerning shutdown abort yet came across this advice and warnings of possible corruption still being advertised.

Does this lend credit to the institution, or take points away? The leanings where very much favorable to abort with much in depth analysis.

http://www.embarcadero.co.uk/resources/tech_papers/oracleorphan.pdf

If so, one wonders.... (not that I have any intention of utilizing there services in the first place... it is simply academic).

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Apr 16 2008 - 15:07:30 CDT