AIX

AIX

Connect with fellow AIX users and experts to gain knowledge, share insights, and solve problems.


#Power
#Power
 View Only
  • 1.  mount option of NFS for Oracle backup

    Posted Tue March 13, 2007 02:42 PM

    Originally posted by: SystemAdmin


    I have mounted a NFS from AIX (5.3) to a RHEL3 successfully by
    mknfsmnt -f /remote/backup -d /dbrecovery/remote_backup -h BAANBACKUP -t rw -S -b 1024 -c 1024
    but when I run my Oracle´s RMAN backup, which was configured the remote disk to '/remote/backup', it return an error:
    "ORA-27054: NFS file system where the file is created or resides is not mounted with correct options".
    Does anyone know what other especial option need for the Oracle?
    #AIX-Forum


  • 2.  Re: mount option of NFS for Oracle backup

    Posted Tue March 13, 2007 02:43 PM

    Originally posted by: SystemAdmin


    I tested with the NFS and could manually create files and directory there.
    #AIX-Forum


  • 3.  Re: mount option of NFS for Oracle backup

    Posted Wed March 14, 2007 10:41 AM

    Originally posted by: SystemAdmin


    There is nothing that can be done on the AIX side. The only solution is to follow the Oracle Metalink Note:387700.1 Log in as Oracle DBA user
    SQL>alter system set event='10298 trace name context forever, level 32' scope= spfile ;
    then shutdown immediate/startup the database, then try backup again.
    #AIX-Forum


  • 4.  Re: mount option of NFS for Oracle backup

    Posted Wed March 28, 2007 11:57 AM

    Originally posted by: SystemAdmin


    try this
    I had the same issue with trying to create oracle tablespaces
    on a Network Appliance disk array.

    see metalink note:338086.1

    #AIX-Forum


  • 5.  Re: mount option of NFS for Oracle backup

    Posted Mon April 02, 2007 01:35 PM

    Originally posted by: SystemAdmin


    On HP-UX (Learning AIX) we have it setup to use TCP as the nfs protocol, User NFS Version 3, we hard mount it (beware, this could cause issues if the destination goes away), set our read and write buffers to 32k (for this mount). The fstab entry for HP-UX is this:
    10.X.X.X:/backup /backup nfs proto=tcp,vers=3,rw,hard,intr,bg,rsize=32768,wsize=32768 0 2

    You should be able to convert that to AIX with the man page... There is an article on metalink about rman backups over NFS mounts.
    #AIX-Forum


  • 6.  Re: mount option of NFS for Oracle backup

    Posted Tue April 03, 2007 12:03 PM

    Originally posted by: SystemAdmin


    The following entry in /etc/vfstab works for Solaris against Oracle 10gR2

    NFSHost:NFSPath - /MountPoint nfs no no proto=tcp,vers=3,rw,hard,intr,bg,rsize=32768,wsize=32768
    #AIX-Forum