LogMiner Failed to extracts the existing records from the Archive logs

From: Junior DBA <juniordba2004_at_yahoo.com>
Date: Fri, 23 Nov 2007 21:03:18 -0800 (PST)
Message-ID: <135629.36220.qm@web45102.mail.sp1.yahoo.com>

   

  BismillahirRehmanirRahim

      Hi All,    

  I am using logminer of Oracle 10g for audit purpose to get the insert,update or delete statement on a table based on 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 the specified dates while its fetching records for other dates.    

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

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

  the select Query is as follow:    

  Select * from v$logmnr_contents
  where seg_owner='x' and table_name='y'   and dbms_logmnr.mine_value(redo_value,'x.y.z')='s'   ;    

  where z=column_name &
  s=column value as stored in the Database        

  These records are also exists on our Standby Database, but logminer failed to fetch these records from archive logs.    

  Appreciate your valuable inputs.    

  Your DBA
Muhammad Salman Faheem            

---

Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try it now.

--

http://www.freelists.org/webpage/oracle-l Received on Fri Nov 23 2007 - 23:03:18 CST