impdp或expdp报错ORA-39002: invalid operation,ORA-39070: Unable to open the log file

  [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/
  • 7
    点赞
  • 22
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 5
    评论
评论 5
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

东城绝神

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值