RE: ASM of any significant value when switching to Direct NFS / NetApp / non-RAC?
Date: Wed, 15 Aug 2012 06:53:51 +0000
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).
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
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?
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.
http://www.freelists.org/webpage/oracle-l Received on Wed Aug 15 2012 - 01:53:51 CDT