Re: When I COMMIT....

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 6 Nov 2006 07:21:33 -0800
Message-ID: <1162826493.682178.292070@f16g2000cwb.googlegroups.com>

klabu wrote:
> Say if when i hit "Enter" on "commit ;", someone tripped on the power cord
> of the database box..
>
> Is it possible I'd lose 100% of that tranaction without ANY possibility of
> recovery.
>
>
> thanks
> --
> 10gR2

Database server with non-battery backed cache on the RAID controller, using write back caching. This would be a very poor configuration. On commit, Oracle would be told that the committed data was flushed from the redo log buffer to disk, when it fact it was sitting in the cache of the RAID controller. On power failure, the contents of the RAID controller's cache would be lost. The result?

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Mon Nov 06 2006 - 09:21:33 CST