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: Alex Gorbachev <gorbyx_at_gmail.com>
Date: Fri, 9 Feb 2007 21:15:16 -0500
Message-ID: <c2213f680702091815g45644641v6026daabeead531d@mail.gmail.com>


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_at_evdbt.com> 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
Received on Fri Feb 09 2007 - 20:15:16 CST

Original text of this message

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