Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: LogMiner errors
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....
-- 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