expdp ora-凯发app官方网站

凯发app官方网站-凯发k8官网下载客户端中心 | | 凯发app官方网站-凯发k8官网下载客户端中心

沧海拾贝

凯发app官方网站首页　| 　博文目录　| 　关于我

brjl

  • 博客访问： 3502911
  • 博文数量： 718
  • 博客积分： 1860
  • 博客等级： 上尉
  • 技术积分： 7790
  • 用 户 组： 普通用户
  • 注册时间： 2008-04-07 08:51
个人简介

偶尔有空上来看看

文章分类

全部博文（718）

文章存档

2024年（4）

2023年（74）

2022年（134）

2021年（238）

2020年（115）

2019年（11）

2018年（9）

2017年（9）

2016年（17）

2015年（7）

2014年（4）

2013年（1）

2012年（11）

2011年（27）

2010年（35）

2009年（11）

2008年（11）

我的朋友
最近访客
推荐博文
相关博文
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
expdp ora-31626

分类： oracle

2021-12-01 15:21:47

expdp 导出报错 ora-31626，加上诊断信息（expdp 时加上 trace=480300 选项，详见下面trc文件内容）再次重试

  1. trace file /u01/app/diag/rdbms/testdb/testdb/trace/testdb_dm00_1769.trc
  2. oracle database 19c enterprise edition release 19.0.0.0.0 - production
  3. version 19.6.0.0.0
  4. build label: rdbms_19.3.0.0.0dbru_linux.x64_190417
  5. oracle_home: /u01/app/product/19.3.0/db_1
  6. system name:    linux
  7. node name:    dbserver1
  8. release:    3.10.0-957.el7.x86_64
  9. version:    #1 smp thu oct 4 20:48:51 utc 2018
  10. machine:    x86_64
  11. instance name: testdb
  12. redo thread mounted by this instance: 1
  13. oracle process number: 98
  14. unix process pid: 1769, image: oracle@dbserver1 (dm00)


  17. *** 2021-11-30t18:31:18.03610008:00
  18. *** session id:(405.12272) 2021-11-30t18:31:18.03613208:00
  19. *** client id:() 2021-11-30t18:31:18.03614208:00
  20. *** service name:(sys$users) 2021-11-30t18:31:18.03614808:00
  21. *** module name:() 2021-11-30t18:31:18.03615508:00
  22. *** action name:() 2021-11-30t18:31:18.03616108:00
  23. *** client driver:() 2021-11-30t18:31:18.03616708:00
  24.  
  25. kupm: session container is: 'testdb' id: 0
  26. *** module name:(data pump master) 2021-11-30t18:31:18.10481008:00
  27. *** action name:(sys_export_schema_05) 2021-11-30t18:31:18.10482908:00
  28.  
  29. kupm:18:31:18.104: attached to control queue as mcp
  30. kupm:18:31:18.105: while starting, control queue subscriber count is: 2
  31. kupm:18:31:18.198: entered main loop
  32. kupm:18:31:18.201: ****in dispatch at 66678, request type=1001
  33. kupm:18:31:18.201: current user is: sys
  34. kupm:18:31:18.201: hand := dbms_datapump.open ('export', 'schema', '', 'sys_export_schema_05', '', '2', '0');
  35. kupm:18:31:18.204: local tstz version is: 32
  36. kupm:18:31:18.207: remote version: 19.5.0.0.0
  37. kupm:18:31:18.207: compatibility level: 19.0.0.0.0
  38. kupm:18:31:18.210: local compatibility level: 19.0.0.0.0
  39. kupm:18:31:18.210: local version: 19.5.0.0.0
  40. kupm:18:31:18.230: shard type 0
  41. kupm:18:31:18.230: not running in application root/pdb
  42. kupm:18:31:18.232: just inserted local tstz verison: 32
  43. kupm:18:31:18.236: resumable enabled
  44. kupm:18:31:18.240: entered state: defining
  45. kupm:18:31:18.240: initing file system
  46. kupm:18:31:18.251: ****out dispatch, request type=1001, response type =2041
  47. kupm:18:31:18.262: ****in dispatch at 66678, request type=1035
  48. kupm:18:31:18.262: current user is: sys
  49. kupm:18:31:18.262: dbms_datapump.set_parameter (hand, 'trace', 4719360);
  50. kupm:18:31:18.262: in check_param_dependency with name: trace
  51. kupm:18:31:18.263: ****out dispatch, request type=1035, response type =2041

  53. *** 2021-11-30t18:31:18.29986808:00
  54. kupm:18:31:18.299: ****in dispatch at 66678, request type=1022
  55. kupm:18:31:18.299: current user is: sys
  56. kupm:18:31:18.299: dbms_datapump.add_file (hand, 'ex_exp.log', 'oracle_base', 0, , 3);
  57. kupm:18:31:18.304: in is_dumpfile
  58. =================== skgfqio request dump =======================
  59. osd context: aiopend=0, aiodone=0, limfsiz=4294967295l, sigwinchslot=0
  60. request flags: read
  61. - - - - skgfrrq request element 1 - - - -
  62. blockno = 1
  63. iov: addr=0x0x8721eae8, fib=0x0x872656b0, maxaio=0, seal=0x45726963, fd=260
  64.      fsync required?=true, offset=18446744073709551615, aiopend=0
  65. fib: addr=0x0x872656b0, lblksiz=0, ora ftype=18, pblksiz=512, filsiz=1
  66.      maxvec=16, fname=/u01/app/ex_exp.log, serr=0, seal=0x45726963
  67.      fstype=0x58465342, unix ftype=0x81a4, last block=18446744073709551615
  68. iosb: addr=0x0x7f31eaf6c678, status=3, time=0, qstatus=32,aio start time=0
  69. err=27072 errno=25 ose[0]=4 ose[1]=1 ose[2]=422
  70. buffer: addr=0x0x7f31eaf6a000, len=4096
  71. kupm:18:31:18.306: error calling get_dumpfile_info: -39211
  72. kupm:18:31:18.308: ****out dispatch, request type=1022, response type =2041
  73. kupm:18:31:18.310: ****in dispatch at 66678, request type=1012
  74. kupm:18:31:18.310: current user is: sys
  75. kupm:18:31:18.310: dbms_datapump.log_entry (hand, ';;;
  76. export: release 19.0.0.0.0 - production on tue nov 30 18:31:13 2021
  77. version 19.6.0.0.0
  78. 凯发app官方网站 copyright (c) 1982, 2019, oracle and/or its affiliates. all rights reserved.
  79. ', 1);
  80. kupm:18:31:18.310: log message received from shadow:
  81. kupm:18:31:18.310: rq,kupc$c_1_20211130183117_0,kupc$a_1_183117915540000,mcp,4,y
  82. kupm:18:31:18.311: logtime in put_log_file = 0
  83. kupm:18:31:18.311: ;;;
  84. export: release 19.0.0.0.0 - production on tue nov 30 18:31:13 2021
  85. version 19.6.0.0.0
  86. 凯发app官方网站 copyright (c) 1982, 2019, oracle and/or its affiliates. all rights reserved.
  87. kupm:18:31:18.311: ****out dispatch, request type=1012, response type =2041
  88. kupm:18:31:18.313: ****in dispatch at 66678, request type=1012
  89. kupm:18:31:18.313: current user is: sys
  90. kupm:18:31:18.313: dbms_datapump.log_entry (hand, ';;;
  91. connected to: oracle database 19c enterprise edition release 19.0.0.0.0 - production', 1);
  92. kupm:18:31:18.313: log message received from shadow:
  93. kupm:18:31:18.313: rq,kupc$c_1_20211130183117_0,kupc$a_1_183117915540000,mcp,5,y
  94. kupm:18:31:18.313: logtime in put_log_file = 0
  95. kupm:18:31:18.313: ;;;
  96. connected to: oracle database 19c enterprise edition release 19.0.0.0.0 - production
  97. kupm:18:31:18.313: ****out dispatch, request type=1012, response type =2041
  98. kupm:18:31:18.314: ****in dispatch at 66678, request type=1035
  99. kupm:18:31:18.315: current user is: sys
  100. kupm:18:31:18.315: dbms_datapump.set_parameter (hand, 'command_line_client', 1);
  101. kupm:18:31:18.315: in check_param_dependency with name: command_line_client
  102. kupm:18:31:18.315: ****out dispatch, request type=1035, response type =2041
  103. kupm:18:31:18.317: ****in dispatch at 66678, request type=1035
  104. kupm:18:31:18.317: current user is: sys
  105. kupm:18:31:18.317: dbms_datapump.set_parameter (hand, 'client_command', '"/******** as sysdba" directory=oracle_base dumpfile=ex.dmp logfile=ex_exp.log schemas=exuser1 exclude=statistics trace=480300 ');
  106. kupm:18:31:18.317: in check_param_dependency with name: client_command
  107. kupm:18:31:18.318: ****out dispatch, request type=1035, response type =2041
  108. kupm:18:31:18.331: ****in dispatch at 66678, request type=1032
  109. kupm:18:31:18.331: current user is: sys
  110. kupm:18:31:18.331: in metadata filter....
  111. kupm:18:31:18.332: dbms_datapump.metadata_filter (hand, 'schema_list', ''exuser1'', '');
  112. kupm:18:31:18.334: ****out dispatch, request type=1032, response type =2041
  113. kupm:18:31:18.337: ****in dispatch at 66678, request type=1022
  114. kupm:18:31:18.338: current user is: sys
  115. kupm:18:31:18.338: dbms_datapump.add_file (hand, 'ex.dmp', 'oracle_base', 0, , 1);
  116. kupm:18:31:18.338: current file type: 0
  117. kupm:18:31:18.338: the other file type is: 3
  118. kupm:18:31:18.341: other dump file type count is: 0
  119. kupm:18:31:18.345: ****out dispatch, request type=1022, response type =2041
  120. kupm:18:31:18.347: ****in dispatch at 66678, request type=1032
  121. kupm:18:31:18.347: current user is: sys
  122. kupm:18:31:18.347: in metadata filter....
  123. kupm:18:31:18.348: dbms_datapump.metadata_filter (hand, 'exclude_path_list', ''statistics'', '');
  124. kupm:18:31:18.348: in comma_to_table with 'statistics'
  125. kupm:18:31:18.348: remaining trimmed filter: >'statistics'<
  126. kupm:18:31:18.349: added sys.statistics:
  127. kupm:18:31:18.462: ****out dispatch, request type=1032, response type =2041
  128. kupm:18:31:18.465: ****in dispatch at 66678, request type=1003
  129. kupm:18:31:18.465: current user is: sys
  130. kupm:18:31:18.465: dbms_datapump.start_job (hand, 0, 1, , 0);
  131. kupm:18:31:18.467: ...defaulting parameter estimate
  132. kupm:18:31:18.468: ...defaulting parameter compression
  133. kupm:18:31:18.468: in set_compress_flags...metadata_only
  134. kupm:18:31:18.469: ...defaulting parameter compression_algorithm
  135. kupm:18:31:18.469: start_job checking data_remap functions exist
  136. kupm:18:31:18.471: ...defaulting parameter data_access_method
  137. kupm:18:31:18.471: ...defaulting parameter data_options
  138. kupm:18:31:18.471: ...defaulting parameter include_metadata
  139. kupm:18:31:18.472: ...defaulting parameter keep_master
  140. kupm:18:31:18.472: ...defaulting parameter master_only
  141. kupm:18:31:18.472: ...defaulting parameter logtime
  142. kupm:18:31:18.472: ...defaulting parameter metrics
  143. kupm:18:31:18.472: ...defaulting parameter reuse_datafiles
  144. kupm:18:31:18.473: ...defaulting parameter skip_unusable_indexes
  145. kupm:18:31:18.473: ...defaulting parameter streams_configuration
  146. kupm:18:31:18.473: ...defaulting parameter table_consistency
  147. kupm:18:31:18.473: ...defaulting parameter max_metadata_parallel
  148. kupm:18:31:18.473: requested max_md_parallel=8
  149. kupm:18:31:18.473: adjusted max_md_parallel=8
  150. kupm:18:31:18.473: ...defaulting parameter table_exists_action
  151. kupm:18:31:18.473: ...defaulting parameter tts_full_check
  152. kupm:18:31:18.473: ...defaulting parameter user_metadata
  153. kupm:18:31:18.764: stmt to load datapump_paths is: insert into "sys"."sys_export_schema_05" (process_order, duplicate, object_path_seqno, object_type_path, object_name) select :1, rownum, seq_num, full_path, object_path from sys.datapump_paths_version where het_type = :2 and version <= 1900000000
  154. kupm:18:31:18.882: stmt to load datapump_pathmap is: insert into "sys"."sys_export_schema_05" (process_order, duplicate, object_path_seqno, object_name) select :1, rownum, seq_num, het_type from (select p.seq_num seq_num, m.het_type het_type from datapump_pathmap m, sys.datapump_paths_version p where m.object_path = p.full_path and p.object_path = p.full_path and p.het_type = :2 and version <= 1900000000)
  155. kupm:18:31:19.045: entered state: executing
  156. kupm:18:31:19.045: log message received from mcp
  157. kupm:18:31:19.045: logtime in put_log_file = 0
  158. kupm:18:31:19.045: starting "sys"."sys_export_schema_05": "/******** as sysdba" directory=oracle_base dumpfile=ex.dmp logfile=ex_exp.log schemas=exuser1 exclude=statistics trace=480300
  159. kupm:18:31:19.048: starting worker: 1 using sys.kupw$worker.main('sys_export_schema_05', 'sys', 4719360, 0);
  160. kupm:18:31:19.050: failure trying to create worker process:ora-31687: error creating worker process with worker id 1
  161. ora-31688: worker process failed during startup.
  162. ora-06512: at "sys.kupp$proc", line 81
  163. ora-06512: at "sys.kupp$proc", line 349
  164. kupm:18:31:19.050: in update_feature_tracking...
  165. kupm:18:31:19.061: ****out dispatch, request type=1003, response type =2041
  166. kupm:18:31:19.062: exited main loop...
  167. kupm:18:31:19.062: returned to main
  168. kupm:18:31:19.069: entered state: stopping
  169. kupm:18:31:19.069: keeping master because job is restartable
  170. kupm:18:31:19.069: final job_info_flags = 1
  171. kupm:18:31:19.069: log message received from mcp
  172. kupm:18:31:19.069: logtime in put_log_file = 0
  173. kupm:18:31:19.069: job "sys"."sys_export_schema_05" stopped due to fatal error at tue nov 30 18:31:19 2021 elapsed 0 00:00:01
  174. kupm:18:31:19.070: in respond_to_start
  175. kupm:18:31:19.070: in check_workers...
  176. kupm:18:31:19.070: job is completing
  177. kupm:18:31:19.169: messages remaining on status queue = 0
  178. kupm:18:31:19.169: after client wait, client count is: 0
  179. kupm:18:31:19.169: after worker wait, worker count is: 0
  180. kupm:18:31:19.169: closing job....
  181. kupm:18:31:19.169: final state in close_job is: stopped
  182. kupm:18:31:19.169: keeping master because job is restartable
  183. kupm:18:31:19.169: keep_master_flag = true
  184. kupm:18:31:19.169: delete files = false
  185. kupm:18:31:19.169: file subsystem shutdown
  186. kupm:18:31:19.169: in set_longops
  187. kupm:18:31:19.180: total work (from estimate): 0mb
  188. kupm:18:31:19.180: delta bytes adjustment: 0mb
  189. kupm:18:31:19.180: work so far is: 0mb
  190. kupm:18:31:19.180: master delete flag is: false
  191. kupm:18:31:19.232: fixed views cleaned up
  192. kupm:18:31:19.232: log file is closed.
  193. ksvp2penabled: ep->flg = 0, rpr->slv_flg = 0
  194. ksvp2penabled: ep = 0x7f31eb962510, rpr = 0x8bb747a8
提示无法创建：
failure trying to create worker process:ora-31687: error creating worker process  with worker id 1
干脆重启实例，解决
阅读(1444) | 评论(0) | 转发(0) |
0

上一篇： dia-48001

下一篇：windows ins-30131

给主人留下些什么吧！~~
| | | | |

凯发app官方网站 copyright 2001-2010 chinaunix.net all rights reserved 北京皓辰网域网络信息技术有限公司. 凯发k8官网下载客户端中心的版权所有

感谢所有关心和支持过chinaunix的朋友们
")); function link(t){ var href= $(t).attr('href'); href ="?url=" encodeuricomponent(location.href); $(t).attr('href',href); //setcookie("returnouturl", location.href, 60, "/"); }
网站地图