dean wrote:
> On Aug 14, 1:30 am, sybra..._at_hccnet.nl wrote:
>> On Mon, 13 Aug 2007 21:16:17 -0700, dean <deanbrow..._at_yahoo.com>
>> wrote:
>>
>>> I've read to the contrary several times. Consider what would happen if
>>> Oracle thought it saved a change to disk, and then there was a power
>>> failure before the cache was written to disk? It would then be in a
>>> corrupt state.
>> Consider there is redolog, which is always written *before* the data
>> files are written.
>> Consider these redologs are multiplexed and on mirrored drives.
>> So how likely is the fairy tale you describe above.
>> Consider you are in dire need to revise your policy of not reading any
>> manual.
>>
>> --
>> Sybrand Bakker
>> Senior Oracle DBA
>
> So there is no confirmation of the redo log being written either?
Written yes ... but written to cache not physical disk. It has been
that way for a very very long time.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Aug 14 2007 - 10:31:16 CDT