Using ASM with DataPump

Post date: Jul 22, 2011 3:10:0 PM

1. Create a Directory in ASM for the dumpfile

$ su - grid

$ asmcmd

$ ls

DATA

FRA

OCR_VOTING

$ cd data

$ mkdir dpdump

2. Create an Oracle Directory in the database to use the dumpfile

$ sqlplus / as sysdba

SQL> create or replace directory ASM_DUMP as '+DATA/dpdump';

SQL> grant read,write on directory asm_dump to system;

3. Create a Unix directory for the logfile

$ mkdir /home/oracle/log

4. Create an Oracle Directory for the logfile

$ sqlplus / as sysdba

SQL> create or replace directory LOGDIR as '/home/oracle/log';

SQL> grant read,write on directory logdir to system;

5. create a parameter file for the datapump export

$ vi expdp_full.par

userid=system/password

directory=asm_dump

logfile=logdir:import.log

full=y

6. run datapump export 

$ expdp parfile=expdp_full.par