Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Extract information from archived log files

Re: Extract information from archived log files

From: Tim Gorman <tim_at_evdbt.com>
Date: Fri, 09 Feb 2007 12:28:11 -0700
Message-ID: <45CCCB4B.4080303@evdbt.com>


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
Received on Fri Feb 09 2007 - 13:28:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US