Er, be careful here, Thomas. I've seen many installations with caching disk
controllers, where the cache has not be set to 'write-thru'. My advice is
always use a UPS anyway, they are so cheap. Rebuilding you Oracle db from
scratch may not be so cheap.
>Thomas Kyte wrote in message <35517659.5607853_at_192.86.155.100>...
>Oracle caches modified data blocks and uses DBWR to flush them in the
background
>however, log file writes are not cached -- they are force written
(fsync'ed) to
>the file system. DBWR and LGWR work together to ensure that sufficient
data
>exists in either the datafiles on disk or the online redo log files to
perform
>crash recovery.
>
>A UPS is a good idea for many reasons but not needed to prevent data loss.
The
>database takes care of that.
>
>
>Thomas Kyte
>tkyte_at_us.oracle.com
>Oracle Government
>Herndon VA
Received on Thu May 07 1998 - 10:06:26 CDT
