This discussion is archived
4 Replies Latest reply: Feb 3, 2013 10:17 PM by 939642 RSS

Prerequisites required ASM Migration

939642 Newbie
Currently Being Moderated
Hi ,

Could u please let me know "The prerequisites required before going ahead with the ASM implementation".

Any best practices for disk group confirguration ( I mean how many groups for good performance)

Details of our database:

1) Oracle version : 11.2.0.3
2) OS : Sun solaris 10
3) DB size : 1 TB

I know ASM is part of the Grid Infrastructure. But the current setup was handover from different company and we planned to implement ASM concept here.

Could u please help me out.

Regards,

Steven
  • 1. Re: Prerequisites required for ASM Migration
    939642 Newbie
    Currently Being Moderated
    File system Details:

    /db_arch
    /ora11g/data1
    /ora11g/data2
    /ora11g/data3
    /ora11g/dbdump
    /ora11g/redo3
    /ora11g/redo4
    /ora11g/redo5
    /ora11g/redo6
    /ora11g/indx
    /ora11g/redo1
    /ora11g/redo2
    /ora11g/sysdata
    /ora11g/temp
    /ora11g/undo

    Edited by: 936639 on Feb 1, 2013 3:42 AM
  • 2. Re: Prerequisites required ASM Migration
    User328666 Newbie
    Currently Being Moderated
    It depends. I'm sure that's what they would tell you in the Oracle training class. :)

    For starters Oracle recommends two diskgroups named DATA and FRA. If you are using RAC then you will probably create a third diskgroup named CRS.

    The redundancy level depends on your storage. If the storage array is providing RAID protection, then you can configure the ASM diskgroups with External Redundancy. But, this is not always the case. You might want to mirror between an external SAN and in internal ioDrive using ASM Normal Redundancy and then set the parameter asm_preferred_read_failure_groups to ensure all reads come from the flash drive. So you see there are countless possibilities that make us say "it depends".

    In larger organizations with Enterprise Storage it is rarely so simple. Recall that a diskgroup is a collection of like storage. If you have LUNs of different sizes and performance levels, then you should group the LUNs according to those attributes. Each grouping becomes a diskgroup. For example, never mix RAID 5 LUNs from a Clariion with RAID 5 LUNs from a Symmetrix, and never mix any of those with RAID 10 LUNs. Also, within a diskgroup you want all storage of the same size due to the impact on striping and mirroring. This is all discussed in the Oracle on-line documentation.

    If your storage team carves up the array into different classes of storage, then you will probably want to create separate ASM diskgroups. The I/O profiles are completely different for log files versus datafiles, and a well trained storage admin knows how to address each case. So now, if the storage admin gives you high performance LUNs designed for redo logs, lower performance LUNs marked for archivelogs, and a third set of LUNs marked for datafiles, then you will want to create three separate ASM diskgroups named DATA, REDO, and FRA to isolate the storage based on performance characteristics.

    Often times with Enterprise Storage you cannot avoid I/O conflicts, so there's no point in separating Oracle's files into their own diskgroups (data, index, redo, etc.) Back on the array you will find the stripes overlay each other. And the array internally ties the storage devices together with either copper or fiber loops, so the I/O's are getting mixed and competing for resources. All I am saying is talk to your storage team and see if they think it will make any difference to try separating tables and indexes into different files given the way they setup the array.

    For a small 1 TB database like yours I generally use two ioDrive 1.2 TB PCIe flash memory cards and create one ASM diskgroup named DATA with Normal Redundancy. Bang, done. RAID 10 protection at 5x the performance of a well tuned SAN, and I don't have to wait two weeks for the Enterprise Storage team to carve up LUNs. This takes a great load off the SAN and helps the other enterprise users with their performance issues, and frees up capacity thereby extending the life of the enterprise storage.

    The above "answers" are a very generic introduction to planning ASM storage. If you have more specific questions, let us know.

    -R
  • 3. Re: Prerequisites required for ASM Migration
    onedbguru Pro
    Currently Being Moderated
    I have seen 200TB+ DW db on 3 Diskgroups - the primary data table (1 data 11 fact) > 150TB of the total was on one diskgroup. FRA and other data on the other 2 diskgroups. YMMV.
  • 4. Re: Prerequisites required ASM Migration
    939642 Newbie
    Currently Being Moderated
    Thanks so much for the detailed explanation. Thanks once again.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points