RE: LogMiner Failed to extracts the existing records from the Archive logs

Can we keep religion off of this list ? I mean why would just a Hi or Hello not suffice ?  

Shreeni  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Junior DBA
Sent: Friday, November 23, 2007 11:03 PM To: oracle-l_at_freelists.org
Subject: LogMiner Failed to extracts the existing records 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 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. HYPERLINK
"http://us.rd.yahoo.com/evt=51731/*http:/mobile.yahoo.com/sports;_ylt=At9_qD KvtAbMuh1G1SQtBI7ntAcJ%0d%0a"Try it now.

No virus found in this incoming message. Checked by AVG Free Edition.
Version: 7.5.503 / Virus Database: 269.16.4/1147 - Release Date: 11/23/2007 9:19 AM  

No virus found in this outgoing message. Checked by AVG Free Edition.
Version: 7.5.503 / Virus Database: 269.16.7/1152 - Release Date: 11/26/2007 10:50 AM

No virus found in this outgoing message. Checked by AVG Free Edition.
Version: 7.5.503 / Virus Database: 269.16.7/1152 - Release Date: 11/26/2007 10:50 AM  

--
http://www.freelists.org/webpage/oracle-l