In this Document
Purpose
Scope and Application
Oracle GoldenGate Best Practice: NFS Mount options for use with GoldenGate
Applies to:
Oracle GoldenGate - Version: 10.0.0.0 and later [Release: 10.0.0 and later ]Information in this document applies to any platform.
Purpose
The purpose of this
bulletin is to document the file system mount options to use when
configuring GoldenGate to run with NFS mounted file system.
Unless IO buffering is OFF, then NFS mounts should not be used when
running any Oracle GoldenGate processes. The danger occurs when one
process registers the end of a trail file or transaction log and moves
on to the next in sequence yet after this event data in the NFS IO
buffer gets flushed to disk. The net result is skipped data and this
cannot be compensated for with GoldenGate parameter EOFDELAY.
When
using an NFS mounted file system with Oracle GoldenGate files, the
setting for file system caching or buffered IO must be disabled on both
NFS client and server.
Scope and Application
This document is relevant to all environments using Oracle GoldenGate.
The
important factor to consider when configuring Oracle GoldenGate
processes to run on NFS mounted file system is to make sure that
buffered IO (data and attribute caching) is always set to OFF on both
NFS client and server.
Oracle GoldenGate Best Practice: NFS Mount options for use with GoldenGate
In the table below-
Oracle GoldenGate files includes Binaries, Checkpoint files, Parameter files, Report files and Trail Data files
| NFS Client Operating System | NFS Client Mount options for Oracle GoldenGate Files |
|---|---|
| SUN Solaris * | rw,bg,hard,nointr,rsize=32768,wsize=32768,proto=tcp,noac,forcedirectio, vers=3,suid |
| AIX (5L) * | cio,rw,bg,hard,nointr,rsize=32768,wsize=32768,proto=tcp,noac,vers=3,timeo=600 |
| HPUX 11.23 * | rw,bg,vers=3,proto=tcp,noac,forcedirectio,hard,nointr,timeo=600,rsize=32768,wsize=32768,suid |
| Linux (x86-32/x86-64/Itanium) * | rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,actimeo=0,vers=3,timeo=600 |
*Although
data caching or buffered IO is set to OFF on the NFS client system,
sometimes for other specialized file system such as Veritas File System
(VxFS) or with NAS device/server that supports additonal caching feature
such as FlexCache system on NetApp this will not take into effect
unless you explicitly disable this function on the server side. For
VxFS, this can be done by setting MINCACHE to DIRECT or UNBUFFERED and
for the NetApp the FlexCache system must not be used at all with Oracle
GoldenGate processes.
| NFS Server Operating System | Additional Mount option on NFS server local disk ** |
|---|---|
| SUN Solaris | forecedirectio |
| AIX 5L | cio |
| HPUX 11.23 | no_fs_async |
| Linux (x86-32/x86-64/Itanium) | sync |
| NetApp (Data OnTap) | Optional FlexCache system must be disabled |
Niciun comentariu:
Trimiteți un comentariu