Tim,

I'll take a look at the link and speak with the group.  I'll see if we can get some type of testing set up.

If you are running your database on nfs, how are you doing the DR?  I can obviously quiesce  the database and do a snapshot, but if it the main fs corrupts, how are you recovering using the snapshot?  Are you using a flex clone, etc?

Thanks,

Jeff

On Tue, May 13, 2014 at 3:22 PM, tmac <tmacmd@gmail.com> wrote:

This is *not* your ordinary NFS nor is this pNFS. This is a NFS stack that ORACLE uses. Oracle's Direct NFS.

It is very stable abd better than a standard NFS with a host OS. In fact, I have been told that if you look at ORACLE

on all the different platforms it can run on, 95% of the NFS stack is the same, the only deviation is that of the host platform that dictates a few changes (like Windows, Linux, Solaris, etc)

It does a lot behind the scenes to utilize all connections. Again, this is not your standard NFS at play here. It is a more-or-less customized version that Oracle uses under the sheets so to speak.

Try setting it up in a dev environment.

Here is a useful link about it: 

http://docs.oracle.com/cd/E11882_01/install.112/e22489/storage.htm#CWLIN281

http://www.orafaq.com/wiki/Direct_NFS

If using NFS now, you would

Shut down Oracle

create /etc/oranfstab (or $ORACLE_HOME/dbs/oranfstab)

Tell Oracle to use a new library for storage

Start Oracle.

--tmac

Tim McCarthy

Principal Consultant

          

        Clustered ONTAP                                                        Clustered ONTAP

 NCDA ID: XK7R3GEKC1QQ2LVD           RHCE6 110-107-141           NCSIE ID: C14QPHE21FR4YWD4

     Expires: 08 November 2014              Current until Aug 02, 2016         Expires: 08 November 2014

On Tue, May 13, 2014 at 5:07 PM, Jeff Cleverley <jeff.cleverley@avagotech.com> wrote:

Tim,

It has been our experience that even if there are multiple network connections on the server, when it makes an NFS connection to the NetApp, it will only use one of those connections.  We are not using NFS4/PNFS.  Is Oracle NFS basically PNFS?

We had a process (non-Oracle) on a system a few years ago.  We tried giving it an nfs mounted file system.  The transactions drove the filers in the dirt.  We switched the to FC luns and set up a "local" file system on the server.  It is much easier on the filers and faster than the nfs file system.  We're concerned that using NFS of any type may cause this issue again.

Unfortunately we probably won't find out if it is too abusive until they run full steam.  At that point stopping them and changing the process probably won't be very popular :-)

How do you do your backups/DR for your nfs file systems?

Thanks,

Jeff

On Tue, May 13, 2014 at 2:11 PM, tmac <tmacmd@gmail.com> wrote:

Personally, I would strongly encourage you to not use iSCSI.

Instead, look at using Oracle's NFS implementation.

It is fairly easy to setup. Give it a bunch of network adapters on the host

(like two or three) and point at the NetApp. 

The client will use all the connections Oracle knows about and performance can really scream, especially if you can use 10GigE

--tmac

Tim McCarthy

Principal Consultant

          

        Clustered ONTAP                                                        Clustered ONTAP

 NCDA ID: XK7R3GEKC1QQ2LVD           RHCE6 110-107-141           NCSIE ID: C14QPHE21FR4YWD4

     Expires: 08 November 2014              Current until Aug 02, 2016         Expires: 08 November 2014

On Tue, May 13, 2014 at 4:02 PM, Jeff Cleverley <jeff.cleverley@avagotech.com> wrote:

Greetings,

My Oracle experience with and without NetApp has largely been non-existent.  Please bear with me on this.  All of our current DBs are on dedicated servers with locally attached storage.

One of our groups has a 6280 cluster running 8.1.2P4 7-mode.  They want to look into using iscsi to a new 11.2 Oracle server.  The cluster can get pretty busy at times so I'm not sure Oracle NFS will work in this case.

The questions are largely about backups and DR.  I'm curious about how most people choose to back this up and how to recover for that solution.  I know there are lun copy options, snapmanager/flex clone options, etc.  We're very open to manual scripting and custom solutions.  Backups would most likely go to a NearStore, and the DR would be a second server connected via iscsi also.

Thanks,

Jeff

--
Jeff Cleverley
Unix Systems Administrator
4380 Ziegler Road
Fort Collins, Colorado 80525
970-288-4611

_______________________________________________
Toasters mailing list
Toasters@teaparty.net
http://www.teaparty.net/mailman/listinfo/toasters

--
Jeff Cleverley
Unix Systems Administrator
4380 Ziegler Road
Fort Collins, Colorado 80525
970-288-4611

--
Jeff Cleverley
Unix Systems Administrator
4380 Ziegler Road
Fort Collins, Colorado 80525
970-288-4611