dbTalk Databases Forums  

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

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss LogMiner failed to extract records exist in the Database from thearchive logs in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Salman
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.