RE: ASM of any significant value when switching to Direct NFS / NetApp / non-RAC?
Date: Wed, 15 Aug 2012 06:53:51 +0000
Message-ID: <9F15274DDC89C24387BE933E68BE3FD3374FA2_at_MISOUT7MSGUSR9D.ITServices.sbc.com>
The only thing I have not seen mention regarding the ability to ADD new luns-filesystems, say on a different array or even a different vendor's array, and move the data over without any oracle downtime. Can dNFS do that? ( I don't know). With ASM on 11.2 you can move the data around with no db downtime. With NFS I think at best you get tablespace offline / online (and RMAN too) or moving tables between tablespaces which has availability limitations.
I just finished moving a 11.2 RAC from EMC to NetApp with zero downtime (RH Linux 5).
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Robert Hanuschke
Sent: Friday, August 10, 2012 1:11 PM
To: dananrg_at_yahoo.com
Cc: Dave.Herring_at_acxiom.com; tim_at_evdbt.com; oracle-l_at_freelists.org
Subject: Re: ASM of any significant value when switching to Direct NFS / NetApp / non-RAC?
Hi Dana,
about "With ASM, it's a breeze to use "+DATAFILE" and have Oracle deal with pathing details. Is there a similar shorthand I can use without ASM that offers the same convenience?"
you might want to read about Oracle Managed Files (often just called OMF). http://docs.oracle.com/cd/E11882_01/server.112/e25494/omf003.htm
That practically also works with any file system. Just set the various *_dest parameters, omit the paths from the add or create statements and Oracle will put the needed files in the directories specified before, generating its own unique file names.
Best regards,
Robert
http://robertvsoracle.blogspot.com
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 15 2012 - 01:53:51 CDT