Datapump export to ASM diskgroup

We can create export dumps to the ASM diskgroups. But we can’t write expdp log to ASM (as it is a text file).

We can store following file types in ASM

– Control files
– Datafiles, temporary datafiles, and datafile copies
– SPFILEs
– Online redo logs, archive logs, and Flashback logs
– RMAN backups
– Disaster recovery configurations
– Change tracking bitmaps
– Data Pump dumpsets

Following example shows, that export is written to ASM based dictionary, but log is written to another directory (based on filesystem)

$ expdp directory=EXP_DIR dumpfile=test.dmp schemas=test 
logfile=EXPDP_DUMPDIR:test.log

SQL> select owner,directory_name,directory_path from 
dba_directories where directory_name in 
('EXP_DIR','EXPDP_DUMPDIR');
 
OWNER DIRECTORY_NAME DIRECTORY_PATH
------- ---------------- ---------------------------------------
SYS EXP_DIR +EXPDPDG00/app/oracle/admin/testdb/exp
SYS EXPDP_DUMPDIR /u01/app/oracle/admin/testdb/expdp

Where  EXP_DIR is a ASM based directory & EXPDP_DUMPDIR is on a filesystem.

Advertisements
This entry was posted in Oracle Data Pump and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s