MyLOG ready for test, an offline oracle log miner for 10g version.

From: AnySQL <anysql_at_gmail.com>
Date: 30 May 2007 07:01:15 -0700
Message-ID: <1180533674.975809.182860@o11g2000prd.googlegroups.com>

Hi all:

I am trying to write an offline oracle log miner, which can extract the redo sql from oracle online log files or archived log files, here it's cocming.

http://www.anysql.net/software/mylog.zip

The first step is to open an log file, for example:

LOG> open c:\redo03.log
DBID = 0x1ed409fb = 517212667

 GROUP      = 3, SEQUENCE   = 105
 File Type  = 2, Next Block = 4294967295
 Start SCN  = 0x0000.0012b545 = 1226053
 Start Time = 2007-05-30 07:21:11
 End SCN    = 0xffff.ffffffff = 281474976710655
 End Time   = 1988-01-01 00:00:00

The second is to run the extract command, I post an example on my personal site.

http://www.anysql.net/en/tools/offline_oracle_logminer.html

Taste it and have fun!

AnySQL from China

http://www.anysql.net/en/ Received on Wed May 30 2007 - 09:01:15 CDT