Re: Top (<=10) Issues faced by Oracle DBAs Deploying in a SAN/NAS

Hi, gaja

    I post the feedback to list and hope others can also cc a copy to the list so that we share our experience.     

    My small database runs on a small basic san: two database on V880/E4500 and two standby server , share a storage which is consistent of 4*Sun T3, with 2 FC-switch.     Our pains we suffer:

1. Must have DMP or something like that configured. Or one path fail, database fail. Controller fail is not someting rare.We have an 2 hours outage once because of failed controller on T3 and unproper DMP config.

    2.We have raid10 for production and raid5 for standby database.

    3.Sun T3(under control of VxVM/VXFS) is really poor in disk performance.We have 9(4-4 mirror, one standby) as raid1 with 1G cache.300+random IO(blocksize 8k) satured the storage.90+% busy and iowait 30+%

    4. SAN Zone is not configured here and all server can see all the disks. This gives flexible control but harder to manage.

    5. Our basic SAN is not a really SAN. We still use one server to have exclusive control of one T3.So , some T3 are extreme busy while other T3 are basicaly idle. THis waste resource.But as we do not have another software layer, we used SAN just for Failover, any host can take over any storage.

Regrads
Zhu Chao.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, September 26, 2003 2:59 AM

> Fellow Listers,
>
> If you don't deal with Oracle databases on SAN/NAS
> environments, this posting may not interest you. If
> so, my apologies, please delete this. Otherwise,
> please read on.
>
> In an effort to better understand what issues you face
> when deploying an Oracle database in a SAN/NAS
> environment, I am writing to you to get some "real
> life" feedback. Although I have a fair idea, where
> some of the pain lies, it would be much more valuable
> if you could tell me. Kind of like "From the horse's
> mouth..."...;-) And I truly meant that as a
> compliment...:-)
>
> My goal is to fully understand where the "real pain"
> lies, so that appropriate solutions can be built to
> alleviate or even eliminate the pain. You can be as
> broad or narrow in your responses using the following
> topics as guidelines:
>
> * Initial SAN/NAS Configuration for Database Creation
> and Application Deployment
> * Ongoing Storage Volume Management in a SAN/NAS
> * Ongoing Storage Administration (Growth, Resizing)
> * Performance Optimization & Troubleshooting
> * Things that require automation
> * Anything else you think is important that I have
> missed
>
> I do really appreciate you taking the time to put your
> feedback in "black and white". Those of you who take
> the time and effort to provide feedback, will be
> entered in a raffle to for some T-shirts and other
> freebies. Oh, BTW, when you do send your response,
> please provide your full contact information, so that
> I know where to mail the goodies.
>
> In the interest of not "flooding the list", please
> send me your feedback directly to gaja_at_veritas.com. As
> a courtesy to my fellow listers, I will collate all
> responses and post a summary in the near future. You
> can count on me to do that.
>
>
> Best regards,
>
>
> Gaja
>
> =====
> Gaja Krishna Vaidyanatha | E-Mail: gaja_at_veritas.com
> Principal Technical Product Manager | Phone: (650)-527-3180
> Application Performance Management | Web: http://www.veritas.com
> Veritas Corporation |
>
> __________________________________
> Do you Yahoo!?
> The New Yahoo! Shopping - with improved product search
> http://shopping.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Gaja Krishna Vaidyanatha
> INET: oraperfman_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: zhu chao
  INET: chao_ping_at_vip.163.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).