Hi Sanjay.
We are about to move to SAN so all I have is a bunch of research, however
I'm finding consistently that log files should not use raid 5. Doing so
raises the probability of causing a write bottleneck on log files. I
personally prefer the SAME approach (Strip And Miror Everything)
HTH
Russell
On 6/22/05, Sanjay Mishra <smishra_97_at_yahoo.com> wrote:
>
> Hi
> Thanks Jared and other for giving ideas about Raid Storage for one of EMC
> SAN. I need some more advice before making any progress with our admin.
> We are planning to put 8 production databases , 7 OLTP and 1 Warehouse on
> to the new SAN. I am thinking that I should get 2 RAID 1+0 LUNs for each
> database to store Log and Arvhived files respectively and one or two RAID5
> for Database files. Any suggestion or corrections based on your environment
> and expertise. I am open for any change at this moment. The OLTP database
> sizes are less that 100G and Warehouse database is more than 1TB.
> Do I need to get seperate LUN for Log an Archived files for each
> database. Never worked deeply with any storage configuration and so are not
> clear on the pros and cons or any issues for having single or multiple LUNs
> TIA
> Sanjay
>
> ------------------------------
> Yahoo! Sports
> Rekindle the Rivalries. Sign up for Fantasy Football<http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=33539/*http://football.fantasysports.yahoo.com?ovchn=YAH&ovcpn=Integration&ovcrn=Mail+footer&ovrfd=YAH&ovtac=AD+>
>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 22 2005 - 23:27:22 CDT
