Re: Oracle impdp parallel issues
- From: pavan kumar <pavan_843@xxxxxxxxxxx>
- To: "dba.tyagisumit@xxxxxxxxx" <dba.tyagisumit@xxxxxxxxx>, edwin devadanam <edwin_kodamala@xxxxxxxxx>
- Date: Mon, 24 Nov 2014 07:35:03 +0000 (UTC)
Hi,
Does the export is carried out with Parallel Option ? If No, then try to ignore
the parallel option while doing an impdp and give a try.It may work
Further can check for any pending transactions pending_trans$ and
dba_2pc_pending;
Another couple of questions
1. Is this RAC environment2. Does the location of export dump is shared across
on nodes (while export was performed)?
- ThanksPavan Kumar N
From: sumit Tyagi <dba.tyagisumit@xxxxxxxxx>
To: edwin devadanam <edwin_kodamala@xxxxxxxxx>
Cc: "jack@xxxxxxxxxxxx" <jack@xxxxxxxxxxxx>; David Barbour
<david.barbour1@xxxxxxxxx>; "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Sent: Monday, 24 November 2014 11:15 AM
Subject: Re: Oracle impdp parallel issues
Hi
@Oscar : Table is still there in the database . I just continued this old
thread as the error message generated was same and replated to expdp ,
anyways from next time new thread :)
@Orion : RAC or not ? not sure will check once i get back to office.
@Edwin : No xml type or lob column in table.
SR with oracle is in progress for last few days as per them :
Trace of dw :
SQL> alter system set events 'sql_trace {process : pname = dw | pname = dm}
level=8';
| WAIT #47001882895456: nam='wait for unread message on broadcast channel' ela=
1001658 channel context=14216224800 channel handle=14137260376 p3=0
obj#=12756289 tim=1416782389247019
EXEC
#47001882895456:c=1000,e=5006933,p=0,cr=4,cu=0,mis=0,r=0,dep=2,og=1,plh=0,tim=1416782389247328
ERROR #47001882895456:err=25228 tim=1416782389247359
CLOSE #47001882895456:c=0,e=24,dep=2,type=0,tim=1416782389247485
ksedmp: internal or fatal error
ORA-25228: timeout or end-of-fetch during message dequeue from
sys.kupc$que_int.transceive_int
This may be a problem at the AQ$ layer causing master process to signal object
doesn't exist.
|
|
On Mon, Nov 24, 2014 at 10:37 AM, edwin devadanam <edwin_kodamala@xxxxxxxxx>
wrote:
check this out
Data Pump Export Of An XML Table Fails With ORA-600[qmcxeGetPfxId2] (Doc ID
1921325.1) APPLIES TO: Oracle Database - Enterprise Edition - Version
11.2.0.4and laterInformation in this document applies to any platform.SYMPTOMS
ORA-600 [QMCXEGETPFXID2] is raised from DataPump ExportEXPDP of XMLType table.
Errors ora-31693, ora-29913, ora-600 are seen in export log ORA-31693: Table
data object"EVT"."DOSYA" failed to load/unload and is being skippeddue to
error:ORA-29913: error in executing ODCIEXTTABLEPOPULATE calloutORA-00600:
internal error code, arguments: [qmcxeGetPfxId2],[], [], [], [], [], [], [],
[], [], [], [] CAUSE Bug 19051460: ORA-600 [QMCXEGETPFXID2] from EXPDP of
TABLEwith XMLTYPE column and database character set is not UTF8 SOLUTION Apply
Patch 19051460 to resolve the ora-600 from tableexport failure. REFERENCES
BUG:19051460 - ORA-600 [QMCXEGETPFXID2] ON EXPDP OF TABLEWITH XMLTYPE
thanks,Edwin.K
On Monday, November 24, 2014 10:03 AM, sumit Tyagi
<dba.tyagisumit@xxxxxxxxx> wrote:
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
******************************************************************************
BRSumit
On Sun, Jun 1, 2014 at 4:41 PM, Jack van Zanen <jack@xxxxxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxxxxx> 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 calloutORA-31640: unable to open dump file
"/oraarchive101/exp/expdp_meter_y10_04.dmp" for readORA-19505: failed to
identify file "/oraarchive101/exp/expdp_meter_y10_04.dmp"ORA-27041: unable to
open fileIBM AIX RISC System/6000 Error: 22: Invalid argumentAdditional
information: 2ORA-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 calloutORA-31640: unable to open dump file
"/oraarchive101/exp/expdp_meter_y10_05.dmp" for readORA-19505: failed to
identify file "/oraarchive101/exp/expdp_meter_y10_05.dmp"ORA-27041: unable to
open file
Parameter File :
userid=/schemas=xyzdirectory=meter_exp_archdumpfile=expdp_meter_y11_%U.dmpEXCLUDE=STATISTICSlogfile=impdp_meter_y11.logparallel=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
--
--BRSumit Tyagi+91-7829543355
--
--BRSumit Tyagi+91-7829543355
Other related posts:
