Printable View
We have an IBM 3HDD W2K server on RAID0. On Disk 1 has windows OS and Oracle OS. I want to config the oracle files as following:
Disk1: controlfile1, REDO files(1,2,3), datafile1, indexfile1
Disk2: controlfile2, UNDOTBS, datafile2, indexfile2
Disk3: controlfile3, TEMP tablespace, datafile3, indexfile3
Is this a good config? RAID level can not be modified or server reconfigured. Each HDD is 18G but space is not an issue. We are running 9.2.0.4.
RAID 0 is only good for files you can lose; ie. TEMP, software, etc. Putting datafiles on RAID 0 is BAD, BAD, BAD.Quote:
Originally posted by newbie5
We have an IBM 3HDD W2K server on RAID0. On Disk 1 has windows OS and Oracle OS. I want to config the oracle files as following:
Disk1: controlfile1, REDO files(1,2,3), datafile1, indexfile1
Disk2: controlfile2, UNDOTBS, datafile2, indexfile2
Disk3: controlfile3, TEMP tablespace, datafile3, indexfile3
Is this a good config? RAID level can not be modified or server reconfigured. Each HDD is 18G but space is not an issue. We are running 9.2.0.4.
Given that it has to be done and that it has to be done on RAID0:
- you should multiplex the REDO - have 3 files per group, one on each disk
- frequent backups
- run in ARCHIVELOG mode
- cherish your archlogs (copy them EVERYWHERE)
from what you say it seems that you are going to put datafiles in corresponding disks you are talking about, that confuses me, if it´s RAID-0 how can you have that control?
Ah! did he mean striping (RAID zero), or did he mean NO RAID (zero RAID)? I ASSumed the second . . . .
Yes. It is a NO RAID situation with C:, D: and E: drives. However, can I not have a RAID0 3HDD with 3 logical partitions C:, D and E:?
Why? What would be the point of 3 logical devices?
multiplexing? I realize that there will be no performance gain in I/O.
What happens if one of you disks goes bad? You lose all three filesystems.Quote:
Originally posted by newbie5
multiplexing? I realize that there will be no performance gain in I/O.
WOOOOHA . . .
Stop me when I go wrong:
You have three physical disks - let's call them 0, 1, 2.
You do not have a hardware RAID controller - or if you do, you aren't allowed to change the config.
The Win2K Disk Administrator sees three disks 0, 1, 2.
AFAIK at this point the only reason to "stripe" is for performance.
Oracle will multiplex Control and RedoLog files, but you only get full value of doing that if that each member of the "group" goes to a different physical disk.***
If you have logical drives (C: D: & E: ) striped across the physical disks, then most files will have blocks on all three disks and a disk failure will wreck them all.
*** Corrected following Tim Hall's post - see below.