Re: Archive Logs

I've used logminer. The package is fairly easy to use but requires running a few packages to set things up. First, a data dictionary snapshot needs to be generated (to map object ids to names). You then run another package to gather up the log data you'd like to analyze (redos, archived or both). Finally, you run an extraction package which generates v$logmnr_contents. Columns include time stamp, user name, sql redo and sql undo. I think the documentation is pretty complete and straightforward, but if you have any questions, e-mail me.

Sybrand Bakker wrote in message
<970594720.27688.0.pluto.d4ee154e_at_news.demon.nl>...
>In 8.0.5 there should be the logminer package.
>I have never used it, so I can't provide further details.
>
>Regards,
>
>Sybrand Bakker, Oracle DBA
>
>"Roman Gelfand" <rgelfand_at_masmid.com> wrote in message
>news:8rd0e0$4jr$1_at_bob.news.rcn.net...
>> 7.3.4 or 8.0.5
>>
>> Is there a program or a script which would parse an archive log file and
 and
>> produce a formatted report?
>>
>> Thanks in advance,
>>
>> Roman
>>
>>
>>
>>
>
>
Received on Tue Oct 03 2000 - 13:51:34 CDT