Re: ASM - hardware mirroring vs. Oracle mirroring

ASM also allows you to add and remove LUNS to the available storage for the database on the fly, to migrate data from one area of disk to another without downtime and so on. In that sense I think it's a pretty decent technology for making managing storage easier. What are the limitations that you are referring to by the way?

On Fri, Apr 11, 2008 at 8:47 PM, Baumgartel, Paul < paul.baumgartel_at_credit-suisse.com> wrote:

> But isn't mirroring and striping most of what ASM does? Wasn't it
> intended to eliminate the need to purchase an expensive SAN?
>
> I understand that many people use ASM in conjunction with Symmetrix, etc.,
> but I don't see how just pooling the storage and presenting it to the
> database is worth the effort (and the limitations, as there are certain
> operations in, e.g., RMAN, that aren't supported with ASM).
>
>
> *Paul Baumgartel*
> *CREDIT SUISSE*
> Information Technology
> Prime Services Databases Americas
> One Madison Avenue
> New York, NY 10010
> USA
> Phone 212.538.1143
> paul.baumgartel_at_credit-suisse.com
> www.credit-suisse.com
>
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Bobak, Mark
> *Sent:* Friday, April 11, 2008 9:59 AM
> *To:* peter.schauss_at_ngc.com; oracle-l_at_freelists.org
> *Subject:* RE: ASM - hardware mirroring vs. Oracle mirroring
>
> Peter,
>
>
>
> Where in the documentation do you see Oracle having a bias towards ASM
> doing mirroring?
>
>
>
> I ask cause several Oracle folks I talked to, and an Oracle "best
> practices" presentation I saw a while ago, all say the same thing. That
> being, if you already have a well-designed SAN, use external redundancy in
> ASM, and let the SAN do all the mirroring and striping.
>
>
>
> That's where we're at, as well. SAN does all mirroring and striping. ASM
> just pools the storage and makes it available to the database.
>
>
>
> -Mark
>
>
>
> *--
> Mark J. Bobak*
> *Senior Database Administrator, System & Product Technologies*
> ProQuest
> 789 E. Eisenhower, Parkway, P.O. Box 1346
> Ann Arbor MI 48106-1346
> +1.734.997.4059 or +1.800.521.0600 x 4059
> mark.bobak_at_proquest.com <mark.bobak_at_il.proquest.com>
> www.proquest.com
> www.csa.com
>
> *ProQuest...*Start here.
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Schauss, Peter
> *Sent:* Friday, April 11, 2008 9:34 AM
> *To:* oracle-l_at_freelists.org
> *Subject:* ASM - hardware mirroring vs. Oracle mirroring
>
>
>
> I am starting to investigate ASM as a part of a potential 8.1.7.4 to 10g
> upgrade on Solaris (SunOs 5.9). Oracle's documentation seems to have a bias
> toward having the ASM instance handle the mirroring while our UNIX support
> people would prefer to do it at the hardware level. Which is preferable and
> what factors would push a decision in one direction or the other?
>
> Thanks,
> Peter Schauss
>
> ==============================================================================
> Please access the attached hyperlink for an important electronic communications disclaimer:
> http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
> ==============================================================================
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l