Re: LogMiner Failed to extracts the existing records from the Archive logs
- From: Junior DBA <juniordba2004@xxxxxxxxx>
- To: Maureen English <sxmte@xxxxxxxxxxxxxxxx>
- Date: Mon, 26 Nov 2007 20:30:21 -0800 (PST)
BismillahirRehmanirRahim
Dear Maureen,
The minimum supplemental logging is already enabled.
The problem is that we have some records in the Database.
but logminger didnt fetch these records from the archived logs for any
operation [insert,update or delete]
Logminer is fetching other records on some other dates, using same options &
Select Query for both cases.
I am trying to figure out why logminer failed to fetch those records.
what might be the possible scenarios . the column i am mining using
mine_value is simply varchar2 and we are getting records on other dates.
hope to hear soon from you.
Your DBA Colleague.
Muhammad Salman Faheem
Maureen English <sxmte@xxxxxxxxxxxxxxxx> wrote:
This may not be relevant, but we had a problem with LogMiner for 9i.
The problem was that information about chained rows was lost. I don't
know all of the details since I was not working on the problem, but we
got this from Oracle Support:
Following are not supported in log miner utility.
1. Simple and nested abstract datatypes (ADTs)
2. Collections (nested tables and VARRAYs)
3. Object Refs
4. Index organized tables (IOTs)
5. CREATE TABLE AS SELECT of a table with a clustered key
If insert,updates involve any of the above scenario, it will report as
"Unsupported" for OPERATION.
Also, Chained rows are not supported in logminer unless minimal level
of supplemental logging is on. To enable
this, issue
SQL> alter database add supplemental log data;
Once this command succeeds, the subsequent archived/redo logs can be
mined by logminer even if they
contain chained rows.
- Maureen
Junior DBA wrote:
>
>
> 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.
> > >
---------------------------------
Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try it now.
Other related posts:
