Re: [suse-oracle] Best use of ASM

Hi All:

>>> On 6/9/2010 at 6:17 AM, Christian Griebel <[email protected]> wrote:
> Hi Stacy,
> 
> if you want both DirectIO and AsyncIO, you won't use XFS as Oracle does 
> not support both options concurrently on XFS. We've used ext3 (which 

This XFS limitation is removed & now it's fully supported.

Thanks,
Arun

> does support both) for one and ASM (as well w/o ASMlib for the reasons 
> Robert wrote) for the other productive machine (ASM also by default 
> exploiting both IO schemes).
> ASM does fall short at where it comes to breaking down ASM names to 
> operating system names of (failing) disks. Since we use JBOD, we used a 
> naming scheme like T02D16_abcde for the fibre channel disks: T=<tray>, 
> D=<disk slot>, abcde=<last 5 digits of WWN>, easy to find out with 
> lsscsi, multipath -ll etc.
> 
> In your config, I'd rather go for "wide striping": use one large RAID10 
> stripe with the filesystem of your choice to accomodate all tablespaces. 
> If performance really is a factor, add two solid state disks for 
> (oracle-mirrored) copies of online redo logs and control files. (And add 
> a fast archive_destination!)
> 
> Good luck!
> 
> Robert Suh wrote:
>>
>> We are using ASM.  We are not using asmlib, since we didn't want to be 
>> tied to Oracle's releases for the kernel modules.
>>
>> I would highly recommend ASM.  ext3 is garbarge.  If you don't want to 
>> use ASM, look at XFS or ext4.
>>
>> With the 12 disks, I would create 6 RAID 1 luns (hardware RAID) and 
>> let Oracle stripe across the 6 disks by creating one ASM disk group.
>>
>> All of the data go into the one ASM disk group.
>>
>> Rob
>>
>> *From:* [email protected] 
>> [mailto:[email protected]] *On Behalf Of *Stacy Gaddy
>> *Sent:* Thursday, June 03, 2010 2:21 PM
>> *To:* [email protected] 
>> *Subject:* [suse-oracle] Best use of ASM
>>
>> I am in the process of building a new server and considering using 
>> ASM. The configuration is as follows:
>>
>> 2 disks - RAID 1 - SLES11/Oracle 11gR2
>>
>> 12 disks on a raid controller to be used for Oracle.
>>
>> Traditionally I have used RAID 10 or RAID 1 depending of type of files 
>> being stored on the logical disk. Data on RAID 10, control, redo, and 
>> archive on RAID 1.
>>
>> How would you divide up the 12 disks between control, redo, data, and 
>> FRA? Would you use hardware RAID instead of the built-in Oracle 
>> mirroring and striping?
>>
>> There doesn't seem to be any good documentation out there to give best 
>> practices relating to using hardware RAID vs ASM redundancy.
>>
>> Thanks,
>>
>> Stacy
>>
>>
>> _______________________________________________
>> suse-oracle mailing list
>> [email protected] 
>> http://listx.novell.com/mailman/listinfo/suse-oracle 
>>    

_______________________________________________
suse-oracle mailing list
[email protected]
http://listx.novell.com/mailman/listinfo/suse-oracle