Re: Oracle Streams or Logical Dataguard

On Sep 7, 2:40 pm, shiva <sshivay..._at_gmail.com> wrote:
> Hello,
>
> I'm debating about using either Logical dataguard or one way streams
> replication for a database which needs heavy reporting. DB size is
> about 100GB and does about 100K transactions everyday (Not many
> updates, mainly inserts/deletes and selects). I have set up dataguard
> and streams in the past and learning curve is not a problem.
>
> Which one would you pick between two and why?
>
> Thanks

It depends upon the health of your network connection. I've used Streams to feed reporting databases without issue, and it works quite well. I've not use Logical Standby, so I can't comment. Remember, too,. that Streams puts the logmining on the source where Logical Standby moves that process to the destination. Then, with Streams, no archivelogs are written to a remote location. It may be a toss-up between the 'cost' of the two. Personally I prefer Streams as you're likely replicating one schema.

David Fitzjarrell Received on Fri Sep 07 2007 - 15:19:32 CDT