expdp ora-31626

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

Trace file /u01/app/diag/rdbms/testdb/testdb/trace/testdb_dm00_1769.trc
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.6.0.0.0
Build label: RDBMS_19.3.0.0.0DBRU_LINUX.X64_190417
ORACLE_HOME: /u01/app/product/19.3.0/db_1
System name:    Linux
Node name:    dbserver1
Release:    3.10.0-957.el7.x86_64
Version:    #1 SMP Thu Oct 4 20:48:51 UTC 2018
Machine:    x86_64
Instance name: testdb
Redo thread mounted by this instance: 1
Oracle process number: 98
Unix process pid: 1769, image: oracle@dbserver1 (DM00)


*** 2021-11-30T18:31:18.036100+08:00
*** SESSION ID:(405.12272) 2021-11-30T18:31:18.036132+08:00
*** CLIENT ID:() 2021-11-30T18:31:18.036142+08:00
*** SERVICE NAME:(SYS$USERS) 2021-11-30T18:31:18.036148+08:00
*** MODULE NAME:() 2021-11-30T18:31:18.036155+08:00
*** ACTION NAME:() 2021-11-30T18:31:18.036161+08:00
*** CLIENT DRIVER:() 2021-11-30T18:31:18.036167+08:00

KUPM: session container is: 'testdb' ID: 0
*** MODULE NAME:(Data Pump Master) 2021-11-30T18:31:18.104810+08:00
*** ACTION NAME:(SYS_EXPORT_SCHEMA_05) 2021-11-30T18:31:18.104829+08:00

KUPM:18:31:18.104: Attached to control queue as MCP
KUPM:18:31:18.105: While starting, control queue subscriber count is: 2
KUPM:18:31:18.198: Entered main loop
KUPM:18:31:18.201: ****IN DISPATCH at 66678, request type=1001
KUPM:18:31:18.201: Current user is: SYS
KUPM:18:31:18.201: hand := DBMS_DATAPUMP.OPEN ('EXPORT', 'SCHEMA', '', 'SYS_EXPORT_SCHEMA_05', '', '2', '0');
KUPM:18:31:18.204: local tstz version is: 32
KUPM:18:31:18.207: remote version: 19.5.0.0.0
KUPM:18:31:18.207: compatibility level: 19.0.0.0.0
KUPM:18:31:18.210: local compatibility level: 19.0.0.0.0
KUPM:18:31:18.210: local version: 19.5.0.0.0
KUPM:18:31:18.230: shard type 0
KUPM:18:31:18.230: not running in application root/pdb
KUPM:18:31:18.232: Just inserted local tstz verison: 32
KUPM:18:31:18.236: Resumable enabled
KUPM:18:31:18.240: Entered state: DEFINING
KUPM:18:31:18.240: initing file system
KUPM:18:31:18.251: ****OUT DISPATCH, request type=1001, response type =2041
KUPM:18:31:18.262: ****IN DISPATCH at 66678, request type=1035
KUPM:18:31:18.262: Current user is: SYS
KUPM:18:31:18.262: DBMS_DATAPUMP.SET_PARAMETER (hand, 'TRACE', 4719360);
KUPM:18:31:18.262: In Check_param_dependency with name: TRACE
KUPM:18:31:18.263: ****OUT DISPATCH, request type=1035, response type =2041

*** 2021-11-30T18:31:18.299868+08:00
KUPM:18:31:18.299: ****IN DISPATCH at 66678, request type=1022
KUPM:18:31:18.299: Current user is: SYS
KUPM:18:31:18.299: DBMS_DATAPUMP.ADD_FILE (hand, 'ex_exp.log', 'ORACLE_BASE', 0, , 3);
KUPM:18:31:18.304: In is_dumpfile
=================== skgfqio Request Dump =======================
OSD Context: aiopend=0, aiodone=0, limfsiz=4294967295l, sigwinchslot=0
Request flags: READ
- - - - skgfrrq request element 1 - - - -
BLOCKNO = 1
IOV: addr=0x0x8721eae8, fib=0x0x872656b0, maxaio=0, seal=0x45726963, fd=260
     fsync required?=TRUE, offset=18446744073709551615, aiopend=0
FIB: addr=0x0x872656b0, lblksiz=0, ora ftype=18, pblksiz=512, filsiz=1
     maxvec=16, fname=/u01/app/ex_exp.log, serr=0, seal=0x45726963
     fstype=0x58465342, unix ftype=0x81a4, last block=18446744073709551615
IOSB: addr=0x0x7f31eaf6c678, status=3, time=0, qstatus=32,AIO start time=0
err=27072 errno=25 ose[0]=4 ose[1]=1 ose[2]=422
BUFFER: addr=0x0x7f31eaf6a000, len=4096
KUPM:18:31:18.306: Error calling GET_DUMPFILE_INFO: -39211
KUPM:18:31:18.308: ****OUT DISPATCH, request type=1022, response type =2041
KUPM:18:31:18.310: ****IN DISPATCH at 66678, request type=1012
KUPM:18:31:18.310: Current user is: SYS
KUPM:18:31:18.310: DBMS_DATAPUMP.LOG_ENTRY (hand, ';;;
Export: Release 19.0.0.0.0 - Production on Tue Nov 30 18:31:13 2021
Version 19.6.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
', 1);
KUPM:18:31:18.310: Log message received from shadow:
KUPM:18:31:18.310: RQ,KUPC$C_1_20211130183117_0,KUPC$A_1_183117915540000,MCP,4,Y
KUPM:18:31:18.311: LOGTIME in PUT_LOG_FILE = 0
KUPM:18:31:18.311: ;;;
Export: Release 19.0.0.0.0 - Production on Tue Nov 30 18:31:13 2021
Version 19.6.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
KUPM:18:31:18.311: ****OUT DISPATCH, request type=1012, response type =2041
KUPM:18:31:18.313: ****IN DISPATCH at 66678, request type=1012
KUPM:18:31:18.313: Current user is: SYS
KUPM:18:31:18.313: DBMS_DATAPUMP.LOG_ENTRY (hand, ';;;
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production', 1);
KUPM:18:31:18.313: Log message received from shadow:
KUPM:18:31:18.313: RQ,KUPC$C_1_20211130183117_0,KUPC$A_1_183117915540000,MCP,5,Y
KUPM:18:31:18.313: LOGTIME in PUT_LOG_FILE = 0
KUPM:18:31:18.313: ;;;
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
KUPM:18:31:18.313: ****OUT DISPATCH, request type=1012, response type =2041
KUPM:18:31:18.314: ****IN DISPATCH at 66678, request type=1035
KUPM:18:31:18.315: Current user is: SYS
KUPM:18:31:18.315: DBMS_DATAPUMP.SET_PARAMETER (hand, 'COMMAND_LINE_CLIENT', 1);
KUPM:18:31:18.315: In Check_param_dependency with name: COMMAND_LINE_CLIENT
KUPM:18:31:18.315: ****OUT DISPATCH, request type=1035, response type =2041
KUPM:18:31:18.317: ****IN DISPATCH at 66678, request type=1035
KUPM:18:31:18.317: Current user is: SYS
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 ');
KUPM:18:31:18.317: In Check_param_dependency with name: CLIENT_COMMAND
KUPM:18:31:18.318: ****OUT DISPATCH, request type=1035, response type =2041
KUPM:18:31:18.331: ****IN DISPATCH at 66678, request type=1032
KUPM:18:31:18.331: Current user is: SYS
KUPM:18:31:18.331: In metadata filter....
KUPM:18:31:18.332: DBMS_DATAPUMP.METADATA_FILTER (hand, 'SCHEMA_LIST', ''exuser1'', '');
KUPM:18:31:18.334: ****OUT DISPATCH, request type=1032, response type =2041
KUPM:18:31:18.337: ****IN DISPATCH at 66678, request type=1022
KUPM:18:31:18.338: Current user is: SYS
KUPM:18:31:18.338: DBMS_DATAPUMP.ADD_FILE (hand, 'ex.dmp', 'ORACLE_BASE', 0, , 1);
KUPM:18:31:18.338: Current file type: 0
KUPM:18:31:18.338: The other file type is: 3
KUPM:18:31:18.341: Other Dump file type count is: 0
KUPM:18:31:18.345: ****OUT DISPATCH, request type=1022, response type =2041
KUPM:18:31:18.347: ****IN DISPATCH at 66678, request type=1032
KUPM:18:31:18.347: Current user is: SYS
KUPM:18:31:18.347: In metadata filter....
KUPM:18:31:18.348: DBMS_DATAPUMP.METADATA_FILTER (hand, 'EXCLUDE_PATH_LIST', ''STATISTICS'', '');
KUPM:18:31:18.348: In comma_to_table with 'STATISTICS'
KUPM:18:31:18.348: Remaining trimmed filter: >'STATISTICS'<
KUPM:18:31:18.349: Added SYS.STATISTICS:
KUPM:18:31:18.462: ****OUT DISPATCH, request type=1032, response type =2041
KUPM:18:31:18.465: ****IN DISPATCH at 66678, request type=1003
KUPM:18:31:18.465: Current user is: SYS
KUPM:18:31:18.465: DBMS_DATAPUMP.START_JOB (hand, 0, 1, , 0);
KUPM:18:31:18.467: ...defaulting parameter ESTIMATE
KUPM:18:31:18.468: ...defaulting parameter COMPRESSION
KUPM:18:31:18.468: In set_compress_flags...METADATA_ONLY
KUPM:18:31:18.469: ...defaulting parameter COMPRESSION_ALGORITHM
KUPM:18:31:18.469: Start_job checking DATA_REMAP functions exist
KUPM:18:31:18.471: ...defaulting parameter DATA_ACCESS_METHOD
KUPM:18:31:18.471: ...defaulting parameter DATA_OPTIONS
KUPM:18:31:18.471: ...defaulting parameter INCLUDE_METADATA
KUPM:18:31:18.472: ...defaulting parameter KEEP_MASTER
KUPM:18:31:18.472: ...defaulting parameter MASTER_ONLY
KUPM:18:31:18.472: ...defaulting parameter LOGTIME
KUPM:18:31:18.472: ...defaulting parameter METRICS
KUPM:18:31:18.472: ...defaulting parameter REUSE_DATAFILES
KUPM:18:31:18.473: ...defaulting parameter SKIP_UNUSABLE_INDEXES
KUPM:18:31:18.473: ...defaulting parameter STREAMS_CONFIGURATION
KUPM:18:31:18.473: ...defaulting parameter TABLE_CONSISTENCY
KUPM:18:31:18.473: ...defaulting parameter MAX_METADATA_PARALLEL
KUPM:18:31:18.473: requested max_md_parallel=8
KUPM:18:31:18.473: adjusted max_md_parallel=8
KUPM:18:31:18.473: ...defaulting parameter TABLE_EXISTS_ACTION
KUPM:18:31:18.473: ...defaulting parameter TTS_FULL_CHECK
KUPM:18:31:18.473: ...defaulting parameter USER_METADATA
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
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)
KUPM:18:31:19.045: Entered state: EXECUTING
KUPM:18:31:19.045: Log message received from MCP
KUPM:18:31:19.045: LOGTIME in PUT_LOG_FILE = 0
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
KUPM:18:31:19.048: Starting worker: 1 using SYS.KUPW$WORKER.MAIN('SYS_EXPORT_SCHEMA_05', 'SYS', 4719360, 0);
KUPM:18:31:19.050: Failure trying to create worker process:ORA-31687: error creating worker process with worker id 1
ORA-31688: Worker process  failed during startup.
ORA-06512: at "SYS.KUPP$PROC", line 81
ORA-06512: at "SYS.KUPP$PROC", line 349
KUPM:18:31:19.050: In update_feature_tracking...
KUPM:18:31:19.061: ****OUT DISPATCH, request type=1003, response type =2041
KUPM:18:31:19.062: Exited main loop...
KUPM:18:31:19.062: Returned to MAIN
KUPM:18:31:19.069: Entered state: STOPPING
KUPM:18:31:19.069: keeping master because job is restartable
KUPM:18:31:19.069: Final job_info_flags = 1
KUPM:18:31:19.069: Log message received from MCP
KUPM:18:31:19.069: LOGTIME in PUT_LOG_FILE = 0
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
KUPM:18:31:19.070: In RESPOND_TO_START
KUPM:18:31:19.070: In check_workers...
KUPM:18:31:19.070: Job is completing
KUPM:18:31:19.169: Messages remaining on status queue = 0
KUPM:18:31:19.169: After client wait, client count is: 0
KUPM:18:31:19.169: After worker wait, worker count is: 0
KUPM:18:31:19.169: Closing job....
KUPM:18:31:19.169: Final state in Close_job is: STOPPED
KUPM:18:31:19.169: keeping master because job is restartable
KUPM:18:31:19.169: keep_master_flag = TRUE
KUPM:18:31:19.169: Delete files = FALSE
KUPM:18:31:19.169: File subsystem shutdown
KUPM:18:31:19.169: In set_longops
KUPM:18:31:19.180: Total work (from estimate): 0MB
KUPM:18:31:19.180: Delta bytes adjustment: 0MB
KUPM:18:31:19.180: Work so far is: 0MB
KUPM:18:31:19.180: Master delete flag is: FALSE
KUPM:18:31:19.232: Fixed views cleaned up
KUPM:18:31:19.232: Log file is closed.
ksvp2penabled: ep->flg = 0, rpr->slv_flg = 0
ksvp2penabled: ep = 0x7f31eb962510, rpr = 0x8bb747a8

提示无法创建：
Failure trying to create worker process:ORA-31687: error creating worker process  with worker id 1
干脆重启实例，解决