Re: RAID 1 & Oracle problems?

From: Dave Hau <davehau_nospam_123_at_nospam_netscape.net>
Date: Fri, 20 Jun 2003 19:09:57 GMT
Message-ID: <3EF35C03.9070007@nospam_netscape.net>

One potential problem with using Oracle on RAID-1 is dirty region logs. Because each logical write now involves a physical write to each mirror, in case of a power outage, you could potentially be left in an invalid state where some mirrors have been updated and others haven't. Then when power comes back, and Oracle performs recovery, Oracle might happen to read from a mirror that has not been updated, and conclude that no redo needs to be applied when it should. This can cause read errors later on. The solution is to turn on dirty region logging in the volume manager.

Cheers,
Dave

Randy Nichols wrote:
> A potential customer related that they heard Oracle had problems with RAID 1
> configurations. I have not been aware of any issue with RAID 1. Has anyone
> heard anything like that?
>
>
Received on Fri Jun 20 2003 - 14:09:57 CDT