I'm setting up a new NT 4 server with Oracle 8i Database running a critical database. Does anyone know of any experiences or documented facts of which drive configuration is better to hold the data? My 2 choices are 4 -36 Gig Drives in Raid 5, or 4 -36 Gig Drives in Raid 1(Mirrored)
This conversation is currently closed to new comments.
If speed is your main concern, strip sets are the fastest BUT offer NO REDUNDANCY. Mirror gives redundancy but is best for systems where read actions are the norm. RAID 5 is a compromise between speed and redundancy. If your database is modified a lot then use RAID 5. If it is mostly just read operations then mirror will work just as well and give greater recoverability. For speed do not use NT's software RAID. You loose cpu cycles maintaining your parity. Use a disk controller designed for your raid configuration. Read you Oracle book and pay attention to the part about not using a cacheing disk controller. In some designs this is a plus and for others this is a big minus. You must decide this.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Oracle on NT Drive Configuration