博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
oracle之 数据泵dump文件存放nfs报ORA-27054
阅读量:5745 次
发布时间:2019-06-18

本文共 1365 字,大约阅读时间需要 4 分钟。

问题描述:源端 10.2.0.4  目标端:11.2.0.4   在目标端划分1T存储与源端做一个NFS

错误:指定dump导出为本地文件系统,正常。   指定dump导出为nfs文件系统,报错。

报错信息如下:

ORA-39001: invalid argument value

ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "/devotd_dpump/expdp_metadata_vspp_sun.dmp"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

CAUSE

The NFS mount options seem to be incorrect. No specific setting was found to address this. The below options were tried but the same error was still encountered:

  1. Mount options as per  - ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
  2. Backup using RMAN into this problematic mount point was successful
  3. Traditional export using exp to this problematic mount point was successful
  4. Creation of a new datafile to this mount point was successful
  5. Creation of a file from OS side to this problematic mount point was successful
  6. Reboot of the NFS mount point made no difference

SOLUTION

The only solution which worked in this case was to set the below event which disables the mount point parameter checking:

sqlplus / as sysdba
alter system set events '10298 trace name context forever, level 32';
 
做 10298 events 后,解决问题。

转载地址:http://xmxzx.baihongyu.com/

你可能感兴趣的文章
Entity Framework 实体框架的形成之旅--Code First模式中使用 Fluent API 配置(6)
查看>>
OpenMediaVault 搭建git,ssh无法连接问题
查看>>
java多线程之:Java中的ReentrantLock和synchronized两种锁定机制的对比 (转载)
查看>>
mysql性能优化学习笔记-参数介绍及优化建议
查看>>
【Web动画】SVG 实现复杂线条动画
查看>>
使用Wireshark捕捉USB通信数据
查看>>
《树莓派渗透测试实战》——1.1 购买树莓派
查看>>
Apache Storm 官方文档 —— FAQ
查看>>
iOS 高性能异构滚动视图构建方案 —— LazyScrollView
查看>>
Java 重载、重写、构造函数详解
查看>>
【Best Practice】基于阿里云数加·StreamCompute快速构建网站日志实时分析大屏
查看>>
【云栖大会】探索商业升级之路
查看>>
HybridDB实例新购指南
查看>>
C语言及程序设计提高例程-35 使用指针操作二维数组
查看>>
华大基因BGI Online的云计算实践
查看>>
深入理解自定义Annotation,实现ButterKnif小原理
查看>>
排序高级之交换排序_冒泡排序
查看>>
Cocos2d-x3.2 Ease加速度
查看>>
[EntLib]关于SR.Strings的使用办法[加了下载地址]
查看>>
中小型网站架构分析及优化
查看>>