This discussion is archived
3 Replies Latest reply: Nov 17, 2012 6:05 PM by onedbguru RSS

ASM design issue.....

user401909 Newbie
Currently Being Moderated
Hi Experts,

We are planning to deploy Oracle RAC 11gR2 on our PROD databases envoirnment. We have 6 databases and the largest database is 140GB of size and rest of the databases are ranging from 15Gb to 90GB. Also we are getting 1TB space from SAN for RAC. Currently used space by Oracle mountpont /u01 is 585Gb and total space is 740GB for exssiting NON-RAC databases.

Need to know how do we design the ASM diskgroups with external redundancy. Goal is to get the best performance from ASM disks.

1) Do we create single diskgroup with 4 LUNs of 200GB size. Also tell us how much size of FRA and VOTING diskgroup should be created.

2) Do we create seperate diskgroup for all the databases. i.e 6 databases 6 diskgroup and each diskgroup with one disk of depending upon the size of the database.

3) Do we create 3 diskgroups with 3 disks in each diskgroup of 100GB. So each diskgroup will be of 300GB.

4) Also need to know if we need to create seperate diskgroups for ARCHIVE,REDOLOGS, like if option 2 is choosen, then create one diskgroup for each databaseas DATA and ARCHIVE and REDOLOG diskgroups for each database as well OR
archive and redologs files will be part of DATA diskgroup.
  • 1. Re: ASM design issue.....
    Levi-Pereira Guru
    Currently Being Moderated
    962486 wrote:
    Hi Experts,

    We are planning to deploy Oracle RAC 11gR2 on our PROD databases envoirnment. We have 6 databases and the largest database is 140GB of size and rest of the databases are ranging from 15Gb to 90GB. Also we are getting 1TB space from SAN for RAC. Currently used space by Oracle mountpont /u01 is 585Gb and total space is 740GB for exssiting NON-RAC databases.

    Need to know how do we design the ASM diskgroups with external redundancy. Goal is to get the best performance from ASM disks.
    Performance will depend on of your Storage Design not only ASM Design.
    >
    1) Do we create single diskgroup with 4 LUNs of 200GB size. Also tell us how much size of FRA and VOTING diskgroup should be created.
    Oracle Recommend:
    <li> Configure two disk groups, one for data and the other for the fast recovery area.
    <li> A minimum of four LUNs (Oracle ASM disks) of equal size and performance is recommended for each disk group.

    About Voting and OCR stored on ASM. I recommend you read this:
    http://levipereira.wordpress.com/2012/01/11/explaining-how-to-store-ocr-voting-disks-and-asm-spfile-on-asm-diskgroup-rac-or-rac-extended/

    2) Do we create seperate diskgroup for all the databases. i.e 6 databases 6 diskgroup and each diskgroup with one disk of depending upon the size of the database.
    The I/O operations (performance) is more linked with Storage. However if you have one Array on storage shared by all databases have no sense to create a diskgroup for each database. Because this data on ASM will be separated but on Storage not. Think about I/O concurrence on Storage and not only on ASM.
    3) Do we create 3 diskgroups with 3 disks in each diskgroup of 100GB. So each diskgroup will be of 300GB.

    4) Also need to know if we need to create seperate diskgroups for ARCHIVE,REDOLOGS, like if option 2 is choosen, then create one diskgroup for each databaseas DATA and ARCHIVE and REDOLOG diskgroups for each database as well OR
    archive and redologs files will be part of DATA diskgroup.
    Do you have area on storage (I mean physical disks) to create one array for each diskgroup? If not forget this, this recommendation is for those wich have possiblity to create different array on storage (using set of phisycal disks dedicated) for each diskgroup.

    I recommend you create one Diskgroup to all database and a Diskgroup to FRA.
    Each diskgroup should have at least 4 ASM Disk (i.e Lun) with same capacity to maintain balance.

    If you can, also I recommend you create one Array for each Diskgroup (FRA and DATA).

    Edited by: Levi Pereira on Oct 1, 2012 4:05 PM
  • 2. Re: ASM design issue.....
    898553 Newbie
    Currently Being Moderated
    Levi has some good info, though in testing on Symmetrix and Clariion arrays with dm-multipath, I've actually seen better performance separating out the DGs by database but YMMV.

    What I'd suggest doing is something along the lines of setting up your DGs like so:

    OCRVOTE

    DB1_DATADG
    DB1_FRADG
    DB1_ARCHDG
    DB1_ACFSDG

    DB2_DATADG
    DB2_FRADG
    DB2_ARCHDG
    DB2_ACFSDG

    etc.
  • 3. Re: ASM design issue.....
    onedbguru Pro
    Currently Being Moderated
    on the OCR disk group, even if you have RAID at the device level on your LUNs you will want to have a minimum of 3 devices and redundancy of NORMAL for your OCR diskgroup as this will cause it to create 3 voting files. in 11gR2, the number of voting files is determined by the diskgroup redundancy in which you store them. 1 VOTING for EXTERNAL, 3 for NORMAL and 5 for HIGH redundancy.

    It's best that you have more than one.

Legend

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