Re: [suse-oracle] Best use of ASM

Problem is that ext3 and ASM provides the same performance (in reality ANY FS will show almost the same performance with Oracle).
If you can migrate disks using LVM then it dont make much difference (LVM or ASM)

ASM is better in load balancing (it makes it automatically) and it works LITTLE better in the normal conditions. But if it broke, you will have a lot of fun. With ext3, you can use any backups, copy files, resize online, and so on... XFS has better concepts but who knows, how stable is it (I hear different opinions).

There is one case when ASM is much better - if your team has strong oracle guys but weak system administrators (or if you combine sysadmin and dba and have strong oracle skills and weak systeadmin, because in many cases oracle DBA and db server sysadmin is one person) then ASM is better becasuse it requires less system skills to work with.

Other case is Oracle RAC, of course.


  ----- Original Message ----- 
  From: Robert Suh 
  To: Stacy Gaddy ; [email protected] 
  Sent: Thursday, June 03, 2010 3:00 PM
  Subject: Re: [suse-oracle] Best use of ASM


  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