Re: parallel datapump export to multiple directoy objects
- From: Dba DBA <oracledbaquestions@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 20 Aug 2014 11:59:37 -0400
thank you. very helpful.
On Wed, Aug 20, 2014 at 11:46 AM, Ruel, Chris <Chris.Ruel@xxxxxxx> wrote:
> 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@xxxxxxx * Desk:317.759.2172 * Cell 317.523.8482
>
>
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *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.**
>
Other related posts:
