"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?
>
they are rolled back
Received on Wed Jul 13 2005 - 18:47:09 CDT
