RE: shutdown abort warnings
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 16 Apr 2008 16:07:30 -0400
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Joel.Patterson@xxxxxxxxxxx
Sent: Wednesday, April 16, 2008 2:46 PM
To: oracle-l@xxxxxxxxxxxxx
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).
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
