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

tolilong發表於2012-12-10
NFSIDE
今天在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
Copyright (c) 2003, 2005, Oracle. All rights reserved.
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
Copyright (c) 2003, 2005, Oracle. All rights reserved.
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部落格 ” ，連結：http://blog.itpub.net/24237320/viewspace-1059897/，如需轉載，請註明出處，否則將追究法律責任。

相關文章