Re: Oracle and NAS storage systems

Due to limited hardware, we stored data/index on the same NetApp volume (q-tree in NetApp speak). Most importantly, you need to be certain that redo/archive/control are NOT in the same q-tree as any datafiles. This is due to how 'snaprestore' works (if used), where it restores all files in the q-tree rather than selective files. Because of this, we didn't use snaprestore, but instead manually copied from snapshots. And never mixed database files with other application files on the same q-trees.

"Berkmeyer, Sue" wrote:
>
> Like Dick Goulet (07/15/02), I was wondering if anyone was using the
> NetApp to store production datafiles and if so what the configuration looked
> like. Is anyone storing the tables and indexes on the same NetApp volume?
> This is contrary to the standard practice of separating tables and indexes
> across controllers, using RAID 1+0 or 0+1, the S.A.M.E principles, etc.
> Thanks.
>
> > -----Original Message-----
> > From: Jared.Still_at_radisys.com [SMTP:Jared.Still_at_radisys.com]
> > Sent: Tuesday, August 06, 2002 12:05 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Oracle and NAS storage systems
> >
> > I've been speaking to Veritas people about this lately.
> >
> > They don't like NetApp because it is difficult to backup.
> >
> > Veritas likes to have some hooks into the Filesytem, and
> > apparently this isn't easy to do with WAFL for some reason.
> > ( WAFL is the NetApp Filesystem )
> >
> > Veritas doesn't sell hardware, so they don't have any $$
> > incentive for preferring one over the other.
> >
> > They do on the other hand find SAN's very attractive. There's
> > a lot of capabililty in a SAN for HA and management that is
> > lacking in NetApp.
> >
> > You might try talking to your local Veritas Sales and Support
> > critters, they always like to get phone calls. :)
> >
> > Jared
> >
> >
> >
> >
> >
> >
> > dgoulet_at_vicr.com
> > Sent by: root_at_fatcity.com
> > 07/15/2002 07:43 AM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> > <ORACLE-L_at_fatcity.com>
> > cc:
> > Subject: Oracle and NAS storage systems
> >
> >
> > Folks,
> >
> > I've been asked to validate/invalidate a contention made by two
> > storage
> > vendors.
> >
> > NetAppliance has stated that you can use a netapp filer with Oracle
> > for
> > datafiles, although their configuration looks more like a DAS(direct
> > attached
> > storage) configuration using 10baseT cables vs. SCSI cables. Of course
> > their
> > real claim to fame here is Oracle's endorsement.
> >
> > EMC on the other hand has stated that using a NAS, in the traditional
> > mode,
> > for Oracle datafiles is at best risky. And although their product can
> > support
> > it, they do not recommend doing so for several of the reasons that I've
> > held out
> > are pertinent.
> >
> > Therefore, is there anyone out their using a NAS to store datafiles?
> > If so,
> > what does the configuration (server to NAS) look like?
> >
> > Dick Goulet
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: dgoulet_at_vicr.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > 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.com
> > --
> > Author:
> > INET: Jared.Still_at_radisys.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > 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.com
> --
> Author: Berkmeyer, Sue
> INET: Sue_Berkmeyer_at_nrel.gov
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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.com
-- 
Author: Suzy Vordos
  INET: lvordos_at_qwest.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).