Re: Replication between two Oracles

Steve

You have a number of options that you can choose from, but there's not enough information in your posting to determine which are not valid for you. So let me give you the list of possible options as a starting point:

1. Leave the tables in one database and reference them from the other via DB links. Downside here is that if the database with the tables is unreachable for any reason, the database referencing the tables via the links won't get to them either.
2. Regular scheduled export, ftp, import. Data is not in synch until the import, and you have to write and maintain the scripts to do this.
3. Master - read only snapshot configuration. Data is only updatable on one site, so this may require some fancy coding to make transparent if users on the read-only site want to update the data on the master site.
4. Master - updatable snapshot. Gets around the limitation of 3, but you need to investigate conflict resolution methods.
5. Master - master replication. Same comment as 4.

As for costing, that's something I don't keep track of (it's all free to me!), so contact your sales rep about that.

HTH. Pete

Steven Crimmins wrote:

> Hi,
> I have the following scenario and would appreciate any suggestions.
> (I would also ask that you email responses to me.)
>
> We have an Oracle 8 running on NT Server and a separate Oracle 8
> running on Solaris for x86. There will be a T1 link between the two
> Oracle's with TCP/IP.
>
> There is a series of tables on the Oracle 8 Solaris that need to be
> replicated (or perhaps the data will be shared in a different fashion)
> to the Oracle NT.
>
> The rate of transactions is low. One or two tables may have less than
> 10 transactions per minute. The remaining two or three tables usually
> only have perhaps 100 updates that occurs in the evening.
> (There are only about 5 tables total to "share".)
>
> What are my best options to keep the data in synch? I do not need
> instantaneous updating to occur, however I would like Oracle to handle
> the Oracle to Oracle communications if possible (hence I would not
> change the underlying applications).
>
> If any suggestions are priced products (which is acceptable) please
> let me know the relative price of the components and where they need
> to be installed.
>
> Thanks
> Steve

Received on Mon Sep 27 1999 - 11:26:58 CDT