Thursday, October 22, 2015

ORA-39070: Unable to open the log file during EXPDP in RAC ASM

DB version: RAC 2 node
Os version: RHEL 6

SQL> create directory EXP_DIR as '+FRADG/EXP';

Directory created.

SQL> grant read,write on directory EXP_DIR to sys;

Grant succeeded.

[oracle@oraclehost]$ expdp directory=EXP_DIR dumpfile=STDBY_FULL_metadata.dmp logfile=exp_STDBY_FULL_metadata.log full=y content=metadata_only

Export: Release - Production on Sat Oct 10 23:39:03 2015

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

Username: / as sysdba

Connected to: Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
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


You cannot put logfiles in asm directory so specify another directory for logfile file or use nologfile=y

 logfile= EXP: exp_STDBY_FULL_metadata.log    à where ‘EXP’ is the directory in my local filesystem
 Nologfile=y     à This does not create any Logfile at all

DataPump Export (EXPDP) To ASM Directory Fails With Errors ORA-6512 At SYS.UTL_FILE (Doc ID 1464897.1)


Post a Comment

Auto Scroll Stop Scroll