今天在nfs上expdp文件的时候出现了如下错误: [@more@]

[oracle@oracle10g /]$ expdp scott/oracle directory=backup_dir dumpfile=scott20121210.dmp

Export: Release 10.2.0.1.0 - 64bit Production on Tuesday, 11 December, 2012 12:38:49

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31641: unable to create dump file "/nfs/scott20121210.dmp"

ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

Additional information: 3

在baidu查看的时候，发现是nfs挂载有问题.

[root@oracle10g ~]# fuser -m -v /rmanbackup

USER PID ACCESS COMMAND

/rmanbackup: root 3184 ..c.. bash

[root@oracle10g ~]# fuser -m -v -i -k /rmanbackup

USER PID ACCESS COMMAND

/rmanbackup: root 3184 ..c.. bash

Kill process 3184 ? (y/N) y

[root@oracle10g ~]# umount /rmanbackup

[root@oracle10g ~]# mount -o rw,bg,hard,rsize=32768,wsize=32768 192.168.18.131:/u01/nfs /rmanbackup

之后expdp ok

[oracle@oracle10g ~]$ expdp scott/oracle directory=backup_dir dumpfile=scott.dmp

Export: Release 10.2.0.1.0 - 64bit Production on Tuesday, 11 December, 2012 14:00:01

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

Starting "SCOTT"."SYS_EXPORT_SCHEMA_01": scott/******** directory=backup_dir dumpfile=scott.dmp

Estimate in progress using BLOCKS method...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 5.437 MB

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/TABLE/COMMENT

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

. . exported "SCOTT"."TTT" 3.858 MB 40695 rows

. . exported "SCOTT"."DEPT" 5.656 KB 4 rows

. . exported "SCOTT"."EMP" 7.820 KB 14 rows

. . exported "SCOTT"."SALGRADE" 5.585 KB 5 rows

. . exported "SCOTT"."TT" 7.429 KB 100 rows

. . exported "SCOTT"."TT1":"P1" 6.375 KB 49 rows

. . exported "SCOTT"."TT1":"P2" 6.273 KB 50 rows

. . exported "SCOTT"."TT1":"P3" 5.234 KB 1 rows

. . exported "SCOTT"."BONUS" 0 KB 0 rows

Master table "SCOTT"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded

******************************************************************************

Dump file set for SCOTT.SYS_EXPORT_SCHEMA_01 is:

/rmanbackup/scott.dmp

Job "SCOTT"."SYS_EXPORT_SCHEMA_01" successfully completed at 14:00:39

ITPub博客

ORA-27054: NFS file system where the file is created or resides is not mounted

最新文章