impdp, expdp error ORA-39070 has me dead in the water
832601Jul 11 2011 — edited Jul 18 2013I'm writing backup and restore scripts for a software testing system using multiple combinations of servers (several flavors of Windows) and databases (SQL Server and Oracle). I am unable to automatically backup or restore Oracle databases using expdp or impdp because Oracle is issuing error ORA-39070: Unable to open the log file.
The log file is created, I issue the following command at the beginning of the session:
create or replace directory qa211_dumpdir as '\\<db_ip_address\H$\Backup\qa211';
create or replace directory qa211_logdir as '\\<test_ip_address>\C$\Temp';
<db_ip_address> is the IP for the Oracle database server.
<test_ip_address> is the IP for the software test computer. This is NOT the same as db_ip_address.
'\\<test_ip_address>\C$\Temp' is a public folder, anybody here in the company may read/write to it.
These commands are executed without error. I've tried specifying the directory paths both with and without the trailing backslash, that doesn't seem to make any difference.
I then execute the following command:
impdp qa211/qa211@qa211 DIRECTORY=qa211_dumpDir DUMPFILE=5.0.0_baseline.dmp LOGFILE=qa211_logDir:or_restore_out.txt
Which generates the following response:
Import: Release 11.2.0.1.0 - Production on Mon Jul 11 10:12:48 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
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
The log file must be generated on the test machine, not on the database server. I use QTP scripts to examine the contents of the backup/restore log files to verify that the operations were performed successfully. If failures occur, I need the log files for analysis.
Any help would be greatly appreciated.