本站文章除注明转载外，均为本站原创： 转载自love wife & love life —Roger 的Oracle技术博客
本文链接地址: 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的描述如下：
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跨平台迁移时注意这个问题，不要再次掉到坑里。
Related posts: