expdp/impdp 数据泵报错

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, 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

原因：oracle读取默认备份目录失败

解决方法：

1.以system等管理员重新创建逻辑目录(如果要与原逻辑目录名相同需要先删除目录，重新创建)

create directory mydata as '逻辑目录路径';

如：create directory mydata as '/data/oracle/mydata';

删除目录： drop directory mydata

2.查看逻辑目录是否创建成功

select * from dba_directories

 3. 重新expdp导出或impdp导入数据，如果之前使用的默认逻辑目录需要指定directory

impdp system/ddddd@orcl remap_schema=mydb:testdb directory=mydata DUMPFILE=data1.dmp table_exists_action=replace