Re: MyLOG ready for test, an offline oracle log miner for 10g version.
- From: sybrandb <sybrandb@xxxxxxxxx>
- Date: 30 May 2007 07:06:28 -0700
On May 30, 4:01 pm, AnySQL <any...@xxxxxxxxx> wrote:
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/
Reverse engineering is explicitly forbidden by your license.
Should I report you to Oracle?
I'm quite confident they will sue you, and will end your operations,
and rightly so!!!
--
Sybrand Bakker
Senior Oracle DBA
.
- Follow-Ups:
- References:
- Prev by Date: MyLOG ready for test, an offline oracle log miner for 10g version.
- Next by Date: Re: Retrieve remote host from a Stored procedure
- Previous by thread: MyLOG ready for test, an offline oracle log miner for 10g version.
- Next by thread: Re: MyLOG ready for test, an offline oracle log miner for 10g version.
- Index(es):
Relevant Pages
|
