Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Shutting down in archivelog mode.

Re: Shutting down in archivelog mode.

From: Winnie Liu <poohland_at_hotmail.com>
Date: Tue, 7 Jul 1998 19:17:53 -0700
Message-ID: <6nukkr$92u@sjx-ixn6.ix.netcom.com>


Shutdown immediate should only rollback those active transaction and shut down the database and instance cleanly. But I remember reading some books and Oracle doc saying that we should not use shutdown immediate to shut down the database (I guess it's those Oracle Press books, while the Unleashed books said it's ok)

Winnie Liu
Unihealth
CA

alanlee1_at_my-dejanews.com wrote in message <6nu9cl$jk2$1_at_nnrp1.dejanews.com>...
>Shutdown immediate is similar to normal shutdown except it
>cancels all active transactions and rollback. No recovery required
>during next startup.
>
>
>Alan Lee
>BSI Consulting
>Houston,Texas
>
>In article <6nt94o$ves$1_at_nnrp1.dejanews.com>,
> stuco_at_mailcity.com wrote:
>>
>> To all ORACLE Heads out there....
>>
>> When in archivelog mode, what is the best way to shutdown a database?
>> What happens specific to archivelog during 'shutdown immediate'? Is
>> this unreliable?
>>
>> Thanking everyone, in advance, for help.
>>
>> Stuart Cowen
>> Paladin Consulting - Dallas
>>
>> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
>> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>>
>
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Tue Jul 07 1998 - 21:17:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US