RE: shutdown abort warnings
- From: "Hostetter, Jay M" <JHostetter@xxxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- 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.
Jay
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Powell, Mark D
Sent: Wednesday, April 16, 2008 4:08 PM
To: oracle-l@xxxxxxxxxxxxx
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
**DISCLAIMER
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
