instance recovery time is more manageable in 9i --
mttr_fast_start_target in the init.ora.
For a time, in version 6, Oracle said you HAD to use shutdown abort,
that a shutdown immediate could corrupt the database (that was an
"undocumented feature")
I've had cases where the regular, automated backup procedure did a
shutdown immediate. And because some programmer had left an ad hoc
query running, the database did not shut down, the backup did not
complete and when the users came in in the morning, they couldn't
access the database.
If you are going to use shutdown immediate, you need to be aware that
it could hang, and leave your database in an "half-life" state --
neither shutdown nor started up. Make sure you have a process that
monitors how long the shutdown immediate is taking and either alerts
you that the time is excessive or kills the shutdown immediate and does
a shutdown abort. And if you do a shutdown abort as standard practice,
I'd suggest following it immediate with "startup restrict" and then
"shutdown" for a clean shutdown
- Mark Richard <mrichard_at_transurban.com.au> wrote:
> I don't think the issue is so much about whether Oracle recovery can
> handle
> a database crash or not. I think the issue is whether you want to
> spend
> the time of going through that process. I'm sure recovery can also
> handle
> the server being powered cycled but how many people do that without
> shutting down Oracle first?
>
> Since we had a car analogy already in this thread... I'm confident
> that
> the seat belts in my car work but I'm in no rush to test them out,
> and even
> if they do work I'm likely to end up bruised anyway.
>
> I guess the bruising my equate to overtime spent recovering the
> database...
> Oh, I hate trying to make really good analogies.
>
>
>
>
>
> Rachel
>
> Carmichael To: Multiple recipients
> of list ORACLE-L <ORACLE-L_at_fatcity.com>
> <wisernet100_at_y cc:
>
> ahoo.com> Subject: RE: dbshut
> script - shutdown or shutdown immediate
> Sent by:
>
> root_at_fatcity.c
>
> om
>
>
>
>
>
> 03/04/2003
>
> 12:33
>
> Please respond
>
> to ORACLE-L
>
>
>
>
>
>
>
>
>
> yeah so? are you suggesting that Oracle instance recovery can't
> handle
> a database crash? If so, better pray your server never crashes.
>
>
> --- "Pardee, Roy E" <roy.e.pardee_at_lmco.com> wrote:
> > Well... my official oracle instructor in dba larva school said that
> > it's
> > tantamount to crashing the db--or so I recall anyway. This isn't
> so?
> >
> > Peace,
> >
> > -Roy
> >
> > Roy Pardee
> > Programmer/Analyst
> > SWFPAC Lockheed Martin IT
> > Extension 8487
> >
> > -----Original Message-----
> > Sent: Wednesday, April 02, 2003 2:09 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > On Wed, 2 Apr 2003, Chris Berry wrote:
> >
> > > Shutdown abort is pretty drastic, are you sure shutdown immediate
> > > didn't work?
> >
> > What is drastic about shutdown abort?
> >
> > Never one to opt out of a shutdown abort thread,
> > --
> > Jeremiah Wilton
> > http://www.speakeasy.net/~jwilton
> >
> > - Uses shutdown abort exclusively
> > - successful shutdowns/startups: over 10,000
> > - problems with shutdown abort: 0
> > - versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta)
> > - still employed!
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Jeremiah Wilton
> > INET: jwilton_at_speakeasy.net
> >
> > 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: Pardee, Roy E
> > INET: roy.e.pardee_at_lmco.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).
> >
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Tax Center - File online, calculators, forms, and more
> http://tax.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Rachel Carmichael
> INET: wisernet100_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).
>
>
>
>
>
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
> Privileged/Confidential information may be contained in this
> message.
> If you are not the addressee indicated in this message
> (or responsible for delivery of the message to such person),
> you may not copy or deliver this message to anyone.
> In such case, you should destroy this message and kindly notify the
> sender
> by reply e-mail or by telephone on (61 3) 9612-6999.
> Please advise immediately if you or your employer does not consent
> to
> Internet e-mail for messages of this kind.
> Opinions, conclusions and other information in this message
> that do not relate to the official business of
> Transurban City Link Ltd
> shall be understood as neither given nor endorsed by it.
>
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mark Richard
> INET: mrichard_at_transurban.com.au
>
> 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).
>
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
INET: wisernet100_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).
Received on Thu Apr 03 2003 - 05:33:49 CST
