RE: shutdown abort warnings
Date: Thu, 17 Apr 2008 08:29:33 -0400
I was in an Oracle class many years ago (Oracle 7) where the instructor said to issue a "alter system checkpoint" prior to the "shutdown abort". He claimed this was much safer than just issuing the "shutdown abort". This seems to make sense - your syncing all the files before the shutdown.
Several years ago we experienced corruption with "shutdown abort". IIRC it was the controlfiles that were corrupted. It would have been 8i on Tru64, but that's the best I can remember. At the time we were also having some issues with the firmware on the SAN controllers. In any case, I am now in the habit of issuing the "alter system checkpoint" first.
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Powell, Mark D Sent: Wednesday, April 16, 2008 4:08 PM
Subject: 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
This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of D&E except to the extent that it relates to their official business.