My Oracle Support Banner

EXPDP Stopped Due To Fatal Error: ORA-39014 ORA-39029 ORA-31672 (Doc ID 2480696.1)

Last updated on DECEMBER 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms

A full DataPump Export (expdp) fails with the following errors:

...
Processing object type DATABASE_EXPORT/AUDIT
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31672: Worker process DW01 died unexpectedly.
Job "SYSTEM"."SYS_EXPORT_FULL_64" stopped due to fatal error at 23:23:16


At the same time, entries like the following appear in the alert log:

Sun Nov 04 23:00:05 2018
DM00 started with pid=112, OS id=2288, job SYSTEM.SYS_EXPORT_FULL_64
Sun Nov 04 23:00:08 2018
DW01 started with pid=113, OS id=1152, wid=1, job SYSTEM.SYS_EXPORT_FULL_64
Sun Nov 04 23:22:22 2018
Hex dump of (file 7, block 1208482) in trace file <Path>/<SID>_dw01_1152.trc
Corrupt block relative dba: 0x01d270a2 (file 7, block 1208482)
Bad check value found during user buffer read
Data in bad block:
type: 6 format: 2 rdba: 0x01d270a2
last change scn: 0x0000.08988dbc seq: 0x2 flg: 0x06
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x8dbc0602
check value in block header: 0x6754
computed block checksum: 0xe32a
Reread of rdba: 0x01d270a2 (file 7, block 1208482) found same corrupted data
Sun Nov 04 23:22:22 2018
Corrupt Block Found
        TSN = 6, TSNAME = <TablespaceName>
        RFN = 7, BLK = 1208482, RDBA = 30568610
        OBJN = 60066, OBJD = 60066, OBJECT = <TableName>, SUBOBJECT =               <<<<<<<<<<----------  TableName
        SEGMENT OWNER = <TableOwner>, SEGMENT TYPE = Table Segment                  <<<<<<<<<<----------  TableOwner
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x2] [PC:0x4A4D158, klufprd()+414]
Errors in file <Path>/<SID>_dw01_1152.trc  (incident=48917):
ORA-07445: exception encountered: core dump [klufprd()+414] [ACCESS_VIOLATION] [ADDR:0x2] [PC:0x4A4D158] [UNABLE_TO_READ] []
Incident details in: <Path>\<SID>_dw01_1152_i48917.trc
Sun Nov 04 23:22:28 2018
Trace dumping is performing id=[cdmp_20181104232228]
Sun Nov 04 23:22:30 2018
Sweep Incident[48917]: completed

Notice that it indicates the SEGMENT_TYPE is Table, and it mentions the TableName and TableOwner.

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.