ORA-01580 ORA-27054 Erros When Create Data Pump File On ZFS

When I was generating a dump of a database by expdp on ZFS filesystem (Solaris with Rac 11G) I get the next error;

 
ORA-01580: error creating dump file /mnt/dbtbf01032017_01.dmp
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3

After of search for more information about the error and working with the Sysadmin We have discovered the error in the mount point options for the ZFS.

In our case was similar to (Oracle recommendation for datafiles)

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

Changed for this (Oracle recomendantion for binaries)

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

The problem was the forcedirectio. I think the forcedirectio doesn’t use intermediate buffer to write to disk, of course, many times disk is a SAN/NAS and it use its own cache.

HTH – Antonio NAVARRO

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s