Oracle-L: RE: LogMiner errors

From: Nguyen, David M <david.m.nguyen_at_xo.com>
Date: Wed, 03 Jul 2002 08:28:24 -0800
Message-ID: <F001.0048F00B.20020703082824@fatcity.com>

I got the errors fixed. The reason the errors were generated because it could not find time interval between July 1 and July 2. I was able read redo log with LogMiner but now I come with another question why report display output in HEX data and why it only shows username is "SYS" only? I want to look at some transactions which were made by "DBIMPL" user that is not there.

**Redo log report:

USERNAME LOG_ID TIMESTAMP SQL_REDO

---------- ---------- ------------ -------------------------
                                   CAAACtAAAT';

SYS             24036 02-JUL-02    insert into UNKNOWN.Objn:
                                   12(Col[1],Col[2],Col[3])
                                   values (HEXTORAW('c108'),
                                   HEXTORAW('c23b20'),HEXTOR
                                   AW('c106'));

SYS             24036 02-JUL-02    delete from UNKNOWN.Objn:
                                   13 where Col[1] = HEXTORA
                                   W('c20c42') and Col[2] =

===============================================================

In addition, my database is running in NOARCHIVE mode does it mean I can not go back to check what happened yesterday or couple days ago?

Is there a really good book about LogMiner that I can purchase or a website?

Thanks,
David

-----Original Message-----
Sent: Wednesday, July 03, 2002 6:13 AM
To: Multiple recipients of list ORACLE-L

I believe also that you can't actually run LogMiner against an 8.0 database but have to generate the dictionary file (which you can do) and then run the mining procedure with the dictionary file against an 8.1.x database....

John.Hallas_at_vodafone.co.uk wrote:
> David,
>
> I recall that there is a limit (42 characters?) on the name of the
> dictionary file.
> 2 ways round it. Create the file in the top level ie /export/dict.ora
> or
> create a symbolic link with a shorter name.
> I have a page on my web site which mentions this problem
> (www.hcresources.co.uk).
> Unfortunately I do not (yet) have internet access at my new site and
> cannot
> recall what exactly is on the page (I do recall it is not yet
> finished!!!!)
>
> HTH
>
> John
>
> -----Original Message-----
> Sent: 02 July 2002 19:19
> To: Multiple recipients of list ORACLE-L
>
>
> I tried to run LogMiner to view transactions on Oracle8.0 using
> LogMiner and
> received following errors. Can someone please help me to fix errors.
> This
> is HIGH priority that I am working to try to find out who messed up
> our
> database per my Manager.
>
> SQL> begin
> 2 sys.dbms_logmnr.start_logmnr(
> 3 DictFileName => '/export/home/oracle/LogMiner/dictionary.ora',
> 4 StartTime => to_date('01-Jul-2002 08:00:00AM','DD-MON-YYYY
> HH:MI:SSAM'),
> 5 EndTime => to_date('02-Jul-2002 12:00:00AM','DD-MON-YYYY
> HH:MI:SSAM'));
> 6 end;
> 7 /
> begin
> *
> ERROR at line 1:
> ORA-01280: Fatal LogMiner Error.
> ORA-06512: at "SYS.DBMS_LOGMNR", line 42
> ORA-06512: at line 2
>
>
> Thanks,
> David
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nguyen, David M
> INET: david.m.nguyen_at_xo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: John.Hallas_at_vodafone.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nguyen, David M
  INET: david.m.nguyen_at_xo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Jul 03 2002 - 11:28:24 CDT