RE: parallel datapump export to multiple directoy objects

From: Ruel, Chris <Chris.Ruel_at_lfg.com>
Date: Wed, 20 Aug 2014 15:46:32 +0000
Message-ID: <1AFD62082EEAF0448EF1815139687F1324C2E873_at_NC2PWEX504.us.ad.lfg.com>

I was curious so I did a quick test on my rman catalog and this worked:

Directories:

SQL> create or replace directory t1 as '/backup/oracle/exports/test1';

Directory created.

SQL> create or replace directory t2 as '/backup/oracle/exports/test2';

Directory created.

PARFILE: dumpfile=t1:test_t1_%U.dmp,t2:test_t2_%U.dmp logfile=t1:test.log
parallel=2
schemas=rman

Final output...skipping all the table results:

Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded

---

Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:
/backup/oracle/exports/test1/test_t1_01.dmp
/backup/oracle/exports/test2/test_t2_01.dmp

In theory, the Datapump workers should split up the largest objects and start with those in hopes of “equalizing” the output to each channel.

Chris..

Chris Ruel * Oracle Database Administrator cruel_at_lfg.com<mailto:cruel_at_lfg.com> * Desk:317.759.2172 * Cell 317.523.8482

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dba DBA Sent: Wednesday, August 20, 2014 11:29 AM To: ORACLE-L
Subject: parallel datapump export to multiple directoy objects

Oracle: 11.2.0.3

I have a rather short window to do a 90 gb datapump full db export. Going to use parallel. My understanding is that when you do a parallel expdp, oracle creates 1 file for each parallel slave. I have several different disk devices loaded as mount points. Is it possible to use multiple directory objects in one expdp to spead out the IO?

yeah i know, doesn't mean it will help due to how devices are laid out. just wondering if its possible. i did some googling and did not see how to do this. Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 20 2014 - 17:46:32 CEST