Downstream Capture Aborted with ORA-00600 [2619] and ORA-01280
(Doc ID 1422085.1)
Last updated on FEBRUARY 08, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Many Symptoms can be noticed for this problem:
Streams CAPTURE for DOWNSTREAM_CAPTURE abort and the generated trace file shows:
KSV 1280 error in secondary process
ORA-01280: Fatal LogMiner Error.
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-01280: Fatal LogMiner Error.
ORA-01280: Fatal LogMiner Error.
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-01280: Fatal LogMiner Error.
and / or
ORA-00600: internal error code, arguments: [2619], [42379], [], [], [], [], [], [], [], [], [], []
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- SQL Statement (None) -----
Current SQL information unavailable - no cursor.
Function List (to Full stack) (to Summary stack)
ksedst1 <- ksedst <- dbkedDefDump <- dbgexPhaseII <- dbgexProcessError
<- dbgePostErrorKGE <- 1244 <- kgeade <- kgeriv_int <- kgesiv
<- ksesic1 <- kcrfro <- krvxrolf_OpenLogFil <- krvxruts_UpdateThre <- adState
<- krvxrrnrl_ResolveNe <- xtRedoLog <- krvxrporr_ProcessOn <- eRedoRecord <- krvxread
<- eRedoRecord <- krvxmrs2 <- krvxmrs <- ksvrdp <- opirip
<- opidrv <- sou2o <- opimai_real <- ssthrdmain <- main
ksedst1 <- ksedst <- dbkedDefDump <- dbgexPhaseII <- dbgexProcessError
<- dbgePostErrorKGE <- 1244 <- kgeade <- kgeriv_int <- kgesiv
<- ksesic1 <- kcrfro <- krvxrolf_OpenLogFil <- krvxruts_UpdateThre <- adState
<- krvxrrnrl_ResolveNe <- xtRedoLog <- krvxrporr_ProcessOn <- eRedoRecord <- krvxread
<- eRedoRecord <- krvxmrs2 <- krvxmrs <- ksvrdp <- opirip
<- opidrv <- sou2o <- opimai_real <- ssthrdmain <- main
We also notice the following errors in the Alert_SID.log of the DB:
ORA-01280: Fatal LogMiner Error.
Incremental checkpoint up to RBA [0x1b78.294de.0], current log tail at RBA [0x1b78.294f7.0]
RFS[28]: Selected log 4 for thread 1 sequence 42449 dbid 559327564 branch 688889996
RFS LogMiner: Registered logfile [<Archive Log Location>/1_42448_688889996.dbf] to LogMiner session id [422]
RFS[28]: Selected log 5 for thread 1 sequence 42450 dbid 559327564 branch 688889996
RFS LogMiner: Registered logfile [<Archive Log Location>/1_42449_688889996.dbf] to LogMiner session id [422]
Incremental checkpoint up to RBA [0x1b78.294de.0], current log tail at RBA [0x1b78.294f7.0]
RFS[28]: Selected log 4 for thread 1 sequence 42449 dbid 559327564 branch 688889996
RFS LogMiner: Registered logfile [<Archive Log Location>/1_42448_688889996.dbf] to LogMiner session id [422]
RFS[28]: Selected log 5 for thread 1 sequence 42450 dbid 559327564 branch 688889996
RFS LogMiner: Registered logfile [<Archive Log Location>/1_42449_688889996.dbf] to LogMiner session id [422]
Under other circumstances the error can appears differently in th Alert_SID.log :
RFS LogMiner: RFS id [6531] assigned as thread [1] PING handler
RFS LogMiner: Registered logfile [/streams/from_XTRMT4/dwstrm_XTRMT4_1_13609_765478194.arc] to LogMiner session id [52]
RFS[15]: Opened log for thread 1 sequence 13610 dbid 1681702412 branch 765478194
Dumping diagnostic data in directory=[cdmp_20120215141103], requested by (instance=1, osid=15503 (MS00)), summary=[incident=88385].
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
krvxerpt: Errors detected in process 48, role reader.
krvxmrs: Leaving by exception: 600
Errors in file <path>/<SID>_ms00_15503.trc:
ORA-00600: internal error code, arguments: [2619], [13608], [], [], [], [], [], [], [], [], [], []
LOGMINER: session#=52 (DOWNSTREAM_CAPTURE), reader MS00 pid=48 OS id=15503 sid=11 stopped
Errors in file <path>/<SID>_ms00_15503.trc:
ORA-00600: internal error code, arguments: [2619], [13608], [], [], [], [], [], [], [], [], [], []
LogMiner process death detected
LOGMINER: session#=52 (DOWNSTREAM_CAPTURE), preparer MS02 pid=50 OS id=15507 sid=393 stoppedLOGMINER: session#=52 (DOWNSTREAM_CAPTURE), builder MS01 pid=49 OS id=15505 sid=200 stopped
Sweep [inc][88385]: completed
Sweep [inc2][88385]: completed
Wed Feb 15 14:11:31 2012
Streams CAPTURE CP01 for DOWNSTREAM_CAPTURE with pid=46, OS id=15497 stopped
Errors in file <path>/<SID>_cp01_15497.trc:
ORA-01280: Fatal LogMiner Error.
RFS LogMiner: Registered logfile [/streams/from_XTRMT4/dwstrm_XTRMT4_1_13609_765478194.arc] to LogMiner session id [52]
RFS[15]: Opened log for thread 1 sequence 13610 dbid 1681702412 branch 765478194
Dumping diagnostic data in directory=[cdmp_20120215141103], requested by (instance=1, osid=15503 (MS00)), summary=[incident=88385].
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
krvxerpt: Errors detected in process 48, role reader.
krvxmrs: Leaving by exception: 600
Errors in file <path>/<SID>_ms00_15503.trc:
ORA-00600: internal error code, arguments: [2619], [13608], [], [], [], [], [], [], [], [], [], []
LOGMINER: session#=52 (DOWNSTREAM_CAPTURE), reader MS00 pid=48 OS id=15503 sid=11 stopped
Errors in file <path>/<SID>_ms00_15503.trc:
ORA-00600: internal error code, arguments: [2619], [13608], [], [], [], [], [], [], [], [], [], []
LogMiner process death detected
LOGMINER: session#=52 (DOWNSTREAM_CAPTURE), preparer MS02 pid=50 OS id=15507 sid=393 stoppedLOGMINER: session#=52 (DOWNSTREAM_CAPTURE), builder MS01 pid=49 OS id=15505 sid=200 stopped
Sweep [inc][88385]: completed
Sweep [inc2][88385]: completed
Wed Feb 15 14:11:31 2012
Streams CAPTURE CP01 for DOWNSTREAM_CAPTURE with pid=46, OS id=15497 stopped
Errors in file <path>/<SID>_cp01_15497.trc:
ORA-01280: Fatal LogMiner Error.
Changes
After upgrade or without any 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 |
| References |