Helped another DBA to figure out the problem. The datapump finished without doing anything, with a full trace TRACE=1FF0300, there was nothing specific in the trace file.
-------------------------------------
......
KUPM: 13:55:39.631: dropping master since job never started
KUPM: 13:55:39.631: *******OUT DISPATCH , request type=1004 response type =2041
KUPC: 13:55:39.632: Before ENQ: Sending Type: 2041 ID: RP,KUPC$C_1_20100915135538,MCP,KUPC$A_1_20100915135539,10,Y
KUPM: 13:55:39.632: Exited main loop...
KUPV: 13:55:39.633: Update request for job: SYS.SYS_IMPORT_FULL_01, func: 1
KUPM: 13:55:39.634: Entered state: UNDEFINED
KUPM: 13:55:39.634: In RESPOND_TO_START
KUPM: 13:55:39.634: In check_workers...
KUPM: 13:55:39.634: Job is completing
.......
-------------------------------------------
Searched the alert.log file found an error: ORA-25153: Temporary Tablespace is Empty
Found the temporaory tablespace didn't have any temporary datafile, which was not added back when the DBA recreated the controlfile. After adding the temporary datafile back, the problem was resolved.
No comments:
Post a Comment