|Oracle and RAID - A summary of the most common RAID levels and their usage with Oracle files.|
Basics would help said...Hands on steps would be appreciated.
Michael Foster said...You're suggesting RAID 0+1 - I would suggest you change that to RAID 1+0 as there is a significant advantage in rebuilds in case of failures.
Additionally, I believe your article understates the advantage of RAID 1+0 OR 0+1 in environments that support a large # of writes over RAID 5.
Agreed. I've made some changes.
As much as I dislike RAID 5, I'm not willing to throw it out completely as many systems are not concerned with performance. Lots of DEV and UAT environments can sit happily on RAID 5.
Rich said...I'd like to see something about ASM here. Best practices with 11gR2 would have you using ASM...
I've added some references to ASM in the article. I kinda thought they were self explanatory, but it's probably a good idea to be more explicit. :)
Ashwin said...Oracle Not id - 45635.1 recommends RAID1 as the BEST option for controlfile ,redo log and archives
Yes, but at the same time Oracle recommend SAME (Stripe And Mirror Everything), which is what ASM does.
I think if you RAID 10 everything, you will be OK. :)
clusterclouds said...•To reduce costs further experiment with moving redo logs and rollback/undo tablespaces to RAID 5. Pick the combinations that work best for your system.
Its contradicting some things you mention earlier in the post, as well as the doc :
If you quote single lines out of context, everything will sound like gibberish!
Read the section again and you will see this is the 4th option in a list of best (1) to worst (5). So I'm saying it the 4th worst solution. This in no way contradicts the documentation. I think you need to read stuff properly before commenting!