ORA-39070: Unable to open the log file.

Leave a reply

While executing the EXPDP command for taking logical backup of Oracle database schema. I am getting the following error:

Error:


C:\Users\Administrator>expdp dumpfile=hr_full.dmp logfile=hr_log.dmp directory=dbbackup

Export: Release 19.0.0.0.0 - Production on Tue Jun 16 06:20:58 2026
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Username: hr
Password:

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation: unexpected "LFI" error (1509)[29437]

Solution:

On check the dba directory is already present in the Oracle database

select * from dba_directories;
-- If not present then
Create directory dbbackup as 'C:\dbbackup';
Grant read,write on dbbackup to HR;

But in my case folder is not present in C: drive. So, I manually created the folder with mkdir command. So, it start works

C:\> mkdir dbbackup
-- after createing the folder its work.
C:\Users\Administrator>expdp dumpfile=hr_full.dmp logfile=hr_log.dmp directory=dbbackup
Export: Release 19.0.0.0.0 - Production on Tue Jun 16 06:21:24 2026
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
Username: hr/hr
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Starting "HR"."SYS_EXPORT_SCHEMA_01":  hr/******** dumpfile=hr_full.dmp logfile=hr_log.dmp directory=dbbackup
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
. . exported "HR"."EMPLOYEES"                            17.08 KB     107 rows
. . exported "HR"."LOCATIONS"                            8.437 KB      23 rows
. . exported "HR"."JOB_HISTORY"                          7.195 KB      10 rows
. . exported "HR"."JOBS"                                 7.109 KB      19 rows
. . exported "HR"."DEPARTMENTS"                          7.125 KB      27 rows
. . exported "HR"."COUNTRIES"                            6.367 KB      25 rows
. . exported "HR"."REGIONS"                              5.546 KB       4 rows
Master table "HR"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for HR.SYS_EXPORT_SCHEMA_01 is:
  C:\DBBACKUP\HR_FULL.DMP
Job "HR"."SYS_EXPORT_SCHEMA_01" successfully completed at Tue Jun 16 06:23:16 2026 elapsed 0 00:01:48
C:\Users\Administrator>