Re: Extracting Redo Log Info/LogMiner/Shareplex

The product you mention is called Logical Standby - concept is to use "LogMiner Technology" to convert a redo log into SQL statements that can then be applied to a "backup" database.

Concept sounds interesting, but unfortunately the product is currently vapour ware. It was ammounced as part of 9i, but is not (yet?)

Eric wrote in message <497b38b.0109280759.56bd59de_at_posting.google.com>...
>
>My recollection of Data Guard 9i is that there are a number of options
>as you point out. One of the options that I seem to recall, however,
>was that SQL statements were being reassembled and executed to the
>backup database. Part of the reason for this was to facilitate
>different disk/datafile configurations on primary and backup,
>different db versions, etc. Applying redo information (using the
>other methods) relies on the datafile config matching up exactly, I
>think -- the physical layout of the data must be the same on primary
>and backup in that case. I believe there are other reasons for using
>statement reassembly as well. That being the case, ROWIDs would be
>different between primary and backup, and without a primary key I'm
>not sure how updates could happen. Anyway, if you know where I can
>dig up more detailed documentation on this, I would love to know, I
>haven't had much luck.
>
Received on Fri Nov 02 2001 - 22:43:58 CST