Re: NT striping dangerous with Oracle 7 or 8?

This would also be true of a hardware RAID implementation unless the RAID controller contains battery-backed memory and can hold those final disk writes until the drives are powered up again.

NT striping is no more dangerous that any other implementation. Whether Oracle is writing directly to the disks (in RAW mode), or going through a non-buffering operating system, or using the operating system's software RAID implementation, it makes no difference. There will always, always be cases where if power is lost at the wrong time data will be corrupted.

Most SCSI hard disk drives nowadays have largeish on-board caches anyway, so even getting the data to the drive doesn't guarantee that it will be put onto the media if power is lost at exactly the right moment.

Adrian Shepherd wrote:
>
> This would be true of Software striping , but not of a hardware / raid 1/2/5
> stripe.
>
> bdurrett_at_ccci.org wrote in message <6d6l3i$ema$1_at_nnrp1.dejanews.com>...
> >I have been told that it is dangerous to use NT striping with Oracle on NT
> >4.0. This person told us that NT buffers some Oracle writes in memory and
 if
> >the server is turned off at the wrong time the data could be corrupted. I
> >find this hard to believe, but I wanted to post this question just to be
 sure.
> >Is there a problem using NT striping and oracle 7 or 8 server?
> >
> >Thanks,
> >Bobby Durrett
> >
> >-----== Posted via Deja News, The Leader in Internet Discussion ==-----
> >http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Fri Feb 27 1998 - 00:00:00 CST