*** MODULE NAME:(Data Pump Worker) 2024-08-22T09:36:29.562350+02:00
*** ACTION NAME:(SYS_IMPORT_FULL_01) 2024-08-22T09:36:29.562360+02:00
*** CLIENT DRIVER:(SERVER) 2024-08-22T09:36:29.562371+02:00
*** CONTAINER ID:(3) 2024-08-22T09:36:29.562382+02:00
KQR: cid 8 bucket 0 marked NORMAL
kqrpre: done po=0xcdce3ec8 cid=8 flg=2 eq=0x73b27770 pso=0x9c153d28 dur=CALL
kqrpre: keyIndex=1 hash=cbc22dc 682b1723 0
kqrpre: obobn=11152630 obname=VG_XML obtyp=2 obsta=1 obflg=0
kqrpre: SQL=CREATE TABLE ,,,,,,,,,,,,,,,
kqrpre: time=827590456
kqrpre: returnVal: FALSE
2024-08-22T09:36:29.941759+02:00
Incident 488703 created, dump file: /u01/app/oracle/diag/rdbms/arasoec1_vle22330/ARASOEC1/incident/incdir_488703/ARASOEC1_dw00_73621_i488703.trc
ORA-00600: Interner Fehlercode, Argumente: [kqrpre1-KQRDSTRU], [
in alert_log
Private strand flush not complete
Current log# 5 seq# 222133 mem# 0: /redo1/ASOEC1/redo_ASOEC1_05_01.dbf
Current log# 5 seq# 222133 mem# 1: /redo2/ASOEC1/redo_ASOEC1_05_02.dbf
2024-08-22T09:36:13.122076+02:00
ASOE02(3):KQR: cid 8 bucket 16176 marked HOT (kqrCreateUsingSecondaryKey)
ASOE02(3):KQR: cid 8 bucket 30987 marked HOT (kqrCreateUsingSecondaryKey)
ASOE02(3):KQR: cid 8 bucket 29489 marked HOT (kqrCreateUsingSecondaryKey)
ASOE02(3):KQR: cid 8 bucket 3511 marked HOT (kqrCreateUsingSecondaryKey)
ASOE02(3):KQR: cid 8 bucket 22459 marked HOT (kqrCreateUsingSecondaryKey)
ASOE02(3):KQR: cid 8 bucket 23670 marked HOT (kqrCreateUsingSecondaryKey)
2024-08-22T09:36:13.367848+02:00
Completed checkpoint up to RBA [0x363b0.2.10], SCN: 6560258675275
2024-08-22T09:36:14.080673+02:00
KQR: cid 8 bucket 20459 marked NORMAL
2024-08-22T09:36:14.086848+02:00
ASOE02(3):KQR: cid 8 bucket 12283 marked HOT (kqrCreateUsingSecondaryKey)
ASOE02(3):KQR: cid 8 bucket 20671 marked HOT (kqrCreateUsingSecondaryKey)
ASOE02(3):KQR: cid 8 bucket 9639 marked NORMAL
ASOE02(3):KQR: cid 8 bucket 13931 marked NORMAL
2024-08-22T09:36:14.170083+02:00
Beginning log switch checkpoint up to RBA [0x363b6.2.10], SCN: 6560258739497
2024-08-22T09:36:14.170258+02:00
Thread 1 advanced to log sequence 222134 (LGWR switch), current SCN: 6560258739497
Current log# 6 seq# 222134 mem# 0: /redo1/ASOEC1/redo_ASOEC1_06_01.dbf
Current log# 6 seq# 222134 mem# 1: /redo2/ASOEC1/redo_ASOEC1_06_02.dbf
2024-08-22T09:36:14.182921+02:00
ASOE02(3):KQR: cid 8 bucket 2224 marked NORMAL
2024-08-22T09:36:14.740078+02:00
ARC1 (PID:15778): Archived Log entry 222126 added for T-1.S-222133 ID 0xe9256338 LAD:1
2024-08-22T09:36:16.350056+02:00
ASOE02(3):KQR: cid 8 bucket 14553 marked HOT (kqrCreateUsingSecondaryKey)
2024-08-22T09:36:17.415062+02:00
ASOE02(3):DM00 stopped with pid=155, OS id=73295, job AS_WBS.SYS_IMPORT_FULL_01
2024-08-22T09:36:20.174508+02:00
ASOE02(3):DM00 started with pid=85, OS id=73617, job AS.SYS_IMPORT_FULL_01
2024-08-22T09:36:22.772032+02:00
ASOE02(3):
ASOE02(3):DW00 started with pid=86, OS id=73621, wid=1, job AS.SYS_IMPORT_FULL_01
2024-08-22T09:36:28.976222+02:00
Completed checkpoint up to RBA [0x363b1.2.10], SCN: 6560258702451
2024-08-22T09:36:29.559873+02:00
ASOE02(3):KQR: cid 8 bucket 0 marked NORMAL
Errors in file /u01/app/oracle/diag/rdbms/ASoec1_vle22330/ASOEC1/trace/ASOEC1_dw00_73621.trc (incident=488703) (PDBNAME=ASOE02):
ORA-00600: Interner Fehlercode, Argumente: [kqrpre1-KQRDSTRU], [], [], [], [], [], [], [], [], [], [], []
ASOE02(3):Incident details in: /u01/app/oracle/diag/rdbms/ASoec1_vle22330/ASOEC1/incident/incdir_488703/ASOEC1_dw00_73621_i488703.trc
ASOE02(3):Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2024-08-22T09:36:33.521721+02:00
Errors in file /u01/app/oracle/diag/rdbms/ASoec1_vle22330/ASOEC1/trace/ASOEC1_dw00_73621.trc (incident=488704) (PDBNAME=ASOE02):
ORA-00600: Interner Fehlercode, Argumente: [kqrpre1-KQRDSTRU], [], [], [], [], [], [], [], [], [], [], []
ASOE02(3):Incident details in: /u01/app/oracle/diag/rdbms/ASoec1_vle22330/ASOEC1/incident/incdir_488704/ASOEC1_dw00_73621_i488704.trc
2024-08-22T09:36:33.934741+02:00
Dumping diagnostic data in directory=[cdmp_20240822093633], requested by (instance=1, osid=73621 (DW00)), summary=[incident=488703].
2024-08-22T09:36:33.983388+02:00
Thread 1 cannot allocate new log, sequence 222135
Private strand flush not complete
Current log# 6 seq# 222134 mem# 0: /redo1/ASOEC1/redo_ASOEC1_06_01.dbf
Current log# 6 seq# 222134 mem# 1: /redo2/ASOEC1/redo_ASOEC1_06_02.dbf
Beginning log switch checkpoint up to RBA [0x363b7.2.10], SCN: 6560258752108
2024-08-22T09:36:34.442755+02:00
Thread 1 advanced to log sequence 222135 (LGWR switch), current SCN: 6560258752108
Current log# 8 seq# 222135 mem# 0: /redo1/ASOEC1/redo_ASOEC1_08_01.dbf
Current log# 8 seq# 222135 mem# 1: /redo2/ASOEC1/redo_ASOEC1_08_02.dbf
2024-08-22T09:36:35.020924+02:00
ARC2 (PID:15780): Archived Log entry 222127 added for T-1.S-222134 ID 0xe9256338 LAD:1
2024-08-22T09:36:35.632209+02:00
ASOE02(3):Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2024-08-22T09:36:35.632251+02:00
2024-08-22T09:36:35.632251+02:00
ASOE02(3):
ASOE02(3):DW00 terminating with fatal err=600, pid=86, wid=1, job AS.SYS_IMPORT_FULL_01
2024-08-22T09:36:36.408803+02:00
Dumping diagnostic data in directory=[cdmp_20240822093636], requested by (instance=1, osid=73621 (DW00)), summary=[incident=488704].
2024-08-22T09:36:48.109716+02:00
Beginning log switch checkpoint up to RBA [0x363b8.2.10], SCN: 6560258755211
2024-08-22T09:36:48.110041+02:00
Thread 1 advanced to log sequence 222136 (LGWR switch), current SCN: 6560258755211
Current log# 7 seq# 222136 mem# 0: /redo1/ASOEC1/redo_ASOEC1_07_01.dbf
Current log# 7 seq# 222136 mem# 1: /redo2/ASOEC1/redo_ASOEC1_07_02.dbf
2024-08-22T09:36:48.660330+02:00
ARC3 (PID:15782): Archived Log entry 222128 added for T-1.S-222135 ID 0xe9256338 LAD:1
2024-08-22T09:36:49.939182+02:00
Completed checkpoint up to RBA [0x363b2.2.10], SCN: 6560258705207
2024-08-22T09:36:50.668656+02:00
ASOE02(3):
ASOE02(3):DW00 started with pid=38, OS id=73953, wid=2, job AS.SYS_IMPORT_FULL_01
2024-08-22T09:37:01.209681+02:00
Thread 1 cannot allocate new log, sequence 222137
Private strand flush not complete
##can you please help me find the reason why this process DW00 terminated with fatal error, and what action to take .
Thank you and regards