RE: Extract information from archived log files
- From: "Kerber, Andrew" <Andrew.Kerber@xxxxxxx>
- To: tim@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 9 Feb 2007 13:38:21 -0600
I am sure the log formats are both unpublished and proprietary. Probably very
hard to find.
Andrew W. Kerber
Oracle DBA
UMB
816-860-3921
andrew.kerber@xxxxxxx
"If at first you dont succeed, dont take up skydiving"
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Tim Gorman
Sent: Friday, February 09, 2007 1:28 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Extract information from archived log files
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/
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
>
--
//www.freelists.org/webpage/oracle-l
------------------------------------------------------------------------------
NOTICE: This electronic mail message and any attached files are confidential.
The information is exclusively for the use of the individual or entity intended
as the recipient. If you are not the intended recipient, any use, copying,
printing, reviewing, retention, disclosure, distribution or forwarding of the
message or any attached file is not authorized and is strictly prohibited. If
you have received this electronic mail message in error, please advise the
sender by reply electronic mail immediately and permanently delete the original
transmission, any attachments and any copies of this message from your computer
system. Thank you.
==============================================================================
--
//www.freelists.org/webpage/oracle-l
Other related posts:
