RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris and

Let me throw in my 2 cents worth on this topic. There are two problems with SHUTDOWN ABORT that I have experienced in the past.

1. Before 9i (it appears to be fixed in 9i) if you inserted data in a table, then did a shutdown abort, if after restarting the database, you tried to truncate the table while the database was performing recovery on that table, the database would crash.
2. Assume that you have applications that are dynamically doing things like adding and dropping tablespaces. WHat happens if the app is in the middle of such an operation and it's in the middle of writing new records to the control file. What is the result if you shutdown abort in the middle of this write, before it's complete. We experienced a situation like this earlier this week.

Cheers!

RF

-----Original Message-----
Lewis
Sent: Monday, February 03, 2003 2:49 AM
To: Multiple recipients of list ORACLE-L and

I have to say that I still have an emotional response to 'shutdown abort', despite knowing that logically it ought to be perfectly safe.

The reason for this is the lack of stress testing that goes on at Oracle Corp. In most (if not all) cases, the only blanket stress test that the software gets is from production end-users.

How many millions of times per day is the message passing mechanism for parallel
query tested ? And it still has bugs.

How many times per day is shutdown abort tested - how many possible combinations of events coinciding with a shutdown abort have not yet received a single test ?

I find it very hard to shake the feeling that somewhere there is a code path that will eventually result in a big problem for someone once they switch to a regular shutdown abort.

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Coming soon a new one-day tutorial:
Cost Based Optimisation
(see http://www.jlcomp.demon.co.uk/tutorial.html )

____UK_______March 19th
____USA_(FL)_May 2nd

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____USA_(CA, TX)_August

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

-----Original Message-----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: 02 February 2003 10:09
Solaris and

>Alter system checkpoint... You don't say...
>
>Hey, this is the first time this thread has concluded without the
>usual "you guys better watch out b/c yer gonna break your database!"
>post.
>
>I'd say this universal support for ABORT over IMMEDIATE represents a
>dramatic change in the prevailing DBA attitude over, say, two years
>ago.
>
>How do you suppose that happened?
>
>:-)
>
>The only dissenter was Dan. Dan, what's the difference between a
>kernel transaction and a regular transaction? Are you talking about
>the O/S kernel or Oracle? Can you explain in more detail what the
>kernel transaction does to make Oracle unrecoverable after ABORT?
>
>I'm still mulling over that 'alter system checkpoint.' Sounds
>familiar.
>
>--
>Jeremiah Wilton
>http://www.speakeasy.net/~jwilton
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jonathan Lewis
  INET: jonathan_at_jlcomp.demon.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Robert Freeman
  INET: robertgfreeman_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).