Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Today, I will be sharing with you the reasons for the ORA-39070 error we received on Oracle Database and how to solve it.
Error;
ORA-39070: Unable To Open The Log File
It gives error because LOG files cannot be created while backing up with EXPDP. The error is given the same for Standalone and Rac users.
An example image of the error is as follows.
1 2 3 4 5 6 | 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 |
Solution;
1 2 3 4 | create directory expdp_dump_dir as ‘/u01/app/oracle/directory’; grant read,write on directory expdp_dump_dir to backup_admin; grant datapump_exp_full_database to backup_admin; grant datapump_imp_full_database to backup_admin; |
In addition, if there is an existing directory, we need to make sure that the user has write permissions with the following query.
1 2 3 4 5 6 7 8 | declare f utl_file.file_type; begin f := utl_file.fopen ('expdp_dump_dir', 'test.txt', 'w'); utl_file.put_line(f, 'test'); utl_file.fclose(f); end; / |
