Re: How about tailredo?

AnySQL (d.c.b.a) wrote:
> I have thinking what Oracle doing for a long time, since Oracle
> records all changes to the online redo logs, could we write a software
> just like "tail -f filenmae" command in Unix/Linux to view what are
> wroten to online log file in a realtime manner. After got this idea, I
> began to write an software called "tailredo". About one year ago, I had
> spent some time on online log format research, and wrote a too to dump
> each piece of redo log. Based on this utility, I made a first step
> quickly, following is an example of the "tailredo" output.
>
> tailredo bo=big file=oracle_v8_log.log b1=20000 b2=20005
> Sequence=34238, blocks=409600, dbid=938022666=0x37e9170a, grp#=1
>
> 0x000085be.00004e20.00fc 2006-05-03 15:30:10
> [04.01] [Trans Block] Block Cleanout
>
> 0x000085be.00004e20.0138 2006-05-03 15:30:10
> [05.01] [Trans Undo ] Undo block or under segment header -
> KTURDB
> [10.04] [Index ] Mark leaf row deleted
>
> 0x000085be.00004e21.00d8 2006-05-03 15:30:10
> [04.01] [Trans Block] Block Cleanout
>
> 0x000085be.00004e21.0114 2006-05-03 15:30:10
> [05.01] [Trans Undo ] Undo block or under segment header -
> KTURDB
> [10.04] [Index ] Mark leaf row deleted
>
> 0x000085be.00004e22.00b4 2006-05-03 15:30:10
> [04.01] [Trans Block] Block Cleanout
>
> 0x000085be.00004e22.00f0 2006-05-03 15:30:10
> [05.01] [Trans Undo ] Undo block or under segment header -
> KTURDB
> [10.04] [Index ] Mark leaf row deleted
>
> 0x000085be.00004e23.0090 2006-05-03 15:30:10
> [04.01] [Trans Block] Block Cleanout
>
> 0x000085be.00004e23.00cc 2006-05-03 15:30:10
> [05.01] [Trans Undo ] Undo block or under segment header -
> KTURDB
> [10.04] [Index ] Mark leaf row deleted
>
> 0x000085be.00004e24.007c 2006-05-03 15:30:10
> [04.01] [Trans Block] Block Cleanout
>
> 0x000085be.00004e24.00b8 2006-05-03 15:30:10
> [05.01] [Trans Undo ] Undo block or under segment header -
> KTURDB
> [10.04] [Index ] Mark leaf row deleted
>
> 0x000085be.00004e25.0058 2006-05-03 15:30:10
> [04.01] [Trans Block] Block Cleanout
>
> 0x000085be.00004e25.0094 2006-05-03 15:30:10
> [05.01] [Trans Undo ] Undo block or under segment header -
> KTURDB
> [10.04] [Index ] Mark leaf row deleted
>
> It could take me about half year time to make this utility
> meaningful, if someone want to take a test of this utility, send mail
> to me. This utility currently does not support 10g log file, because
> there is some big change in log format since 10g version.
>
> AnySQL.net
> =============================
> http://www.anysql.net/en

Provided this "reverse engineering" is not a violation of the Oracle license I'd be happy to look it over in my lab.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org