Oracle-L: RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris an

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Fri, 07 Feb 2003 05:13:59 -0800
Message-ID: <F001.00546EBF.20030207051359@fatcity.com>

Thanks Robert,

I wasn't aware of that issue. Plus now that we have all instances on 9202, we hope it won't bite us. As for adding tablespaces dynamically, no chance. We *require* that development team request space at-least 7 business days before they actually need it. This gives us enough time to create raw including backups)) and make sure that hot backups go on fine before we make it available to them for actual use.

Thanks again ..
Raj

Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art! -----Original Message-----
Sent: Thursday, February 06, 2003 11:54 PM To: Multiple recipients of list ORACLE-L

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.

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

I've always been opposed to shutdown abort unless you are certain that you have checkpointed and that there are no user sessions operating on the database.

Cheers!
RF

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: Rajendra.Jamadagni_at_espn.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).



text/plain attachment: ESPN_Disclaimer.txt

Received on Fri Feb 07 2003 - 07:13:59 CST