ORA-01280: Fatal LogMiner Error in DBA_CAPTURE.
672869Apr 3 2009 — edited Apr 6 2009I setup a downstream real time apply replication with oracle instructions. It works fine for a few days. I changed the mount point (file system) of the database files and redo log files for source database, with a regular shutdown and startup. After that, I got error message at DBA_CAPTURE of downstream database:
ORA-01280: Fatal LogMiner Error
And corresponding error in alert log file:
ORA-00600: internal error code, arguments: [krvxbpx20], [1], [242], [37], [16], [], [], []
Thu Apr 2 00:39:02 2009
TLCR process death detected. Shutting down TLCR
Thu Apr 2 00:39:04 2009
Streams CAPTURE C001 with pid=35, OS id=21145 stopped
Thu Apr 2 00:39:04 2009
Errors in file /oracle/admin/hcarp/bdump/hcarp_c001_21145.trc:
ORA-01280: Fatal LogMiner Error.
I am not sure if the source db reboot can cause this. I will appreciate if anybody can let me know
1. What cause of this?
2. How to prevent this from happening?
3. What to do to recover/fix?
====================================
Here is major part of the trace file /oracle/admin/hcarp/bdump/hcarp_c001_21145.trc:
(source DB: DXP1P. Downstream DB: HCARP)
Unix process pid: 21145, image: oracle@fx1db01 (C001)
*** 2009-03-25 17:56:58.472
*** SERVICE NAME:(SYS$USERS) 2009-03-25 17:56:58.453
*** SESSION ID:(413.68) 2009-03-25 17:56:58.453
*** 2009-04-02 00:39:02.554
knlc.c:2619: KRVX_CHECK_ERROR retval 205
*** 2009-04-02 00:39:02.566
Begin knlcDumpCapCtx:*******************************************
Error 1280 : ORA-01280: Fatal LogMiner Error.
Capture Name: REAL_TIME_CAPTURE : Instantiation#: 1
*** 2009-04-02 00:39:02.566
++++ Begin KNST dump for Sid: 413 Serial#: 68
Init Time: 03/25/2009 17:55:35
++++Begin KNSTCAP dump for : REAL_TIME_CAPTURE
Capture#: 1 Logminer_Id: 1 State: CAPTURING CHANGES [ 04/02/2009 00:38:59]
Capture_Message_Number: 0x0003.8ae9479a [15215445914]
Capture_Message_Create_Time: 04/02/2009 00:32:46
Enqueue_Message_Number: 0x0003.8ae27ad3 [15215000275]
Enqueue_Message_Create_Time: 01/01/1988 00:00:00
Total_Messages_Captured: 116442
Total_Messages_Created: 118344 [ 04/02/2009 00:38:59]
Total_Messages_Enqueued: 1457 [ 03/27/2009 12:33:08]
Total_Full_Evaluations: 471
Elapsed_Capture_Time: 55956708 Elapsed_Rule_Time: 17
Elapsed_Enqueue_Time: 141 Elapsed_Lcr_Time: 864
Elapsed_Redo_Wait_Time: 6937736 Elapsed_Pause_Time: 0
++++End KNSTCAP dump
++++ End KNST DUMP
+++ Begin DBA_CAPTURE dump for: REAL_TIME_CAPTURE
Capture_Type: DOWNSTREAM
Version: 10.2.0.4.0
Source_Database: DXP1P
Use_Database_Link: YES
Logminer_Id: 1 Logfile_Assignment: IMPLICIT
Status: ENABLED
First_Scn: 0x0003.8adf5aa5 [15214795429]
Start_Scn: 0x0003.8adf5aa5 [15214795429]
Captured_Scn: 0x0003.8ae8f942 [15215425858]
Applied_Scn: 0x0003.8ae8f942 [15215425858]
Last_Enqueued_Scn: 0x0003.8ae27ad3 [15215000275]
Capture_User: STRMADMIN
Queue: STRMADMIN.STREAMS_QUEUE
Rule_Set_Name[+]: "STRMADMIN"."RULESET$_11"
Checkpoint_Retention_Time: 60
+++ End DBA_CAPTURE dump
+++ Begin DBA_CAPTURE_PARAMETERS dump for: REAL_TIME_CAPTURE
PARALLELISM = 1 Set_by_User: NO
STARTUP_SECONDS = 0 Set_by_User: NO
TRACE_LEVEL = 0 Set_by_User: NO
TIME_LIMIT = -1 Set_by_User: NO
MESSAGE_LIMIT = -1 Set_by_User: NO
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: YES
+++ End DBA_CAPTURE_PARAMETERS dump
+++ Begin DBA_CAPTURE_EXTRA_ATTRIBUTES dump for: REAL_TIME_CAPTURE
+++ End DBA_CAPTURE_EXTRA_ATTRIBUTES dump
++ LogMiner Session Dump Begin::
SessionId: 1 SessionName: REAL_TIME_CAPTURE
Start SCN: 0x0000.00000000 [0]
End SCN: 0x0000.00000000 [0]
Processed SCN: 0x0003.8ae947a7 [15215445927]
Prepared SCN: 0x0003.8ae94897 [15215446167]
Read SCN: 0x0003.8ae948b1 [15215446193]
Spill SCN: 0x0000.00000000 [0]
Resume SCN: 0x0000.00000000 [0]
Branch SCN: 0x0000.00000000 [0]
Branch Time: 01/01/1988 00:00:00
ResetLog SCN: 0x0003.8a502ab3 [15205411507]
ResetLog Time: 03/06/2009 23:58:56
DB ID: 1669710455 Global DB Name: DXP1P
krvxvtm: Enabled threads: 1
Current Thread Id: 1, Thread State 0x02
Current Log Seqn: 243, Current Thrd Scn: 0x0003.8ae948b1 [15215446193]
Current Session State: 0x0, Current LM Compat: 0xa200400
Flags: 0x3fa102d0, Real Time Apply is On
+++ Additional Capture Information:
Capture Flags: 325
Logminer Start SCN: 0x0003.8adf5aa5 [15214795429]
Enqueue Filter SCN: 0x0003.8adf5aa5 [15214795429]
Low SCN: 0x0003.8ae9479a [15215445914]
Capture From Date: 01/01/1988 00:00:00
Capture To Date: 01/01/1988 00:00:00
Restart Capture Flag: NO
Ping Pending: YES
Buffered Txn Count: 0
-- Xid Hash entry --
-- LOB Hash entry --
-- No TRIM LCR --
Unsupported Reason: 14
--- LCR Dump not possible ---
End knlcDumpCapCtx:*********************************************
*** 2009-04-02 00:39:02.569
error 1280 in STREAMS process
ORA-01280: Fatal LogMiner Error.
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-01280: Fatal LogMiner Error.
=====================================================
Thanks!