Re: Hot and Cold backups

<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? Received on Wed Jul 13 2005 - 18:38:32 CDT