Oracle数据库使用nfs挂载的盘执行expdp说明（Linux环境下）

来源：互联网发布：java jdk安装编辑：程序博客网时间：2024/06/02 06:24

一、使用如下目录挂载NFS网络磁盘

# mount -t nfs -o rw,bg,hard,rsize=32768,wsize=32768,vers=3,nointr,timeo=600,proto=tcp,nolock 10.10.10.10:/orabak/ /exp20151202/

二、执行expdp时出现如下报错的解决办法

[oracle@rac1 ~]$ export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
[oracle@rac1 ~]$ expdp system/oracle directory=expdp20151202 dumpfile=expdp20151202.dmp logfile=expdp20151202.log full=y
Export: Release 10.2.0.3.0 - 64bit Production on Thursday, 03 December, 2015 14:09:55
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "/exp20151202/expdp20151202.dmp"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3

解决办法：
SQL> alter system set events '10298 trace name context forever,level 32';
System altered.

[oracle@rac1 expdp20151214]$ export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
[oracle@rac1 expdp20151214]$ expdp system/oracle dumpfile=full%U directory=dir_151214 full=y parallel=4 logfile=expdp20151214.log
10.2.0.3.0 - 64bit Production on Monday, 14 December, 2015 9:00:41
(c) 2003, 2005, Oracle. All rights reserved.
: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYSTEM"."SYS_EXPORT_FULL_01": system/******** dumpfile=full%U directory=dir_151214 full=y parallel=4 logfile=expdp20151214.log
Estimate in progress using BLOCKS method...

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA

....

至此，即可正常导出数据。

0 0