Posts Tagged ‘expdp nfs’

expdp over nfs

Monday, March 22nd, 2010

[root@fjdds ~]# mount -t nfs -o hard,bg,proto=tcp,vers=3,suid,rsize=32768,wsize=32768,intr,noac,timeo=600,nolock 10.214.0.79:/nas/nasvg2/nasvg2 /dmpdir

请注意mount option,不然报错,

报错1:
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file “/dmpdir/fjdds/cpdds_20100323_01.dmp”
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3

报错2:
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file “/dmpdir/fjdds/cpdds_20100323_01.dmp”
ORA-27086: unable to lock file – already in use
Linux-x86_64 Error: 37: No locks available
Additional information: 10

数据库版本:

[oracle@fjdds fjdds]$ expdp system directory=dmpdir dumpfile=cpdds_201003230_%U filesize=4G schemas=(cpdds,cpdds_etl,cpdds_pdata) logfile=cpdds_201003230.log parallel=4

Export: Release 10.2.0.4.0 – 64bit Production on Tuesday, 23 March, 2010 11:19:33

Copyright (c) 2003, 2007, Oracle.  All rights reserved.
Password:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options