RE: ASM of any significant value when switching to Direct NFS / NetApp / non-RAC?
- From: "CRISLER, JON A" <JC1706@xxxxxxx>
- To: "robert.hanuschke@xxxxxxxxx" <robert.hanuschke@xxxxxxxxx>, "dananrg@xxxxxxxxx" <dananrg@xxxxxxxxx>
- 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).
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Robert Hanuschke
Sent: Friday, August 10, 2012 1:11 PM
To: dananrg@xxxxxxxxx
Cc: Dave.Herring@xxxxxxxxxx; tim@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
