Re: Experiences with Oracle Advanced Replication?

From: <L.B.Vanting_at_t-online.de>
Date: 21 Aug 1998 07:26:01 GMT
Message-ID: <6rj7e9$1ta$1@news00.btx.dtag.de>

Hi!

This should be no problem with Oracle. I assume you use updatable spanshots on your labtops and then it’s just a question of connecting the labtop to your
master (e.g. using dial-up network/RAS or plugging the labtop direct onto your network. I have don this from my private PC running NT4/804 via ISDN RAS connection. As soon as the connection was is established the transactions
were propagated from the updatable snapshots.

What is required on the updatable snapshot site in order to push the data back to
the master is a destination link using an Oracle built-in like following:

begin

   dbms_defer_sys.schedule_push
(

       destination  => 'YourMasterDBname',
       interval   => '/*30:Seconds*/ sysdate + 1/24/60/2',
       next_date  => sysdate,
       stop_on_error  => FALSE,
       delay_seconds  => 0,
       parallelism  => 2

);
end;

Here there are some tuning areas (delay_seconds + parallelism) which you can try out. With delay_seconds set to high value your data will be propagated almost synchronously and parallelism will parallelize the propagation, what only make sence with multi-CPU.

Regards

Lars Bo

Alan Johns wrote in message ...
>Being able to synchronise disparate databases is a pain I know. But
>there is a product which should be available in the last quarter of this
>year called SYNCPOINT, from Princeton Softech. This will perform a bi-
>directional synchronisation of data to achieve just what you are talking
>about. They have a web site you might want to look at -
>www.princetonsoftech.com
>
>Alan.
>In article <35D83629.E6205096_at_os.telia.no>, Roger Østvold
><roger.ostvold_at_os.telia.no> writes
>>Hi,
>>
>>I am about to set up a replication system, using Oracle 8.0.4,
>>Enterprise Edition on NT server, and Personal Oracle 8.0.4 on laptops.
>>
>>I have succeeded in replicating read-only data, and updateable data to
>>the laptop, but haven't managed to replicate updated data back from the
>>laptop to the server.
>>
>>I am using scriptcode to do all configuration.
>>
>>Do you have any ideas/comments?
>>
>>Thank's in advance
>>
>>Roger
>>
>
>--
>Alan Johns
Received on Fri Aug 21 1998 - 02:26:01 CDT