Re: dbshut script - shutdown or shutdown immediate

From: GovindanK <mail2gkatteri_at_netscape.net>
Date: Wed, 02 Apr 2003 14:53:37 -0800
Message-ID: <F001.00578CCD.20030402145337@fatcity.com>

Agreed. I admit my English needs some improvement. What i wanted to say was about rollback but used the words no.of.users. Thanks for pointing out.

GovindanK

Jeremiah Wilton <jwilton_at_speakeasy.net> wrote:

>On Wed, 2 Apr 2003, GovindanK wrote:
>
>> Shutdown immediate does rollback and will take time if no.of users
>> is high.
>
>Number of users is not the largest contributing factor to shutdown
>immediate taking a long time.  The longest poles in the tent are large
>transaction rollback and lazy temp segment deallocation.
>
>> On the otherside, shutdown abort simply takes the db down and does
>> not bother about anything else. As per manual, if you do a shutdown
>> abort then you WILL need the online redo logs for recovery just in
>> case.  
>
>Do you know of anyone who does not have their online redologs?  You
>pretty much need them or your database would have crashed a long time
>ago.
>
>> Think twice if your db is in NOARCHIVELOG mode. If your db is in
>> ARCHIVE mode make sure the logs are multiplexed.
>
>As has been pointed out, having multiplexed logs has nothing to do
>with archivelog mode.  Furthermore there is no reason to be more
>careful about using abort if you are in noarchivelog mode.  Crash
>recovery will not need any archived redologs, since it only needs
>those logs since the last checkpoint.
>
>--
>Jeremiah Wilton
>http://www.speakeasy.net/~jwilton
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Jeremiah Wilton

---

Try AOL and get 1045 hours FREE for 45 days! http://free.aol.com/tryaolfree/index.adp?375380

Get AOL Instant Messenger 5.1 for FREE! Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455

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

Received on Wed Apr 02 2003 - 16:53:37 CST