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:oinstall所有,如果是root的话肯定报错
二、目录和文件名不正确
数据泵导出时报:ORA-39059: dump file set is incomplete
原因是因为数据库全库导出数据总共分多个文件,如果缺少其中任何一个文件都会导致报错
impdp system/oracle directory=dump_dir dumpfile=xndlfull_20161128_01.dmp,xndlfull_20161128_02.dmp,xndlfull_20161128_03.dmp,xndlfull_20161128_04.dmp,xndlfull_20161128_05.dmp,xndlfull_20161128_06.dmp,xndlfull_20161128_07.dmp,xndlfull_20161128_08.dmp parallel=2 full=y logfile=full01.log -version=11.2.0.1.0