Re: Extract information from archived log files

Depending on the version LogMiner can't decode certain redo and redo
block dump would help. I remember we once figured a bug when Oracle
was going crazy doing branch block splits over and over again for the
same index change.

Another example is IOT - IIRC, LogMiner doesn't support IOT tables in
9i but not sure about 10g.

On 2/9/07, Tim Gorman <tim@xxxxxxxxx> wrote:

Antonio,

Why can't you use LogMiner?  Does it not display what you need to see?

The command ALTER SYSTEM DUMP LOGFILE '<logfile-name>' (which generates
a ".trc" file in USER_DUMP_DEST) may help you gain a little more
familiarity with the contents of redo log files.  The contents of the
".trc" text file is quite cryptic.  It won't directly show you the
structure, but it may fill in the pieces of some of the things stored
there for you.

Hopefully, you'll learn enough to convince you that you should use
LogMiner instead.  Life is too short to reverse-engineer that which is
readily available...

Hope this helps...

-Tim


Antonio Belloni wrote:
> I need to extract information from some archived log files but I can't use 
LogMiner.
>
> I wrote a small Java program and am trying to guess the record struct reading one 
archived file, but I can´t figure it out.
>
> Does any one knows where can I find archived log files struct definition ?
>
> I've searched ixora.au and other sites containing Oracle internals 
information, but I found nothing.
>
> Regards,
> Antonio Belloni
>
> __________________________________________________
> Fale com seus amigos  de graça com o novo Yahoo! Messenger
> http://br.messenger.yahoo.com/
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
--
http://www.freelists.org/webpage/oracle-l






--
Best regards,
Alex Gorbachev

The Pythian Group
Sr. Oracle DBA

http://www.pythian.com/blogs/author/alex/
http://blog.oracloid.com
--
http://www.freelists.org/webpage/oracle-l

Other related posts: