LogMiner failed to extract records exist in the Database from the archive logs

BismillahirRehmanirRahim

Hi All,

I am using logminer of Oracle 10g for audit purpose to get the insert,update or delete statement for a column_value during the specified time range.

During extracting records from archive logs i found that logminer failed to extract some of the records from archive logs at specifice dates while its fetching records of other dates.

I dont know why logminer failed to extract those records while these records exist in the Database and moreover same SQL is fetching records from v$LOGMNR_CONTENTS on other dates with same WHERE Clause..

i am using DICT_FROM_ONLINE_CATALOG for the logminer dictionary and MINE_VALUE in the Where clause.

its very urgent. hope to hear soon from you guys.

Your DBA
Muhammad Salman Faheem Received on Wed Nov 21 2007 - 22:45:37 CST