Re: Oracle impdp parallel issues

From: sumit Tyagi <dba.tyagisumit_at_gmail.com>
Date: Mon, 24 Nov 2014 10:01:49 +0530
Message-ID: <CAFW4NVwz3hV-FgzcW098x3Vr5zOJxCNTdnmj718cZZh0FRoL=A_at_mail.gmail.com>

HI Guys,

Same issue with expdp . Please help . Any recommendations .

Starting "SYS"."SYS_EXPORT_TABLE_01": AS SYSDBA directory=EXPDP_21NOV14

dumpfile=expdp_23Nov14_LISTING_%U logfile=expdp_23Nov14_LISTING.log
tables=IME.BLS_MLSBLUE_LIST
exclude=constraint,ref_constraint,index,statistics parallel=4

Estimate in progress using BLOCKS method... Processing object type TABLE_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 89.94 GB

Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/TRIGGER

ORA-31693: Table data object "IME.BLS_MLSBLUE_LIST" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout ORA-08103: object no longer exists
Master table "SYS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded

---

BR
Sumit

On Sun, Jun 1, 2014 at 4:41 PM, Jack van Zanen <jack_at_vanzanen.com> wrote:

> Unfortunately not,
>
> Another member of the list pointd to a bug in impdp with parallel that as
> of yet is unresolved..
> Oracle has confirmed the bug, lets see if they come back with something.
>
> We are using this because of a bug we were hitting when moving database
> from tru64 to AIX and 9i to 10g (11g not supported). All clustered tables
> got messed up during the process so after migration we have to export,
> drop, recreate and import many TB of data.
> Oracle have been very ordinary in their support, even though we are paying
> for extended support.
>
> Thanks
>
> Jack
>
>
> On Sunday, June 1, 2014, David Barbour <david.barbour1_at_gmail.com> wrote:
>
>> Is this a RAC database? I've seen this on a RAC when the dump directory
>> isn't shared across the nodes.
>>
>>
>> On Thu, May 29, 2014 at 5:13 PM, Jack van Zanen <jack_at_vanzanen.com>
>> wrote:
>>
>>> Hi All,
>>>
>>> My co-worker is doing a reorg/rebuild of cluster tables which involves
>>> expdp and impdp
>>> He exports the table into multiple files using the %U parameter drops
>>> the clustered table and imports it again.
>>> During the import he gets below error.
>>> The files are there, permissions are proper and when not running in
>>> parallel it finishes without issues.
>>> We just need the parallel to make it go faster and fit withing the
>>> go-live cutover window.
>>>
>>>
>>> ORA-31693: Table data object "XYZ"."METER_READING_S11Y10M08" failed to
>>> load/unload and is being skipped due to error:
>>> ORA-29913: error in executing ODCIEXTTABLEFETCH callout
>>> ORA-31640: unable to open dump file
>>> "/oraarchive101/exp/expdp_meter_y10_04.dmp" for read
>>> ORA-19505: failed to identify file
>>> "/oraarchive101/exp/expdp_meter_y10_04.dmp"
>>> ORA-27041: unable to open file
>>> IBM AIX RISC System/6000 Error: 22: Invalid argument
>>> Additional information: 2
>>> ORA-31693: Table data object "XYZ"."METER_READING_S11Y10M01" failed to
>>> load/unload and is being skipped due to error:
>>> ORA-29913: error in executing ODCIEXTTABLEFETCH callout
>>> ORA-31640: unable to open dump file
>>> "/oraarchive101/exp/expdp_meter_y10_05.dmp" for read
>>> ORA-19505: failed to identify file
>>> "/oraarchive101/exp/expdp_meter_y10_05.dmp"
>>> ORA-27041: unable to open file
>>>
>>> Parameter File :
>>>
>>> userid=/
>>> schemas=xyz
>>> directory=meter_exp_arch
>>> dumpfile=expdp_meter_y11_%U.dmp
>>> EXCLUDE=STATISTICS
>>> logfile=impdp_meter_y11.log
>>> parallel=24
>>>
>>>
>>> This is Oracle 10.2.0.4 on AIX.
>>>
>>> Has anyone seen this before and know of a solution?
>>>
>>> Jack van Zanen
>>>
>>> -------------------------
>>> This e-mail and any attachments may contain confidential material for
>>> the sole use of the intended recipient. If you are not the intended
>>> recipient, please be aware that any disclosure, copying, distribution or
>>> use of this e-mail or any attachment is prohibited. If you have received
>>> this e-mail in error, please contact the sender and delete all copies.
>>> Thank you for your cooperation
>>>
>>
>>
>
> --
> Jack van Zanen
>
> -------------------------
> This e-mail and any attachments may contain confidential material for the
> sole use of the intended recipient. If you are not the intended recipient,
> please be aware that any disclosure, copying, distribution or use of this
> e-mail or any attachment is prohibited. If you have received this e-mail in
> error, please contact the sender and delete all copies.
> Thank you for your cooperation
>

-- 

*--*
*BR*
*Sumit Tyagi*
*+91-7829543355*

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

Received on Mon Nov 24 2014 - 05:31:49 CET