Re: [suse-oracle] Best use of ASM

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 
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
>    

-- 
_____________________
Christian Griebel                    Merck Serono Research
D-64293 Darmstadt


This message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you must not copy this message or attachment or disclose the contents to any other person. If you have received this transmission in error, please notify the sender immediately and delete the message and any attachment from your system. Merck KGaA, Darmstadt, Germany and any of its subsidiaries do not accept liability for any omissions or errors in this message which may arise as a result of E-Mail-transmission or for damages resulting from any unauthorized changes of the content of this message and any attachment thereto. Merck KGaA, Darmstadt, Germany and any of its subsidiaries do not guarantee that this message is free of viruses and does
  not accept liability for any damages caused by any virus transmitted therewith.

Click http://disclaimer.merck.de to access the German, French, Spanish and Portuguese versions of this disclaimer.

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