impdp时不报错地hang住
impdp时不报错地hang住 Import: Release 11.2.0.2.0 - Production on Wed Jan 22 12:27:27 2014 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0
impdp时不报错地hang住
Import: Release 11.2.0.2.0 - Production on Wed Jan 22 12:27:27 2014 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options Master table "SYS"."IMPDP_FWY" successfully loaded/unloaded Starting "SYS"."IMPDP_FWY": /******** AS SYSDBA parfile=impdp.par Processing object type TABLE_EXPORT/TABLE/TABLE Processing object type TABLE_EXPORT/TABLE/TABLE_DATA . . imported "GBSMIS"."GM_ACCOUNT_MAIN" 20.37 GB 114580038 rows . . imported "GBSMIS"."GM_CLAIM_SETTLED_BACKUP" 7.775 GB 24464956 rows . . imported "GBSMIS"."GM_CLAIM_LIAB_CAL" 7.287 GB 27262351 rows . . imported "GBSMIS"."GM_CLAIM_DOCU" 7.030 GB 24851389 rows . . imported "GBSMIS"."GM_POL_MAIN_BACKUP" 3.896 GB 7287304 rows . . imported "GBSMIS"."GM_POL_FEE_TABLE" 2.791 GB 16147645 rows . . imported "GBSMIS"."GM_ANNUITY_ACHIEVE_INTF_NEW" 1.289 GB 16874511 rows . . imported "GBSMIS"."GM_CLAIM_SCENE_CAL" 881.9 MB 2457482 rows . . imported "GBSMIS"."GM_MANAGE_FEE_SUM" 14.71 MB 291045 rows . . imported "GBSMIS"."PAYMENT_COMPANY_CARD_TABLE" 13.74 MB 113421 rows . . imported "GBSMIS"."GM_UNDWRTTIMES" 5.596 MB 59175 rows . . imported "GBSMIS"."GM_SYNC_ICSS_IPRS_COMMON" 1012. KB 2352 rows . . imported "GBSMIS"."GM_DEPARTMENT_TABLE" 391.7 KB 4464 rows . . imported "GBSMIS"."GM_DEPARTMENT_TABLE_NEW" 391.7 KB 4464 rows . . imported "GBSMIS"."GM_DEPTFLAG" 10.13 KB 36 rows . . imported "GBSMIS"."GM_THREE_DEPARTMENT" 318.2 KB 4424 rows . . imported "GBSMIS"."GM_SYNC_ICSS_IPRS_QUESTION" 612.5 KB 9529 rows . . imported "GBSMIS"."EXISTING_TRANSFER_CLIENT_PREM" 471.0 KB 4327 rows . . imported "GBSMIS"."GM_SYNC_ICSS_IPRS_BUSINESS" 194.8 KB 2352 rows . . imported "GBSMIS"."EXISTING_TRANSFER_CLIENT" 63.66 KB 1204 rows . . imported "GBSMIS"."GM_LIAB_ITEM_TBL" 12.93 KB 86 rows Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX 到Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX时hang住了，最大的表是20G，为其建索引虽慢，也用不着一晚都没完呀。 网上搜索了一下，说impdp时开并行可能遇到了bug，好吧我绕过它，我把parallel=4删掉。 重新发起，等了好几个小时后仍然在这里hang住了，看来不是parallel的问题。 登陆数据库看情况。 从datapump的视图看来，导入是正常运行的。 SQL> @datapump -- dba_datapump_sessions OWNER_NAME JOB_NAME INST_ID SADDR SESSION_TYPE ------------------------------ ------------------------------ ---------- ---------------- -------------- SYS IMPDP_FWY 1 0000000728748330 DBMS_DATAPUMP SYS IMPDP_FWY 1 000000072C7B0918 MASTER SYS IMPDP_FWY 1 000000073C7FEFC8 WORKER -- dba_datapump_jobs OWNER_NAME JOB_NAME OPERATION JOB_MODE STATE DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS ------------------------------ ------------------------------ ------------------------------------------------------------ ------------------------------------------------------------ ------------------------------ ---------- ----------------- ----------------- SYS IMPDP_FWY IMPORT FULL EXECUTING 1 1 3 看下我导入的用户，sys用户，在等什么。 SQL> @waitbyusr sys --V$SESSION_WAIT displays the current or last wait for each session. --@sid 19,25,232 SID EVENT 等待时间 STATE STATUS WAIT_CLASS ----- ------------------------------ ------------------------------ ------------------- -------- ---------------------------------------------------------------- 721 wait for unread message on bro 已等1秒 WAITING ACTIVE Idle adcast channel 993 wait for unread message on bro 已等1秒 WAITING ACTIVE Idle adcast channel 网上搜了下这个等待，结合我的Impdp，好像也没啥线索。 从后台attach这个job登陆 Worker 1 Status: Process Name: DW00 State: EXECUTING Object Schema: GBSMIS Object Name: IDX_GM_ACCOUNT_MAIN_LCD Object Type: TABLE_EXPORT/TABLE/INDEX/INDEX Completed Objects: 1 Worker Parallelism: 1 显示的确是在建索引IDX_GM_ACCOUNT_MAIN_LCD，因为是DDL语句，没建完我也不能从数据库层面看他是否存在以及是否在增长。 此时一切看来正常，难道我还得在等一晚上？ 看到process name是DW00，再登陆到数据库中。 SQL> select * from v$process where program like '%DW00%'; ADDR PID SPID PNAME USERNAME SERIAL# TERMINAL PROGRAM TRACEID TRACEFILE BACKGROUND LATCHWAIT LATCHSPIN PGA_USED_MEM PGA_ALLOC_MEM PGA_FREEABLE_MEM PGA_MAX_MEM ---------------- ---------- ------------------------ ----- -------------------- ---------- ------------------------------ ------------------------------------------------ -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---------- ---------------- ---------------- ------------ ------------- ---------------- ----------- 000000075C5AA808 63 16224 DW00 otzj11g 47 UNKNOWN oracle@cnsh281003 (DW00) /paic/stg/oracle/11g/app/oracle/diag/rdbms/molapstg/molapstg/trace/molapstg_dw00 1 65156820 1187400836 1120534528 1187400836 这个DW00并不是DBWR进程。 DBW0 是dbwr进程,写datafile用的. DW0是datapump worker进程,给 impdp/expdp用的. 通过spid16224可以得到会话sid是1009 SQL> @sidbyspid 16224 SID ----- 1009 SQL> 看看1009会话在等什么。 SQL> @waitbysid 1009 --V$SESSION_WAIT displays the current or last wait for each session. --@sid 19,25,232 SID EVENT 等待时间 STATE STATUS WAIT_CLASS ----- ------------------------------ ------------------------------ ------------------- -------- ---------------------------------------------------------------- 1009 statement suspended, wait erro 已等0秒 WAITING ACTIVE Configuration r to be cleared SQL> statement suspended, wait erro to be cleared等待，此时百度一搜，惜分飞的文章映入眼帘，顿时春暖花开。 是因为表空间不足，所以hang住了。此时看了下表空间，是足够的，是表空间所在的asm dg已经满了。 所以申请存储扩diskgroup，搞定。
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1386
52
Column count doesn't match value count at row 1 - How to solve MySQL error: column number does not match value
Oct 05, 2023 am 11:40 AM
How to solve MySQL error: The number of columns does not match the value. Specific code examples are needed. When using the MySQL database for data operations, sometimes you will encounter the error message: "Columncountdoesn'tmatchvaluecountatrow1", which means that the number of columns does not match the number of values. match. This error usually occurs when inserting data and the number of columns specified is inconsistent with the number of values inserted. This article describes specific workarounds and provides code examples. examine
Incorrect table definition; there can be only one auto column and it must be defined as a key - How to solve MySQL error: Incorrect table definition; there can be only one auto column and it must be defined as a key
Oct 05, 2023 am 11:05 AM
How to solve MySQL error: Wrong table definition; there can only be one automatic column and it must be defined as a key. Specific code examples are required. In recent years, MySQL database has become more and more widely used, but during use, we often encounter Various error reports. Among them, a common error is "wrong table definition; there can only be one automatic column and it must be defined as a key". This error usually occurs when we create a table, which may be a headache for beginners. This article will give you a detailed analysis of the reasons for this error and provide specific
Cause analysis: HTTP request error 504 gateway timeout
Feb 19, 2024 pm 05:12 PM
Brief introduction to the reason for the http request error: 504GatewayTimeout: During network communication, the client interacts with the server by sending HTTP requests. However, sometimes we may encounter some error messages during the process of sending the request. One of them is the 504GatewayTimeout error. This article will explore the causes and solutions to this error. What is the 504GatewayTimeout error? GatewayTimeo
Solution: Socket Error when handling HTTP requests
Feb 25, 2024 pm 09:24 PM
http request error: Solution to SocketError When making network requests, we often encounter various errors. One of the common problems is SocketError. This error is thrown when our application cannot establish a connection with the server. In this article, we will discuss some common causes and solutions of SocketError. First, we need to understand what Socket is. Socket is a communication protocol that allows applications to
Step-by-step guide to quickly solve pyqt5 installation errors
Jan 19, 2024 am 09:32 AM
If you are learning Python and want to develop GUI applications, PyQt5 is a very good choice. It is a bound version of the PyQt library under Python, which makes it very convenient to call and develop the Qt graphics library. However, sometimes you may encounter some problems when installing PyQt5. This guide will provide you with some steps to quickly solve installation error problems, and also attach specific code examples. Make sure the Python version is correct PyQt5 is a Python-based library, so first
Unknown column 'column_name' in 'where clause' - How to solve MySQL error: unknown column in where clause
Oct 05, 2023 am 11:15 AM
Unknowncolumn'column_name'in'whereclause'-How to solve MySQL error: unknown column in where clause, specific code example is needed MySQL is a widely used relational database management system, which supports the use of Structured Query Language (SQL) Storage, management and retrieval of data. However, when using MySQL to query, sometimes we will encounter errors. One of the common errors is: Unkno
Incorrect syntax near 'error_keyword' - How to solve MySQL error: syntax error
Oct 05, 2023 pm 04:24 PM
Errors are one of the problems that developers often encounter when writing MySQL query statements. One of the common errors is "Incorrectsyntaxnear 'error_keyword'" (Syntax error near 'error_keyword'). This error message is very common and means that there is a syntax error in the MySQL query statement. In this article, we'll detail how to solve this problem and provide some concrete code examples. First, let's look at
Golang compilation error: How to solve undefined function error
Nov 25, 2023 am 08:59 AM
Golang compilation error: How to solve undefinedfunction error Overview: Go language is a statically typed programming language, and the compiler will check for errors in the code during the compilation phase. One of the common compilation errors is "undefinedfunction", which means that when using a function, the compiler cannot find the definition of the function. This article will describe some common causes of this error and provide solutions. Function not imported: The most common situation is when we use an
