Re: alter system dump...

"John" <j_barbe_at_hotmail.com> wrote in message news:8bc78dd8.0105300553.33533f54_at_posting.google.com...
> I 've been advised to use this command to read redo log files.

I think that might be stretching the case. You were told (by Jonathan, IIRC) that this command would enable you to dump the contents of the redo logs, so that you might see whether anything was contained therein that you couldn't find from v$logmnr_contents. Slightly different from "being advised" to use it.

> But I don't really understand the dump file that is created.
>

That puts you in very good company. If we were intended to understand it, we wouldn't have needed Log Miner, would we?! For a start, redo contains 'change vectors' -a hexadecimal representation of the changes applied to objects. Provided you are fluent in hexadecimal, you'll have no problem interpreting the dump. For the mortals amongst us, the Log Miner dictionary file provides a mapping between hexadecimal and plain ol' English object names.

> I'm currently searching in the archives to have info about this file
> but as I don't manage to get what I'm looking for.
> I'm asking directly.
>
> Can someone explain me how to understand this file?
> What are the different field?
>
> Is there a documentation or a book about it?
>

I doubt it. Why not re-phrase your post to say it as it really is. "I want to track DML on partitioned tables and Log Miner doesn't do that very well, so I'm looking for a better method".

To which my answer would be "I doubt there is one, it's an inherent limitation in Log Miner, no-one seems to know of a better third-party product, so you'll have to learn to live with it".

I don't mean to be harsh, but this one has been out there long enough for us to be fairly sure that there isn't a swarm of DBAs out there finding an awful lot more in the log files than we poor fools using Log Miner are able to discover.

Regards
HJR
> Thanks
>
> John
Received on Thu May 31 2001 - 04:19:27 CDT