本文介绍了来自Oracle RAC环境的Expdp的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
在其中一个RAC实例上运行以下命令时
On running following command on one of the RAC Instance
expdp system/password@orcl DIRECTORY=Test DUMPFILE=user1.dmp owner=user1 LOGFILE=log1.log
我遇到以下错误:
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
我已经在同一RAC实例上使用以下SQL命令创建了"Test"目录:
I have created the 'Test' directory using following SQL command on the same RAC instance:
CREATE DIRECTORY Test AS '/usr/apps/datafiles';
能帮我成功导出数据库吗?
Can you please help me in exporting DB successfully?
推荐答案
您可以将日志文件更改为其他任何默认目录，例如DATA_PUMP_DIR，以便即使在其他任何节点上也可以执行，因为默认目录将在所有目录中可用.节点.
You can change the logfile to the any other default directory like DATA_PUMP_DIR, so that even it executes on any other node, as the default directory will be available on all nodes.
logfile=DATA_PUMP_DIR:impdp.log
这篇关于来自Oracle RAC环境的Expdp的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！