1 Reply Latest reply: Apr 25, 2013 12:37 AM by Rc-oracle RSS

    capture suddenly stops with ora-01280

    1001593
      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.