Re: ASM setup

On Apr 28, 12:45 pm, hpuxrac <johnbhur...@xxxxxxxxxxxxx> wrote:
On Apr 28, 10:26 am, macdba321 <macdba...@xxxxxxxxx> 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.

Thanks for the reply! I actually just got the book you recommended and
since (for once) I have some spare time and some spare hardware, I'm
playing around with it as I read along.

Regardless, since this is all 100% for fun/academic, a quick question:

If you were setting up a server/database for 100% speed (ie, ZERO
requirements for HA and/or disaster recovery .....if I lose a drive,
oh well, I start over, etc.):
(The server has 3 raw disks)
Would you:

A) Hardware-based RAID-0 the 3 disks and let ASM see them afterwards
as 1 "device"
B) Oracle-based RAID-0 the 3 disks
C) Don't use RAID at all
D) Other????

Thanks, and again, this is 100% academic/fun .... this is ZERO
requirement for High Avail!!!!!!!!!!!!!!!!!!!!!!

Thanks!
.

Relevant Pages

  • Re: 10g ASM Pros and Cons
    ... It, additionally, provides all of the features of an LVM. ... But does Oracle gain control over the storage system? ... ASM is basically a replacement for Oracle raw disks. ... "ASM is basically a replacement for Oracle raw disks." ...
    (comp.databases.oracle.server)
  • Re: ASM setup
    ... Hardware-based RAID-0 across the 3 disks and control them via ASM ... well as the Oracle installation. ... If your storage environment supports RAID well then they get LUNs from ...
    (comp.databases.oracle.server)
  • Re: AIX + Oracle ASM + EMC Symmetrix - low performance
    ... Performance is OK but how do you keep track of the disks? ... I tried putting the ASM volume under LVM control, but the DBA hat a fit ... Running any kind of Oracle ... database on only one disk device will probably give you bad performance. ...
    (comp.unix.aix)
  • Re: ASM setup
    ... ASM disk group. ... (4 total physical disks in the server). ... well as the Oracle installation. ...
    (comp.databases.oracle.server)
  • Re: Best fs for Oracle RAC
    ... ASM makes migration easier. ... Puget Sound Oracle Users Groupwww.psoug.org ... rebalance to include the EMC disks had completed, ...
    (comp.databases.oracle.server)