RE: ASM - hardware mirroring vs. Oracle mirroring

Greetings,  

It has been my experience recently that the roles of the DBA and the System administrator are becoming less distinct when working with Oracle. ASM is one area in which this has been true for me as has RAC setup and administration. I have been forced, if you will, to gain a better understanding of system administration in the world of linux and have also had to teach the system administrators more about Oracle. I see Oracle heading in the direction of attempting to have the product assume many of the facets of managing the system and expect that in the not too distant future Oracle will become on operating system of its own. I suspect this is in part why Oracle is now supporting Linux. It certainly does make the job more difficult but I think the move in this direction is going to continue.  

Thanks.  

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still
Sent: Wednesday, April 16, 2008 10:29 AM To: Allen, Brandon
Cc: Finn Jorgensen; krish.hariharan_at_quasardb.com; paul.baumgartel_at_credit-suisse.com; Don Seiler; oracle-l_at_freelists.org Subject: Re: ASM - hardware mirroring vs. Oracle mirroring  

On Wed, Apr 16, 2008 at 9:56 AM, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:

        I have no experience with ASM, nor any volume management software, but my guess would be that ASM doesn't add complexity, rather it shifts that area of complexity from the Unix admin to the DBA. I have the luxury of working with an excellent team of Unix admins, so I prefer to let them handle that area, but for someone who wears both the Unix/Linux admin and the DBA hats, maybe it makes sense to use ASM. Can anyone else who has worked extensively with both LVM and ASM confirm or deny that assertion?

I think we've seen an excellent example of added technical complexity from Finn Jorgensen.

Also, I completely agree with the fact that ASM shifts responsibility.

Personally, I don't want the storage admin's job.

We have very capable admins, and I don't see any point in taking on the storage
responsibility in addition to DBA duties.

Which as far as I'm concerned, adds a great deal of complexity, because then I
as the DBA would also be the storage admin.            

        From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still

        Is it just me, or does ASM unnecessarily complicate operations?

        Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist


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