Re: Hot and Cold backups

From: Randy Harris <randy_at_SpamFree.com>
Date: Thu, 14 Jul 2005 03:20:05 GMT
Message-ID: <FRkBe.2685$Ih7.405@newssvr33.news.prodigy.com>

> >>
> >> 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".

Thank you for the explanation. I was under the mistaken impression that the rolled back DML would remain in the online redo logs and be processed when the database restarted. I envisioned a scenario where there could be numerous DML statements stacked up in the redo buffer when the database was shutdown immediate. I didn't understand that such statements were discarded. Received on Wed Jul 13 2005 - 22:20:05 CDT