Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Tools - Snapshot synchronization and monitor

Re: Tools - Snapshot synchronization and monitor

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 28 Jan 2004 19:21:12 +0100
Message-ID: <nbvf101116tb0jn13ijsl2mhvart0hvq5c@4ax.com>


On Wed, 28 Jan 2004 19:00:37 +0200, "news.bezeqint.net" <rtr> wrote:

>Hi
>
>We are looking for software that will help us to mange and monitor
>the snapshot synchronization process between deferent sites ( Slave/Master)
>We Need a GUI tool to monitor all the steps of the refreshing the slaves.
>
>Some short descreption of the process :
>snapshot in Oracle is kind of a replica of a target master table(or several
>tables) from a single point in time.
>Whereas in multimaster replication tables are continuously being updated by
>other master
>sites, snapshots are updated from one or more master tables through
>individual batch updates,
>known as a refreshes, from a single master site.
>When a snapshot is refreshed, Oracle must examine all of the changes to the
>master
>table to see if any apply to the snapshot. Therefore, if any changes where
>made to
>the master table since the last refresh, a snapshot refresh will take some
>time, even if
>the refresh does not apply any changes to the snapshot. If, however, no
>changes at
>all were made to the master table since the last refresh of a snapshot, the
>snapshot
>refresh should be very quick.
>
>Thanks
> Eli Segal
>

Anything wrong with Oracle Replication Manager (comes with Oracle Enterprise Manager)

--
Sybrand Bakker, Senior Oracle DBA
Received on Wed Jan 28 2004 - 12:21:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US