如何对 Oracle 数据泵(expdp/impdp) 进行 debug(四)

2014-11-24 17:57:30 · 作者: · 浏览: 3
:55.052


*** MODULE NAME:() 2013-05-27 19:50:55.052


*** ACTION NAME:() 2013-05-27 19:50:55.052



KUPP:19:50:55.051: Current trace/debugflags: 00480300 = 4719360


*** MODULE NAME:(Data Pump Worker)2013-05-27 19:50:55.054


*** ACTION NAME:(SYS_EXPORT_TABLE_01)2013-05-27 19:50:55.054



KUPW:19:50:55.054: 0: ALTER SESSION ENABLEPARALLEL DML called.


KUPW:19:50:55.054: 0: ALTER SESSION ENABLEPARALLEL DML returned.


KUPC:19:50:55.098: Setting remote flag forthis process to FALSE


prvtaqis - Enter


prvtaqis subtab_name upd


prvtaqis sys table upd


KUPW:19:50:55.665: 0: KUPP$PROC.WHATS_MY_IDcalled.


KUPW:19:50:55.665: 1: KUPP$PROC.WHATS_MY_IDreturned.


KUPW:19:50:55.666: 1: worker max messagenumber: 1000


KUPW:19:50:55.668: 1: Full cluster accessallowed


KUPW:19:50:55.669: 1: Original job starttime: 13-MAY-27 07:50:51 PM


KUPW:19:50:55.671: 1: Seqno 16 isTABLE_EXPORT/TABLE/TABLE_DATA


KUPW:19:50:55.671: 1: Seqno 63 isTABLE_EXPORT/TABLE/INDEX/TABLE_DATA


KUPW:19:50:55.671: 1:KUPP$PROC.WHATS_MY_NAME called.


KUPW:19:50:55.671: 1:KUPP$PROC.WHATS_MY_NAME returned. Process name: DW00


KUPW:19:50:55.671: 1:KUPV$FT_INT.GET_INSTANCE_ID called.


KUPW:19:50:55.674: 1:KUPV$FT_INT.GET_INSTANCE_ID returned. Instance name: dave


KUPW:19:50:55.679: 1: ALTER SESSION ENABLERESUMABLE called.


KUPW:19:50:55.679: 1: ALTER SESSION ENABLERESUMABLE returned.


KUPW:19:50:55.682: 1: KUPF$FILE.INITcalled.


KUPW:19:50:55.883: 1: KUPF$FILE.INITreturned.


KUPW:19:50:55.886: 1:KUPF$FILE.GET_MAX_CSWIDTH called.


KUPW:19:50:55.886: 1:KUPF$FILE.GET_MAX_CSWIDTH returned.


[oracle@asm trace]$




[oracle@asm trace]$ head -50 dave_dm00_7484.trc


Trace file/u01/app/oracle/diag/rdbms/dave/dave/trace/dave_dm00_7484.trc


Oracle Database 11g Enterprise EditionRelease 11.2.0.3.0 - 64bit Production


With the Partitioning, Automatic StorageManagement, OLAP, Data Mining


and Real Application Testing options


ORACLE_HOME = /u01/app/oracle/11.2.0/db_1


System name: Linux


Node name: asm


Release: 2.6.32-100.34.1.el6uek.x86_64


Version: #1 SMP Wed May 25 17:46:45 EDT 2011


Machine: x86_64


Instance name: dave


Redo thread mounted by this instance: 1


Oracle process number: 35


Unix process pid: 7484, image: oracle@asm(DM00)




*** 2013-05-27 19:50:50.817


*** SESSION ID:(66.5) 2013-05-2719:50:50.817


*** CLIENT ID:() 2013-05-27 19:50:50.817


*** SERVICE NAME:(SYS$USERS) 2013-05-2719:50:50.817


*** MODULE NAME:() 2013-05-27 19:50:50.817


*** ACTION NAME:() 2013-05-27 19:50:50.817



KUPP:19:50:50.816: Current trace/debugflags: 00480300 = 4719360


*** MODULE NAME:(Data Pump Master)2013-05-27 19:50:50.823


*** ACTION NAME:(SYS_EXPORT_TABLE_01)2013-05-27 19:50:50.823



KUPC:19:50:50.823: Setting remote flag forthis process to FALSE


prvtaqis - Enter


prvtaqis subtab_name upd


prvtaqis sys table upd


KUPM:19:50:50.884: Attached to controlqueue as MCP


KUPM:19:50:50.884: While starting, controlqueue subscriber count is: 2


KUPP:19:50:50.884: Initialization completefor master process DM00


KUPM:19:50:50.916: Entered main loop


KUPM:19:50:50.922: ****IN DISPATCH at71450, request type=1001


KUPM:19:50:50.922: Current user is: SYSTEM


KUPM:19:50:50.922: hand :=DBMS_DATAPUMP.OPEN ('EXPORT', 'TABLE', '', 'SYS_EXPORT_TABLE_01', '', '2');



*** 2013-05-27 19:50:51.719


KUPM:19:50:51.719: Resumable enabled


KUPM:19:50:51.734: Entered state: DEFINING


KUPM:19:50:51.734: initing file system


KUPM:19:50:51.7