impdp或expdp报错ORA-39002: invalid operation,ORA-39070: Unable to open the log file
来源:互联网 发布:歼十模型淘宝 编辑:程序博客网 时间:2024/06/06 01:40
[oracle@oracle-rac01 backup]$ cat expdp.par
USERID='/ as sysdba'
DIRECTORY=KMDATA_EXP
job_name=jinky_exp
filesize=5000m
parallel=4
compression=all
DUMPFILE=km_%U.dmp
#LOGFILE=km_exp.log
SCHEMAS=(kmdata)
CONTENT=ALL
CLUSTER=NO
[oracle@oracle-rac01 backup]$ expdp parfile=expdp.par
Export: Release 11.2.0.4.0 - Production on Mon Sep 4 09:20:59 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
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-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
解决:重新创建备份目录
1.1先删除原先创建的备份目录
SQL> drop directory kmdata_exp ;
1.2 重新创建新的备份目录
SQL> create or replace directory kmdata_exp as '/u01/app/oracle/backup ';
Directory created.
SQL> grant read,write on directory kmdata_exp to public ;
1.3 修改备份目录的属主和属组
[root@oracle-rac01 ~]# mkdir /u01/app/backup/
[root@oracle-rac01 ~]# chown -R oracle:oinstall /u01/app/oracle/backup/
USERID='/ as sysdba'
DIRECTORY=KMDATA_EXP
job_name=jinky_exp
filesize=5000m
parallel=4
compression=all
DUMPFILE=km_%U.dmp
#LOGFILE=km_exp.log
SCHEMAS=(kmdata)
CONTENT=ALL
CLUSTER=NO
[oracle@oracle-rac01 backup]$ expdp parfile=expdp.par
Export: Release 11.2.0.4.0 - Production on Mon Sep 4 09:20:59 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
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-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
解决:重新创建备份目录
1.1先删除原先创建的备份目录
SQL> drop directory kmdata_exp ;
1.2 重新创建新的备份目录
SQL> create or replace directory kmdata_exp as '/u01/app/oracle/backup ';
Directory created.
SQL> grant read,write on directory kmdata_exp to public ;
1.3 修改备份目录的属主和属组
[root@oracle-rac01 ~]# mkdir /u01/app/backup/
[root@oracle-rac01 ~]# chown -R oracle:oinstall /u01/app/oracle/backup/
阅读全文
0 0
- impdp或expdp报错ORA-39002: invalid operation,ORA-39070: Unable to open the log file
- ORA-39002: invalid operation ORA-39070: Unable to open the log file.
- expdp ORA-39070: Unable to open the log file
- impdp 报ORA-06512: at "SYS.UTL_FILE", line 488 ORA-29283: invalid file operation
- expdp/impdp ORA-39002&ORA-39166
- ORA-39002: invalid operation
- ora-39002 invalid operation
- expdp导出报错ORA-39002、ORA-39070解决办法
- expdp导出报错ORA-39002、ORA-39070解决办法
- ORACLE11G RAC expdp报错ORA-39002 ORA-39070 ORA-29283 ORA-06512
- 执行EXPDP操作时出现ORA-29283: invalid file operation错误
- expdp直接导出文件到NFS共享的挂载目录,报错ORA-27086: unable to lock file - already in use
- ORA-07391: sftopn: fopen error, unable to open text file
- ORA-31640: unable to open dump file 问题解决
- ORA-07391: sftopn: fopen error, unable to open text file.
- ORACLE impdp或expdp与ORA-31693&ORA-31640&ORA-19505&ORA-27037
- 告警日志报“ORA-01565 Unable To open Spfile”
- impdp报错ORA-31631、ORA-39122
- glide加载gif动态图
- Tomcat简介
- Python(4) 序列
- c0201时遇到的问题
- Python(5) 面向对象相关
- impdp或expdp报错ORA-39002: invalid operation,ORA-39070: Unable to open the log file
- Python(6) 异常处理
- two_sum
- 快速掌握Glide图片加载的强大功能你如果
- 设计模式13-策略模式
- c++设计模式三,工厂模式
- 洛谷 P1220 关路灯
- csdn 的友链设置
- Python(7) 日期操作