Re: View contents of archive log files?

Is there any way to selectively restore changes- for example, to a specific table during a certain time?

For example, I work on Unisys DMSII. We have a tool (Unisys provided but undocumented) that allows us to search a particular audit file for changes to a particular data set (like Oracle tables) and extract those. The extract includes time, before/after image, whether it was an add/change/delete, mix (task) #, etc.

Is this kind of thing possible with Oracle?

On Fri, 17 Mar 2000 19:32:49 +0100, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

>Oracle 8 comes with logminer, which is a tool to view the archive log. For
>Oracle 7 only third party tools exist, but that's going out of support soon
>anyway.
>
>Hth,
>
>Sybrand Bakker, Oracle DBA
>
>B. Dana <bgdana_at_hotmail.com> wrote in message
>news:38D2732F.B65AD5E4_at_hotmail.com...
>> Is there a tool to view the contents of the archive log files? Doing a
>> strings on the file only gives me a hint at what data is in it. I would
>> like to see what would be replayed when a recover database is performed.
>> If there is no tool, how can I determine the format of the file?
>>
>
>

Jay M. Scheiner
Programmer/Analyst
Wolpoff & Abramson, LLP
remove _nospm_ from email address
Opinions are my own only!
To email, remove _nospm_ from address. Received on Sat Mar 18 2000 - 00:00:00 CST