11gR2’ de olan bir oracle database’ inden 32 parallellik verilerek NFS olarak share edilmiş olan bir diske alınmış olan bir export backup’ı başka bir sistem üzerine import etmeye çalıştığımız da aşağıdaki gibi bir hata almıştık. Araştırdığımız da sorunun dmp file ‘ lerden birinde oluşan bir corruptiondan dolayı olduğunu gördük.
Çalışmaya ait logları ve ilgili hataya ait metalink notunu da aşağıda bulabilirsiniz.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 |
nohup impdp \"/ as sysdba\" DIRECTORY=EXPORT DUMPFILE=expdp_tpdb_full_%u.dmp logfile=impdp_full_tpdb.log full=Y parfile=exclude.par parallel=30 & Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Master table "SYS"."SYS_IMPORT_FULL_02" successfully loaded/unloaded Starting "SYS"."SYS_IMPORT_FULL_02": "/******** AS SYSDBA"? DIRECTORY=EXPORT DUMPFILE=expdp_tpdb_full_%u.dmp logfile=impdp_full_tpdb.log full=Y parfile=exclude.par parallel=30 Processing object type DATABASE_EXPORT/TABLESPACE ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_METADATA [SELECT process_order, flags, xml_clob, NVL(dump_fileid, :1), NVL(dump_position, :2), dump_length, dump_allocation, NVL(value_n, 0), grantor, object_row, object_schema, object_long_name, partition_name, subpartition_name, processing_status, processing_state, base_object_type, base_object_schema, base_object_name, base_process_order, property, size_estimate, in_progress, original_object_schema, original_object_name, creation_level, object_int_oid FROM "SYS"."SYS_IMPORT_FULL_02" WHERE process_order between :3 AND :4 AND duplicate = 0 AND processing_state NOT IN (:5, :6, :7) ORDER BY process_order] ORA-39183: internal error -19 ocurred during decompression phase 2 <!--more--> ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPW$WORKER", line 9001 ----- PL/SQL Call Stack ----- object line object handle number name 0x1d9f806568 20462 package body SYS.KUPW$WORKER 0x1d9f806568 9028 package body SYS.KUPW$WORKER 0x1d9f806568 4185 package body SYS.KUPW$WORKER 0x1d9f806568 9725 package body SYS.KUPW$WORKER 0x1d9f806568 1775 package body SYS.KUPW$WORKER 0x1dbf528bb0 2 anonymous block ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_METADATA [SELECT process_order, flags, xml_clob, NVL(dump_fileid, :1), NVL(dump_position, :2), dump_length, dump_allocation, NVL(value_n, 0), grantor, object_row, object_schema, object_long_name, partition_name, subpartition_name, processing_status, processing_state, base_object_type, base_object_schema, base_object_name, base_process_order, property, size_estimate, in_progress, original_object_schema, original_object_name, creation_level, object_int_oid FROM "SYS"."SYS_IMPORT_FULL_02" WHERE process_order between :3 AND :4 AND duplicate = 0 AND processing_state NOT IN (:5, :6, :7) ORDER BY process_order] ORA-39183: internal error -19 ocurred during decompression phase 2 ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPW$WORKER", line 9001 ----- PL/SQL Call Stack ----- object line object handle number name 0x1d9f806568 20462 package body SYS.KUPW$WORKER 0x1d9f806568 9028 package body SYS.KUPW$WORKER 0x1d9f806568 4185 package body SYS.KUPW$WORKER 0x1d9f806568 9725 package body SYS.KUPW$WORKER 0x1d9f806568 1775 package body SYS.KUPW$WORKER 0x1dbf528bb0 2 anonymous block Job "SYS"."SYS_IMPORT_FULL_02" stopped due to fatal error at 08:42:57 |
Çözüm olarak import edilmeye çalışılan dmp file’ lerin ftp ile binary mode’ da import edilecek olan sunucuya tekrar taşınması ve import işleminin tekrar denenmesi gerekmektedir.
Reference;
DataPump Import Errors ORA-39183 Internal Error -19 Ocurred During Decompression Phase 2 ORA-6512 (Doc ID 1524577.1)