Effective immediately a customer can now use ODA with
database files stored on an external NFS file server for both read
and write operations. This effectively eliminates ODA's 4TB
storage capacity limit, which has been a concern with some of
potential ODA customers.
Below is some additional information regarding the ODA external
are we announcing?
you can now use the Oracle
Database Appliance with database files stored on a NFS-attached
file server for both read and write operations.
this differentiate the Oracle Database Appliance from an Oracle
Database running on a 3rd-party server?
this feature is a generic feature of the Oracle Database. This puts Oracle Database
Appliance on par with other Oracle Database server platforms.
there an approved list of NFS servers I can use with the Oracle
but we strongly recommend using a commercial file server such as
an Oracle ZFS Storage Appliance, or a similar product from a major
storage vendor (i.e., EMC, NetApp).
Q: Do I
use ASM with the NFS-attached storage?
A: No. Simply mount the file system
and store your files on it the same way you would store Oracle
database files in any file system. Use of ASM for NFS-attached storage is not recommended.
Q: Can I have some of their database
files on internal ODA storage, and some on NFS-attached storage?
you can have a mix of tablespaces—some on the local SAS storage
internal to the ODA, and some on the NFS server.
I create an ASM diskgroup that spans the local storage and the NFS
A: No. ASM diskgroups should be
constructed on disks internal to the ODA. ASM is not needed (nor
recommended) for use on NFS-attached storage.
Q: If I
don’t use ASM with my NFS Filer, how do I online add storage to my
NFS-attached file system.
commercial NFS filers provide this functionality.
I be required to patch their storage sub-system separately or will
the ODA patching process take care of the NFS server?
ODA patching process will only patch the local ODA server. If patches are required for
an NFS filer, the customer is responsible for patching that
Q: If I put critical business data
on an NFS filer and the server is down, what happens?
database is down. Make
sure you use a highly available NFS filer.
Q: if I
put non-critical archive data on an NFS filer, can I configure it
so a failure to the filer won’t affect my database?
mark the archive data read-only, and set the init.ora parameter READ_ONLY_OPEN_DELAYED=TRUE
NIC in the ODA should I use to connect to NFS-attached storage?
ODA has plenty of NICs. Use a bonded pair that is not in use.
mount options should I use?
can I find more information?
is Direct NFS (dNFS)?
is a feature of the Oracle Database that allows an NFS client in
the database kernel to directly connect to and access data on an
I used the native OS client or dNFS to connect to my NFS Filer?
can use either, but Oracle recommends using dNFS.
do I configure and use dNFS?
to MOS note 762374.1.
can I use Hybrid Columnar Compression (HCC) with ODA?
is available for use with database files stored on and Oracle ZFS
Storage Appliance. You can
thus use HCC with ODA as long as the files are stored on and
NFS-attached ZFS Storage Appliance. Your ODA must be running 188.8.131.52 database (releasing in
April 2012) and you must connect via dNFS.
should I distribute my data between the local storage and the NFS
hot data on the internal storage, as that will give the best
performance. Put colder
data on the NFS filer.
have tables containing both hot and cold data. How can I move just the cold
data to the filer without affecting the application which expects
everything in one table?
the database partitioning option to keep data in different
partitions. Place the hot
data in partitions on the internal storage, and cold data in
partitions on the NFS Filer.
there a limit to the amount of data I can store on the NFS Filer?
it is limited by the maximum database size supported by the Oracle
Database. This is very
there a white paper on this subject I can read?
ODA specific white paper will be available shortly. In the mean time, a dNFS
white paper is available describing the generic functionality. You can find it here: http://www.oracle.com/technetwork/articles/directnfsclient-11gr1-twp-129785.pdf