来自Oracle RAC环境的Expdp [英] Expdp from Oracle RAC environment

问题描述

在其中一个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的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！