FreeLists / oracle-l / RE: Shutdown Abort

["Robert Freeman" <robertgfreeman@xxxxxxxxx>]

Shutdown AbortAll I can say is that generally when I'm doing something
production, if I have to shut down the thing fast, I do a shutdown abort. In
fact, there are systems I've dealt with before that only a shutdown abort
would bring it down, and a shutdown immediate would hang it. I've worked at
probably 50+ clients in my Oracle years (someday I need to sit down and
actually count them!)

For every book I've written, every time I would shutdown one of my databases
that I'm using for the book it would be a shutdown abort.

While I can not give you a hard number of how many shutdown aborts I've
done, I'm sure it's a lot. Since 7.3, I've never had a database fail to come
back up after a shutdown abort for any reason that could be attributed to
the shutdown abort. Never.

RF




Robert G. Freeman
Oracle Consultant/DBA/Author
Principal Engineer/Team Manager
The Church of Jesus Christ of Latter-Day Saints
Father of Five, Husband of One,
Author of various geeky computer titles
from Osborne/McGraw Hill (Oracle Press)
Oracle Database 11g New Features Now Available for Pre-sales on Amazon.com!
Sig V1.1

  -----Original Message-----
  From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Randy Johnson
  Sent: Tuesday, July 03, 2007 7:08 AM
  To: oracle-l@xxxxxxxxxxxxx
  Subject: RE: Shutdown Abort


  With all due respect this was not a controlled test. So I'd be carefull
not to assume it was caused by the abort.

      -Randy



  Randy Johnson
  Sr. Technical Consultant
  Enkitec, LLP

  Office ..... 817-255-3580
  Mobile .... 817-564-6583
  Email ..... randy.johnson@xxxxxxxxxxx





----------------------------------------------------------------------------
--
  From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Joel.Patterson@xxxxxxxxxxx
  Sent: Tuesday, July 03, 2007 7:11 AM
  To: m.haddon@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
  Subject: RE: Shutdown Abort


  Well… I think this goes towards the conversation about whether it is safe
or not.   No data is lost with TEMP… but others brought up the issue that
the database could have been writing blocks to the datafiles just at that
moment.  (or tempfile)?



  I don’t believe data would be lost… (what if log buffer was being flushed
to redo log)?   … This can be discussed separately, but my point goes to the
argument that it saves time… which was what started the thread.



  Does it save time, if the tempfile fails verification tests… or if a
datafile needs recovery  (aside from the fact that recovery is implicit with
shutdown abort).



  Perhaps if you already had the drop/create tempfile statements ready… you
might say that in your particular situation, it saves time If you manually
shutdown startup.   But it doesn’t look like a particularly best practices
type of thing to automate reliably, (meaning you can sleep through it).



  …. I’m not drawing conclusions adamantly, but just pointing out what
actually happened.   (It was a test environment).



  Joel Patterson
  Database Administrator
  joel.patterson@xxxxxxxxxxx
  x72546
  904  727-2546


----------------------------------------------------------------------------
--

  From: Michael Haddon [mailto:m.haddon@xxxxxxxxx]
  Sent: Tuesday, July 03, 2007 1:46 AM
  To: Patterson, Joel; Oracle-L@Freelists
  Subject: Re: Shutdown Abort



  Hmmm.. I would be curious about what other data might be in a questionable
state,...

  Joel.Patterson@xxxxxxxxxxx wrote:

  Update  FYI:

  I just did a shutdown abort on 10.2.0.1 and got:

  ORA-01187: cannot read from file 201 because it failed verification tests.

  Had to drop and re-create the TEMP tablespace….



  Joel Patterson

  Database Administrator

  joel.patterson@xxxxxxxxxxx

  x72546

  904  727-2546





  No virus found in this incoming message.
  Checked by AVG Free Edition.
  Version: 7.5.476 / Virus Database: 269.9.14/883 - Release Date: 7/1/2007
12:19 PM




  No virus found in this outgoing message.
  Checked by AVG Free Edition.
  Version: 7.5.476 / Virus Database: 269.9.14/883 - Release Date: 7/1/2007
12:19 PM