"Dave" <x_at_x.com> wrote in
news:1KhBe.69340$G8.55215_at_text.news.blueyonder.co.uk:
>
> "Randy Harris" <randy_at_SpamFree.com> wrote in message
> news:YBhBe.2636$Ih7.1773_at_newssvr33.news.prodigy.com...
>>
>> <bdbafh_at_gmail.com> wrote in message
>> news:1121297383.841030.167780_at_f14g2000cwb.googlegroups.com...
>>> the reality is ... on an MS win32 OS ... that if one has not bumped up
>>> the WaitToKillSerivceTimeout value in the registry ... that while the
>>> instance is attempting to complete a shutdown immediate ... that if the
>>> shutdown occurred via a "NET STOP OracleService%ORACLE_SID%" command
>>> ... that a clean shutdown would not have been completed prior to the
>>> cold backup, and recovery using the current online redo log would be
>>> required at instance startup, and in the event that the cold backup set
>>> was used (restored).
>>> so don't run a cold backup of oracle on windows using a NET STOP to
>>> shutdown the instance - script it in sqlplus so that it waits properly
>>> - or perform a shutdown abort/startup restrict/shutdown immediate in
>>> the shutdown script.
>>>
>>> (this falls under the general subject of things that have been covered
>>> so many times that I find the subject frustrating).
>>>
>>> -bdbafh
>>
>> OK. But if I use shutdown immediate what happens to the uncommitted
>> transactions? Are they simply discarded?
"UNCOMMITED TRANSACTION" is a pure 100% oxymoron.
UNCOMMITTED DML is uncommited DML.
COMMITTED DML is a transaction.
Yes, uncommited DML is rolled back & discarded;
because without any COMMIT Oracle can't ascertain data integrity.
Go RTFM for the acronym "ACID".
Received on Wed Jul 13 2005 - 21:12:44 CDT
