LogMiner failed to extract records exist in the Database from thearchive logs -
11-21-2007
, 10:45 PM
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 |