Friday, September 7, 2012

RMAN backup at NFS mount point

RMAN backup at NFS mount point

To take rman backup at NFS mount point on Linux Platform from Oracle Database 11.2 add few rule:

Listing of required NFS options for 11.2.0.2 RMAN disk backup directory

The following NFS options must be specified for 11.2.0.2 RMAN disk backup directory:
Mount Options for Linux systems

Single Instance NFS Mount Options
---------------------------------
Mount options for Oracle Binaries

rw,bg,hard,rsize=32768,wsize=32768,vers=3,nointr,timeo=600,tcp

Mount options for Oracle Datafiles

rw,bg,hard,rsize=32768,wsize=32768,vers=3,nointr,timeo=600,tcp


RAC NFS Mount options
---------------------

Mount options for Oracle Binaries

rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp, vers=3,timeo=600, actimeo=0


Mount options for Oracle Datafiles

rw,bg,hard,nointr,rsize=32768,wsize=32768,proto=tcp,noac,forcedirectio, vers=3,suid

The above values are starting recommendations as a starting point you can tune further
as required. To test which value of rsize/wsize is optimal for your system you can run
the testing outlined below.

First, we'll try transfers of 16384 blocks of 16k each from a unique file called /dev/zero
(when you read it, it's all zeroes, put out very quickly) to the test file. The time it takes to do this is our measure. From the client, command:

time dd if=/dev/zero of=/<mounted partition>/testfile bs=16k count=16384



MOS Note : ID 1117597.1