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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Junior DBA
Sent: Friday, November 23, 2007 11:03 PM
To: oracle-l@xxxxxxxxxxxxx
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

Other related posts: