Re: ASM setup

Thanks for the reply. I actually just got the exact book you recommended. Since I (for once) have time on my hands, I'm taking the approach of getting my feet damp and playing around with it for a week or so and then reading the book to make it "make sense" when I read about feature X, Y, or Z (since I may have seen it then). Somewhat backwards approach I realize, but with a server and time on my hands, it works for me! :)

That being said, a simple question:

  If you wanted to build a server that has only 4 physical hard drivers and have ZERO need for HA or redundancy (data loss in the event of a drive crash is OK!), you just want to configure a server for 100% maximum speed ..... how would you set it up?

1. Hardware-based RAID-0 across the 3 disks and control them via ASM
2. Oracle-based RAID-0 across the 3 disks and control them via ASM
3. No RAID and control them via ASM
4. Other?

Thanks for the input!

On Apr 28, 12:45 pm, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
> 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 - 12:07:11 CDT