BUG:3877515 - Logminer Returning No Records

Logminer Not Returning Any Records [ID 291574.1]

Applies To

Oracle Server - Enterprise Edition - Version: 10.1.0.2

This problem can occur on any platform.

Symptoms

Logminer not returning any records.

Cause

Supplemental logging was not enabled.

Code:

SELECT SUPPLEMENTAL_LOG_DATA_PK ASPK_LOG,SUPPLEMENTAL_LOG_DATA_UI AS UI_LOG FROM V$DATABASE;

If the output returns:

    PK_    UI_

    ---    ---

    NO     NO

Fix

Enable supplemental logging at the database level by :

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, UNIQUE INDEX) COLUMNS;

After enabling the supplemental logging v$logmnr_contents is populated with therecords.

Select username,sql_undo from v$logmnr_contents where seg_name='LOGMINE';

USERNAME SQL_UNDO

--------------------------------------------------------------------------------

SYS

delete from "SYS"."LOGMINE" where "ID" = '1' andROWID = 'AAAM6VAABAAAOqSAAA';

SYS

update "SYS"."LOGMINE" set "ID" = '1' where"ID" = '55555' and ROWID = 'AAAM6VAA

BAAAOqSAAA';

References

BUG:3877515 - Logminer Returning No Records

Related Products ·         Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition