Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

impdp, expdp error ORA-39070 has me dead in the water

832601Jul 11 2011 — edited Jul 18 2013
I'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.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 15 2013
Added on Jul 11 2011
14 comments
73,876 views