Problem description: $ impdp system/*****@RACDB schemas=TEST directory=DP_TEST_DIR dumpfile=TEST_%U.dmp Import: Release 11.2.0.3.0 - Production on Fri Jul 12 14:59:24 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.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 Cause: impdp is connect to RAC database, but DP_TEST_DIR is point to directory on node1, Solution: connect node1 for impdp: impdp system/*****@RACDB1 schemas=TEST directory=DP_TEST_DIR dumpfile=TEST_%U.dmp
Friday, July 12, 2013
impdp failed with ORA-39002 ORA-39070 ORA-39070 ORA-06512 ORA-29283
Labels:
Dataguard
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment