Re: Hot and Cold backups

"Dave" <x_at_x.com> wrote in message
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?
> >
> they are rolled back

I realize they are rolled back. What happens to them? Do they get processed when the database comes back up? Received on Wed Jul 13 2005 - 19:41:23 CDT