Re: ASM setup

On Apr 28, 10:26 am, macdba321 <macdba..._at_gmail.com> wrote:
> Hi all,
>   I'm setting up my first ASM based database ever. (Just for testing
> and learning, NOT for production). I only have 3 physical disks in the
> ASM disk group. (4 total physical disks in the server).
>
>   I am loading the OS (Windows 2003 server) on one physical disk as
> well as the Oracle installation. I am keeping the other 3 disks raw
> for ASM.
>
>   Should I RAID the 3 raw disks (hardware RAID and/or Oracle raid) or
> just let Oracle do what it wants with them?
>
> Thanks!

What most people do in the real world ( the ones actually using ASM anyhow ... not a large percent yet of the oracle installed base ) is basically this.

If your storage environment supports RAID well then they get LUNs from it and define the ( LUNs become disks in an ASM diskgroup ) diskgroup as external redundancy.

This tells ASM hey don't bother doing any overhead of mirroring the extents you allocate across disks ... my storage environment does a nice job of dealing with that stuff.

If the storage environment doesn't support RAID then they point ASM at disks and let ASM do the mirroring, You have a choice of 2 or 3 way mirroring to add additional protection levels.

So all in all this design is up to you ... perhaps it should be based on the type of testing that you want to do and how that relates to an eventual production environment that you might be running in eventually.

There's a book that you might want to think about getting "Oracle Automatic Storage Management" it's one of those Oracle Press books authors are Vengurlekar, Vallath and Long includes 10g and 11g. Personally I recommend getting and reading that book ( it really isn't that long ) and spending a day or 2 reading it before you make more decisions about your setup. Received on Mon Apr 28 2008 - 11:45:21 CDT