Re: Compare logical standby database with Advanced Replication

Hi,

You need not to setup advanced replication between the production database and the report one. Just create snapshots in the report database that reference tables in the production database. Snapshot logs on the production db are required if you want to use fast refreshes.

But there a lot of considerations before building a report database:

1- the size of the db
2- how frequently refreshing the report db
3- the production db load
4- the two dbs are on the same os

Dias

wangbin_at_start.com.au (wangbin) wrote in message news:<2d15bd69.0304142331.6bd7cbfd_at_posting.google.com>...
> Hi
>
> Oracle 9.2 RAC on redhat AS is used for our OLTP database. We need to
> find out a way to replicate data from OLTP database to report server
> for reporting. There are two solutions that we consider at the moment.
> One is logical standby database, and the other is Advanced
> Replication. The following is questions we have regarding this issue.
>
> 1. In logical standby database, are you able to create new objects,
> such as summary tables, and store data from resource other than the
> primary database?
> In the other word, part of the database is sync from primary database,
> like
> what happen in replication.
>
> 2. How to compare logical standby database with Advanced Replication,
> in terms of performance overhead to primary database, complexity of
> maintainance, and reliability?
>
> The following is the information I collect.
> Advanced Replication:
> Significant extra load on the production database for maintaining and
> propagating the replicated data. For example, the load on the
> production is high when you have to refresh the whole table after the
> report server is down for some reason.
>
> Logical standby database:
> Some extra load, such as redo needs primary key be included, on
> production database maintaining logical standby database
> functionality.
> New functionality to Oracle 9.2, which means we need to check its
> reliability.
> Data Guard Broker is not availible for RAC, which increase the
> difficulty for support.
>
> I try to assess and compare administrative/support burden for each
> option.
>
> Thanks,
> Bin
Received on Sun Apr 20 2003 - 05:35:09 CDT