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@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).

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


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

Other related posts: