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

- Logminer Returning No Records

Related

Products

·         Oracle Database Products > Oracle Database > Oracle Database > Oracle Server – Enterprise Edition