Mir Sayeed Hassan – Oracle Blog

Perform the expdp (fulldb/schema/table) by using the ASM Storage

Step 1 – Create the Directory in ASM location (Example – +DATA/mir_exp)

[grid@asmdb ~]$ asmcmd

ASMCMD> ls
 CRS/
 DATA/
 FRA/

ASMCMD> cd DATA

ASMCMD> mkdir mir_exp

ASMCMD> cd DATA

ASMCMD> ls

ASM/
 ASMDB1/
 bck/
 mir_exp/

ASMCMD> exit
 
 Step 2: Create the directory & give the require privileges

SQL> create directory mir_exp as '+DATA/mir_exp';
 Directory created.

SQL> grant read,write on directory mir_exp to system;
 Grant succeeded.

SQL> grant exp_full_database to system;
 Grant succeeded.

Step 3: Execute the expdp

[oracle@asmdb ~]$ expdp system/(Password) directory=mir_exp dumpfile=mir.dmp logfile=mir.log schemas=mir

Export: Release 11.2.0.4.0 - Production on Wed Jan 25 12:23:33 2017
 Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
 Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
 With the Partitioning, Automatic Storage Management, 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

Once we get the above error – Try to use the default directory for the logfile (Default directory is data_pump_dir) or   An alternative option is to use the parameter nologfile=yes

[oracle@asmdb ~]$ expdp system/stmtasm directory=mir_exp dumpfile=mir.dmp logfile=data_pump_dir:mir.log schemas=mir

Export: Release 11.2.0.4.0 - Production on Wed Jan 25 12:25:47 2017
 Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
 Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
 With the Partitioning, Automatic Storage Management, OLAP, Data Mining
 and Real Application Testing options
 Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01":  system/******** directory=mir_exp dumpfile=mir.dmp logfile=data_pump_dir:mir.log schemas=mir
 Estimate in progress using BLOCKS method...
 Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
 Total estimation using BLOCKS method: 64 KB
 Processing object type SCHEMA_EXPORT/USER
 Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
 Processing object type SCHEMA_EXPORT/ROLE_GRANT
 Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
 Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
 Processing object type SCHEMA_EXPORT/TABLE/TABLE
 . . exported "MIR"."TEST"                                5.132 KB      13 rows
 Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
 ******************************************************************************
 Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
 +DATA/mir_exp/mir.dmp
 Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Wed Jan 25 12:26:28 2017 elapsed 0 00:00:39
 
 Step 4: Verify the dumpfile in asm location:

[root@asmdb ~]# su - grid

[grid@asmdb ~]$ asmcmd

ASMCMD> ls

CRS/
 DATA/
 FRA/

ASMCMD> cd DATA

ASMCMD> ls
 ASM/
 ASMDB1/
 bck/
 mir_exp/

ASMCMD> cd mir_exp

ASMCMD> ls
 mir.dmp

Hence Tested in our ENV