Re: Redo logs and UFS buffering

In article <38DD5155.C0652E8_at_virgin.net>, Lee Bennett <l.bennett_at_virgin.net> wrote:
> I was once told by a very experienced Oracle DBA that on Solaris will
> switch off any filesystem buffering so that the consistency of the
 logs
> can be guaranteed. Does anyone know if this is true?
>
> Thanks
>
> LTB
>
>

Any volitale write buffering on any type of DB can be a problem. If the DB thinks something is on disk and really isn't, it's in the disk/os buffer and the machine dies without doing a graceful buffer flush, well... who knows what may happen.

If you can, it would be best to turn off write buffering that can't be battery backed up. If you can't turn it off, turn it down.

Using RAW devices will get you around this, but that introduces its own set of issues....

Enjoy.........

--
Doug Coan
Oracle Certified Professional DBA


Sent via Deja.com http://www.deja.com/
Before you buy.