DB version: 11.2.0.4 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 11.2.0.4.0 - 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 11.2.0.4.0
- 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
Solution:
You
cannot put logfiles in asm directory so specify another directory for logfile
file or use nologfile=y
Ex:
logfile= EXP: exp_STDBY_FULL_metadata.log à where ‘EXP’ is the directory in my local filesystem
(or)
Nologfile=y à This does not create
any Logfile at all
Ref:
DataPump Export (EXPDP) To ASM Directory Fails
With Errors ORA-6512 At SYS.UTL_FILE (Doc ID 1464897.1)
0 comments:
Post a Comment