This discussion is archived
1 Reply Latest reply: Apr 24, 2013 10:37 PM by Rc-oracle RSS

capture suddenly stops with ora-01280

1001593 Newbie
Currently Being Moderated
I set up a bidirectional stream environment in 11gR2 64bit on Windows 2008 R2 SP1
Everything works fins until after about 20 days, Capture process of one direction crashes.
Querying dba_capture says status:ABORTED with error message: ORA-01280: Fatal LogMiner Error.
I searched all oracle forums and literally all the web and tried increasing SGASIZE, increasing streams_pool_size, setting parallelism to 1 with no luck.
After that every time I restart capture with dbms_capture_adm.start_capture, it aborts after about a minute with the same error.
Apparently I enabled trace, but nothing noticeable in it. here is part of its 29mb.

*********************************************************************************
knlcDelivLCR: dflag2 = 0x10
knlcfFilterSpecialObj : (no,vsn,op)=(0, 0,6)
knlcDelivLCR(), discarding LCR
knlcWaitForSuspendedCapture() {
not suspend.knlcWaitForSuspendedCapture() }
knlcLoop(), krvxgt returning status 202
knlcLoop: logminer returned 0 lcrs, lowscn =0x0000.07253baf,return val = 202
knlcWaitForSuspendedCapture() {
not suspend.knlcWaitForSuspendedCapture() }

*** 2013-04-07 12:21:20.570
knlcLoop(), krvxgt returning status 202
knlcLoop: logminer returned 0 lcrs, lowscn =0x0000.07253baf,return val = 202
knlcWaitForSuspendedCapture() {
not suspend.knlcWaitForSuspendedCapture() }
knlcLoop(), krvxgt returning status 202
knlcLoop: logminer returned 0 lcrs, lowscn =0x0000.07253baf,return val = 202
knlcWaitForSuspendedCapture() {
not suspend.knlcWaitForSuspendedCapture() }
knlcLoop(), krvxgt returning status 205
knlcLoop: logminer returned 0 lcrs, lowscn =0x0000.07253baf,return val = 205
knlc.c:3289: KRVX_CHECK_ERROR retval 205
knlcnHandleError: knlcOuterLoop-2: errcode = 1280
knlcnShouldCaptureRestart: examining error stack
ORA-01280: Fatal LogMiner Error.
knlcnIsCPRestartError: examing error 1280
knlcnIsCPRestartError: 1280 is Not
knlcnShouldCaptureRestart: returning FALSE
knlcnHandleError: errcode = 1280 ignored

*** 2013-04-07 12:21:20.644
Begin knlcDumpCapCtx:*******************************************
Error 1280 : ORA-01280: Fatal LogMiner Error.

Capture Name: CAPTURE_STREAM : Instantiation#: 327

*** 2013-04-07 12:21:20.644
++++ Begin KNST dump for Sid: 249 Serial#: 364
Init Time: 04/07/2013 12:18:08
++++Begin KNSTCAP dump for : CAPTURE_STREAM
Capture#: 1 Logminer_Id: 34 State: CAPTURING CHANGES [ 04/07/2013 12:21:16]
Capture_Message_Number: 0x0000.07253baf [119880623]
Capture_Message_Create_Time: 04/04/2013 17:50:15
Enqueue_Message_Number: 0x0000.00000000 [0]
Enqueue_Message_Create_Time: 01/01/1988 00:00:00
Total_Messages_Captured: 2434
Total_Messages_Created: 40 [ 04/07/2013 12:21:19]
Total_Messages_Enqueued: 0 [ 01/01/1988 00:00:00]
Total_Full_Evaluations: 0
Elapsed_Capture_Time: 42 Elapsed_Rule_Time: 0
Elapsed_Enqueue_Time: 0 Elapsed_Lcr_Time: 3
Elapsed_Redo_Wait_Time: 0 Elapsed_Pause_Time: 0
Apply_Name :
Apply_DBLink :
Apply_Messages_Sent: 0
++++End KNSTCAP dump
++++ End KNST DUMP
+++ Begin DBA_CAPTURE dump for: CAPTURE_STREAM
Capture_Type: LOCAL
Version: 11.2.0.1.0
Source_Database: SEPEHR
Use_Database_Link: NO
Logminer_Id: 34 Logfile_Assignment: IMPLICIT
Status: ENABLED
First_Scn: 0x0000.06e193b0 [115446704]
Start_Scn: 0x0000.06e193b0 [115446704]
Captured_Scn: 0x0000.07253b2c [119880492]
Applied_Scn: 0x0000.07253b2c [119880492]
Last_Enqueued_Scn: 0x0000.00000000 [0]
Capture_User: STRMADMIN
Queue: STRMADMIN.CAPTURE_Q
Rule_Set_Name[+]: "STRMADMIN"."RULESET$_360"
Checkpoint_Retention_Time: 8
+++ End DBA_CAPTURE dump
+++ Begin DBA_CAPTURE_PARAMETERS dump for: CAPTURE_STREAM
PARALLELISM = 1 Set_by_User: NO
STARTUP_SECONDS = 0 Set_by_User: NO
TRACE_LEVEL = 127 Set_by_User: YES
TIME_LIMIT = -1 Set_by_User: NO
MESSAGE_LIMIT = -1 Set_by_User: NO
SGASIZE = 50 Set_by_User: YES
MAXIMUM_SCN = 0xffff.ffffffff [281474976710655] Set_by_User: NO
WRITE_ALERT_LOG = TRUE Set_by_User: NO
DISABLE_ON_LIMIT = FALSE Set_by_User: NO
DOWNSTREAM_REAL_TIME_MINE = TRUE Set_by_User: NO
MESSAGE_TRACKING_FREQUENCY = 2000000 Set_by_User: NO
SKIP_AUTOFILTERED_TABLE_DDL = TRUE Set_by_User: NO
SPLIT_THRESHOLD = 1800 Set_by_User: NO
MERGE_THRESHOLD = 60 Set_by_User: NO
+++ End DBA_CAPTURE_PARAMETERS dump
+++ Begin DBA_CAPTURE_EXTRA_ATTRIBUTES dump for: CAPTURE_STREAM
+++ End DBA_CAPTURE_EXTRA_ATTRIBUTES dump
++ LogMiner Session Dump Begin::
SessionId: 34 SessionName: CAPTURE_STREAM
Start SCN: 0x0000.00000000 [0]
End SCN: 0x0000.00000000 [0]
Processed SCN: 0x0000.07253bb1 [119880625]
Prepared SCN: 0x0000.07253c02 [119880706]
Read SCN: 0x0000.07253c07 [119880711]
Spill SCN: 0x0000.07253048 [119877704]
Resume SCN: 0x0000.00000000 [0]
Branch SCN: 0x0000.00000000 [0]
Branch Time: 01/01/1988 00:00:00
ResetLog SCN: 0x0000.05b001a5 [95420837]
ResetLog Time: 02/12/2013 09:56:25
DB ID: -182950585 Global DB Name: SEPEHR
krvxvtm: Enabled threads: 1
Current Thread Id: 1, Thread State 0x01
Current Log Seqn: 1141, Current Thrd Scn: 0x0000.07253c07 [119880711]
Current Session State: 0x800, Current LM Compat: 0xb200000
Flags: 0x3fa802d0, Real Time Apply is On
*******************************************************************************

An incident is also created. Here is its beginning:

*******************************************************************************
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.1 Service Pack 1
CPU : 8 - type 8664, 4 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:431M/8181M, Ph+PgF:5762M/16361M
Instance name: sepehr
Redo thread mounted by this instance: 1
Oracle process number: 80
Windows thread id: 3176, image: ORACLE.EXE (MS0K)


*** 2013-04-07 12:21:19.680
*** SESSION ID:(13.51504) 2013-04-07 12:21:19.680
*** CLIENT ID:() 2013-04-07 12:21:19.680
*** SERVICE NAME:(SYS$USERS) 2013-04-07 12:21:19.680
*** MODULE NAME:(STREAMS) 2013-04-07 12:21:19.680
*** ACTION NAME:(Logminer Builder) 2013-04-07 12:21:19.680

Dump continued from file: d:\oracle11gr2\diag\rdbms\sepehr\sepehr\trace\sepehr_ms0k_3176.trc
ORA-00600: internal error code, arguments: [krvuatla20], [], [], [], [], [], [], [], [], [], [], []

========= Dump for incident 25149 (ORA 600 [krvuatla20]) ========
***************************************************************************************
Any help will be appreciated.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points