You do seem to have tested out different Shutdown or SHUTDOWN ABORT
scenarios !
The TRUNCATE table issue does seem to be serious. However, the
INSERT should have been rolled-back
at the next STARTUP --- unless you had a problem because you issued the
TRUNCATE before the ROLLBACK
was completed ?
As for tablespaces -- no way that I'd try a SHUTDOWN ABORT when adding or
dropping a tablespace, although
I do think that I have been able to continue even after
interrupting/killing an ADD TABLESPACE command [but
without Shutting-down the database]
Hemant
At 08:53 PM 06-02-03 -0800, you wrote:
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.
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
- -----Original Message-----
- From: root@fatcity.com
[mailto:root@fatcity.com]On
Behalf Of Jamadagni, Rajendra
- Sent: Monday, February 03, 2003 9:01 AM
- To: Multiple recipients of list ORACLE-L
- Subject: RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands
Solaris an
- When we do cold backups, our script issues 'shutdown immediate', if
within 3 minutes the db is not shut down, we cancel and issue 'shutdown
abort'. In either case, we (again issue) startup/shutdown to make it
clean before taking backup.
- We don't worry about users connecting, as during cold backup window,
the listeners are shutdown. For us it is a circus (kind of) because our
production DBs talk to each other, so we have to follow a specific seq of
shutdown/startup.
- So far we haven't encountered any major issues because of 'shutdown
abort' ... (heavily knocking on the wood !!)
- 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!
Hemant K Chitale
My web site page is :
http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
INET: hkchital@singnet.com.sg
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@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).
Received on Fri Feb 07 2003 - 19:43:39 CST
