Unsolved
This post is more than 5 years old
42 Posts
0
1624
July 25th, 2011 12:00
Oracle RAID configuration...I know it depends..but...
Hello Team - when it comes to RAID configuration to Oracle DB 10g and above what's the best practice OR what have you seen being implemented the most out there?
I know this is probably a question that will lead to personal beliefs or the famous (but always applicable) "it depends". Regardless, I would like to have your opinion on this or if you could point me to more of a more formal answer from us is fine to.
The reason I ask is that, I do get a lot of questions around what would we recommend as best practices. I do a lot of overlay support for overseas partners so I don't get the privilege of having huge access to end customer to clarify certains things. So, I work a lot out of assumptions and I have to rely a lot on best practices to at least present something that doesn't look like completely off.
Anyways; any guidance will be appreciated.
EvertonXavier
42 Posts
0
July 25th, 2011 13:00
Rob, Great! I am really looking forward to it.
taceyr
98 Posts
0
July 25th, 2011 13:00
Everton,
You really did call it - it does depend. I'm working on a document (drawn from several sources) that should shine some light on which RAID option is most appropriate under certain circumstances. I'll attach it to this post once it's done - I'm thinking tomorrow if that's okay.
Rob Tacey
Solution Design Center
taceyr
98 Posts
0
July 26th, 2011 11:00
Everton,
I just wanted to let you know that I'm still crafting my paper on RAID recommendations. FAST technology has introduced some additional recommendations and those are taking me a bit longer to integrate than I initially anticipated. It's coming along well though.
Solution Enablement Team
EMC² Where Information Lives
617-794-1839
taceyr
98 Posts
0
July 29th, 2011 08:00
Everton,
As promised (and perhaps a bit delayed) here's what I wrote up... I'd really appreciate any feedback on the content.
Thanks!
Rob
1 Attachment
Oracle and RAID Groups.doc
EvertonXavier
42 Posts
0
July 29th, 2011 18:00
Hi Rob - This is great! Straight to the point, love it! I really like the breakdown by file type.
Please if you don't mind I will pass it along with my team here at VCE as well; this will be very useful for all of us for sure. I will ask for feedback as well.
Thanks again for this. I really glad I signed up for this Community!!!!
taceyr
98 Posts
0
July 30th, 2011 06:00
We aim to please, sir!
Feel free to distribute it. That's what it's there for.
R.
dba_hba
63 Posts
0
August 2nd, 2011 08:00
The “Oracle on Symmetrix” techbook provides good background information and guidance for deploying Oracle databases on Symmetrix including ASM general best practices.
http://powerlink.emc.com/km/live1/en_US/Offering_Technical/Technical_Documentation/H2603_oracle_db_emc_symmetrix_stor_sys_wp_ldv.pdf
Similarly Radha has produced the whitepaper Deploying Oracle Database Applications on EMC VNX Unified Storage
http://powerlink.emc.com/km/live1//en_US/Offering_Technical/White_Paper/h8242-deploying-oracle-vnx-wp.pdf
Good guidance on Oracle Storage for VMAX, OLTP and OLAP, is given in the following solutions
http://powerlink.emc.com/km/live1//en_US/Offering_Technical/White_Paper/h7068-tiered-storage-oracle-vmax-fast-ionix-wp.pdf
http://powerlink.emc.com/km/live1/en_US/Offering_Technical/White_Paper/h8123-oracle-rac-symmetrix-fast-vp-vsphere-wp.pdf
This paper reflects the EMC IT Datawarehouse storage layout
http://www.emc.com/collateral/software/white-papers/h8238-oracle-remote-recovery-datadomain-wp.pdf
Remember that by their nature OLTP is normally about IOPS and OLAP/DW is about MB/s.
EvertonXavier
42 Posts
0
August 3rd, 2011 10:00
Great Stuff! Allan. I just passed this along to my team here as well. I am getting a lot of positive feedback from it.
I am quickly becoming a big fan of this community!
houndfish
53 Posts
0
August 4th, 2011 01:00
Allan,
one more to add, CLARiiON based but still holds true!
http://powerlink.emc.com/km/live1/en_US/Offering_Basics/White_Paper/h7207-backup-recovery-oracle-clariion-dd-networker-psg.pdf
Dave