xtts expdp hung at inital stages
本站文章除注明转载外，均为本站原创： 转载自love wife love life —Roger的Oracle/MySQL/PostgreSQL数据恢复博客
本文链接地址: xtts expdp hung at inital stages
上周6某电信客户进行OSS数据库从aix到Linux的跨平台迁移升级，数据库版本并没有太大变化，即从11.2.0.3 到11.2.0.4。友商在进行3次测试，据说都没有太大问题。
然而，在正式割接时，进行元数据导出时，发现expdp操作hung住，几十分钟都没有任何反应，最后通过dblink的方式直接在目标库进行impdp操作来绕过了该问题。
经查确认是该Oracle Bug 16318046 : TTS EXPORT STUCK AT INITIAL STAGES，关于该bug的描述如下：
|
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 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 |
Bug 16318046 : TTS EXPORT STUCK AT INITIAL STAGES Bug 属性 类型 B - Defect 已在产品版本中修复 严重性 2 - Severe Loss of Service 产品版本 11.2.0.3 状态 36 - Duplicate Bug. To Filer 平台 226 - Linux x86-64 创建时间 2013-2-13 平台版本 NO DATA 更新时间 2016-8-5 基本 Bug 13717234 数据库版本 11.2.0.3 影响平台 Generic 产品源 Oracle 与此 Bug 相关的知识, 补丁程序和 Bug 相关产品 产品线 Oracle Database Products 系列 Oracle Database Suite 区域 Oracle Database 产品 5 - Oracle Database - Enterprise Edition Hdr: 16318046 11.2.0.3 RDBMS 11.2.0.3 DATA PUMP EXP PRODID-5 PORTID-226 13717234 Abstract: TTS EXPORT STUCK AT INITIAL STAGES *** 02/12/13 10:36 am *** PROBLEM: -------- expdp "'/ as sysdba'" parfile=auexpxtts.dat ;;; Export: Release 11.2.0.3.0 - Production on Wed Jan 23 23:00:14 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. ;;; Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning and Oracle Label Security options Starting "SYS"."SYS_EXPORT_TRANSPORTABLE_01": "/******** AS SYSDBA" parfile=auexpxtts.dat DIAGNOSTIC ANALYSIS: -------------------- SQL ID: bjf05cwcj5s6p Plan Hash: 0 BEGIN :1 := sys.kupc$que_int.receive(:2); END; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 16229 1.79 2.17 0 0 0 0 Execute 16228 45.18 81114.46 0 65309 0 26 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 32457 46.98 81116.63 0 65309 0 26 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: SYS (recursive depth: 2) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ wait for unread message on broadcast channel 81109 1.38 81058.42 library cache: mutex X 2 0.00 0.00 library cache lock 1 4.69 4.69 ****************************************************************************** ** Trace file: P2PDB21_dm03_34603216.trc SQL ID: bjf05cwcj5s6p Plan Hash: 0 BEGIN :1 := sys.kupc$que_int.receive(:2); END; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 140 0.01 0.01 0 0 0 0 Execute 140 0.33 496.10 0 1656 0 70 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 280 0.34 496.11 0 1656 0 70 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: SYS (recursive depth: 2) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ wait for unread message on broadcast channel 519 1.12 495.72 ****************************************************************************** ** Trace file: P2PDB21_dw00_37552328.trc SQL ID: 82n5hj2hgrbdx Plan Hash: 2296790768 SELECT objnum FROM (SELECT r, objnum FROM (SELECT rownum r, o.obj# objnum FROM sys.obj$ o, sys.tab$ t, sys.dba_xml_tab_cols x, sys.user$ u WHERE t.ts# = :1 AND t.obj# = o.obj# AND o.name = x.table_name AND o.owner# = u.user# AND u.name = x.owner AND (x.storage_type = 'BINARY') AND NOT EXISTS (SELECT 1 FROM sys.ku_noexp_tab noexp WHERE noexp.obj_type = 'USER' AND noexp.name = u.name)) ) WHERE r = 1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 436 0.12 0.14 0 680 0 0 Fetch 435 75154.06 79676.07 1 56238520 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 872 75154.19 79676.21 1 56239200 0 0 WORKAROUND: ----------- use normal export but ct using EBS and required to use datapump. RELATED BUGS: ------------- Bug:13728919 REPRODUCIBILITY: ---------------- TEST CASE: ---------- STACK TRACE: ------------ SUPPORTING INFORMATION: ----------------------- 24 HOUR CONTACT INFORMATION FOR P1 BUGS: ---------------------------------------- DIAL-IN INFORMATION: -------------------- |
在此记录一下，希望大家以后在进行xtts跨平台迁移时注意这个问题，不要再次掉到坑里。
Leave a Reply
You must be logged in to post a comment.