-
Datapump import job hang
Hi,
I am doing an import with datapump teh job seem to like hang not going anywhere since 10hrs i know for the fact that something is wrong somewhere,
staus of job from dba_datapump_jobs says executing,its trying to create materialized view and it stuck there almost 10hrs now,alert shows no errors too .Here is the output from
Import> status
Job: SYS_IMPORT_FULL_06
Operation: IMPORT
Mode: FULL
State: EXECUTING
Bytes Processed: 360,286,816
Current Parallelism: 1
Job Error Count: 0
Dump File: /u01/app/oracle/reorg/GPOGLD/impdp_dir/GPOTGL120070627.DMP
Worker 1 Status:
State: EXECUTING
Object Schema: GPC
Object Name: VENDOR
Object Type: DATABASE_EXPORT/SCHEMA/MATERIALIZED_VIEW
Worker Parallelism: 1
output from dba_resumable:
SQL> select * from dba_resumable;
USER_ID SESSION_ID INSTANCE_ID COORD_INSTANCE_ID COORD_SESSION_ID STATUS
---------- ---------- ----------- ----------------- ---------------- ---------
TIMEOUT START_TIME SUSPEND_TIME RESUME_TIME
---------- -------------------- -------------------- --------------------
NAME
--------------------------------------------------------------------------------
SQL_TEXT
--------------------------------------------------------------------------------
ERROR_NUMBER
------------
ERROR_PARAMETER1
--------------------------------------------------------------------------------
ERROR_PARAMETER2
--------------------------------------------------------------------------------
ERROR_PARAMETER3
--------------------------------------------------------------------------------
ERROR_PARAMETER4
--------------------------------------------------------------------------------
ERROR_PARAMETER5
--------------------------------------------------------------------------------
ERROR_MSG
--------------------------------------------------------------------------------
0 29 1 NORMAL
USER_ID SESSION_ID INSTANCE_ID COORD_INSTANCE_ID COORD_SESSION_ID STATUS
---------- ---------- ----------- ----------------- ---------------- ---------
TIMEOUT START_TIME SUSPEND_TIME RESUME_TIME
---------- -------------------- -------------------- --------------------
NAME
--------------------------------------------------------------------------------
SQL_TEXT
--------------------------------------------------------------------------------
ERROR_NUMBER
------------
ERROR_PARAMETER1
--------------------------------------------------------------------------------
ERROR_PARAMETER2
--------------------------------------------------------------------------------
ERROR_PARAMETER3
--------------------------------------------------------------------------------
ERROR_PARAMETER4
--------------------------------------------------------------------------------
ERROR_PARAMETER5
--------------------------------------------------------------------------------
ERROR_MSG
--------------------------------------------------------------------------------
7200
Please let me know what is wrong and where.
Thanks
-
Identify the job using:
select job_name,state from dba_datapump_jobs;
Check in alert log if there is any alerts on tablespace full etc...
Milind
-----------------------------
www.milinds.com
My Private World on the Web !
-
Do you have a resumable_timeout set to= 7200 secs? just guessing
Milind
-----------------------------
www.milinds.com
My Private World on the Web !
-
Alert log have no alerts about tablespace being full,by default i am assuming datapump has resumable_timeout set to= 7200
-
Did you try to stop_job and then start_job to see if it kicks off ? You can do it on import> prompt
Milind
-----------------------------
www.milinds.com
My Private World on the Web !
-
Datapump has issues with consuming memory on the OS side, I would look into that.
I remember when this place was cool.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|