Is this a good RAID0 configuration for oracle files?

[DaPi]

. . . You could build a mirror at the OS level - not efficient.

(I only know Disk Adminstrator for NT - I guess Win2K is similar)
Something like:
Create partition on disk0 - format as C:
Create partition on disk1 - create mirror* on disk2 - format as D:
Put OS, software, pagefile and TEMP TS on C:
Put the rest of the db on D:

* (The help in Disk Administrator tells you how, under "Establish & Break Mirror Sets")


[wild idea] Still with OS mirroring: Create a 9Gb partition on all three disks. Mirror the partition on 0 into the free space on 1, partition on 1 into free space on 2, partition on 2 into free space on 0. I hate to think what the performance would be like! But you could lose a disk and still keep all the data. [/wild idea]

[engiri]

WHat about Raid 0,1 for this set up?

[pando]

with 3 disks? how?

[zainalj]

I think RAID 0 is very good in term of performance but bad for recovery purposes. That is depend on how critical your data is. It is recommended to mirror your online redo log files into 3 disk you have so that you won't face single-point-of-failure where one group of you redo log corrupted. Also saperate your datafile into 3 disk as well, this is for easy recovery and manageable datafile. There should be no perfomance issue if you put datafile on the different disk since you are running in RAID 0.

The best RAID for oracle to me is RAID 1+0 <- read/write performance + recoverable

[engiri]

Originally posted by zainalj
The best RAID for oracle to me is RAID 1+0 <- read/write performance + recoverable

Any difference between Raid 1,0 and
Raid 0,1..

Because I have been suggested for 0,1 for
3 hard disks of 18 gb and 1hard disk of 32 gb(18gb waste..?)

[marist89]

Originally posted by engiri
Any difference between Raid 1,0 and
Raid 0,1..

Because I have been suggested for 0,1 for
3 hard disks of 18 gb and 1hard disk of 32 gb(18gb waste..?)

YOU CAN'T DO 0+1 WITH 3 DISKS!
YOU CAN'T DO 0+1 WITH 3 DISKS!
YOU CAN'T DO 0+1 WITH 3 DISKS!
YOU CAN'T DO 0+1 WITH 3 DISKS!
YOU CAN'T DO 0+1 WITH 3 DISKS!
YOU CAN'T DO 0+1 WITH 3 DISKS!
YOU CAN'T DO 0+1 WITH 3 DISKS!
YOU CAN'T DO 0+1 WITH 3 DISKS!
YOU CAN'T DO 0+1 WITH 3 DISKS!
YOU CAN'T DO 0+1 WITH 3 DISKS!

[engiri]

IT IS NOT 3
IT IS 4

[marist89]

That will work.

[TimHall]

marist89: "YOU CAN'T DO 0+1 WITH 3 DISKS!"

A: You can if they're magical pixie-disks


DaPi: "Oracle will multiplex Control and RedoLog files, but it is only worth doing that if you can be sure that each member of the "group" goes to a different physical disk."

A: Be careful! Someone might read this quote and stop multiplexing their files. It's an Oracle recommendation to multiple controlfiles and redologs even if you are using a single physical disk.

Cheers

[DaPi]

Tim, I hang my head in shame. I've corrected the post. Tx.