oracle导出39001,Oracle执行expdp写入NFS文件系统提示ORA-39001 ORA-39000 ORA-31641 ORA-27054错误...

迷南。 2023-01-17 15:57 266阅读 0赞

1.执行expdp命令提示ORA-27054错误

oracle@cwgsdb1:~$ expdp \\'/ as sysdba\\' directory=dir\_dp schemas=hr dumpfile=hr.dmp logfile=hr.log parallel=2

Export: Release 11.2.0.4.0 - Production on Thu Oct 25 16:55:06 2018

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31641: unable to create dump file "/backup/hr.dmp"

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

Additional information: 3

Additional information: 18

2.查看alert日志信息

Thu Oct 25 16:55:08 2018

ALTER SYSTEM SET service\_names='SYS$SYS.KUPC$C\_1\_20181025165507.CAMS' SCOPE=MEMORY SID='cams1';

ALTER SYSTEM SET service\_names='SYS$SYS.KUPC$C\_1\_20181025165507.CAMS','SYS$SYS.KUPC$S\_1\_20181025165507.CAMS' SCOPE=MEMORY SID='cams1';

Thu Oct 25 16:55:08 2018

DM00 started with pid=55, OS id=17279, job SYS.SYS\_EXPORT\_SCHEMA\_01

WARNING:NFS mount of file /backup/hr.dmp on filesystem /backup done with incorrect options:rw,xattr,dev=9640001

WARNING:Expected NFS mount options: rsize>=32768,wsize>=32768,hard,

Thu Oct 25 16:55:10 2018

ALTER SYSTEM SET service\_names='SYS$SYS.KUPC$S\_1\_20181025165507.CAMS' SCOPE=MEMORY SID='cams1';

ALTER SYSTEM SET service\_names='cams' SCOPE=MEMORY SID='cams1';

3.在MOS上查找解决方案

使用“expdp ORA-27054”关键字查找，找到MOS文档：

ORA-27054: NFS File System Where the File is Created or Resides is Not Mounted With Correct Options (文档 ID 781349.1)

SYMPTOMS

You are transferring your database/installation to a NetApps NFS mount point.

The following error occurs on database startup:

ORA-01503: CREATE CONTROLFILE failed

ORA-01565: error in identifying file '/nfs\_d04/oasisxx/data/oasis\_system.dbf'

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

The current mount point is mounted as:

rw,bg,rsize=32768,wsize=32768,hard,vers=3,nointr,timeo=600,proto=tcp,suid 0 0

CAUSE

The correct mount point options are being used but they are not in the correct order per oracle docs on correctly mounting NFS mounts for oracle software.

The correct setting should be:

rw,bg,hard,rsize=32768,wsize=32768,vers=3,nointr,timeo=600,proto=tcp,suid

NOTE:  the location of the parameter 'hard'

NOTE:  As per

, the 'intr' & 'nointr' are deprecated in UEK kernels, as well as Oracle Linux 6. It is harmless to still include it, you will get a notice..

NFS: ignoring mount option: nointr.

SOLUTION

Mount the NFS mount point with the recommended options in the exact order specified in oracle documentation.

For example:

\# mount -F nfs -o rw,bg,hard,rsize=32768,wsize=32768,vers=3,forcedirectio,nointr,proto=tcp,suid host:/folder1/to1 /folder2/to2

NOTE:  if settings revert back to original settings after remount, check auto-mounter options/settings.  For more info on auto-mounter, please contact the OS vendor.

4.重新挂载NFS文件

root@cwgsdb1:~\# umount /backup

root@cwgsdb1:~\# mount -F nfs -o rw,bg,hard,rsize=32768,wsize=32768,vers=3 100.100.100.54:/impbackup /backup

5.结果验证

oracle@cwgsdb1:/backup$ expdp directory=dir\_dp schemas=hr dumpfile=hr.dmp logfile=hr.log parallel=2

Export: Release 11.2.0.4.0 - Production on Thu Oct 25 17:14:26 2018

Username: system

Password:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

Starting "SYSTEM"."SYS\_EXPORT\_SCHEMA\_01":  system/\*\*\*\*\*\*\*\* directory=dir\_dp schemas=hr dumpfile=hr.dmp logfile=hr.log parallel=2