I really don't get it: Asynchronous replication every 2 seconds 
Author Message
 I really don't get it: Asynchronous replication every 2 seconds

I'm trying to configure (using oracle replication manager) 2 databases
to replicate every 2 seconds.
It replicates twice a minute, and not 30 times a minute ?
even I have said: interval 2 seconds.

Can someone explain me step by step how to configure asynchronous
replication or give me some tips, etc.

Another question, if you modify something in the configuration, how
fast will the modifications be modified by the Oracle server.
Immediatelly, or do you have to wait a minute, 10 minutes, ... Can you
test immediatelly or do you have to wait for a while.

thank you in advance,
Sander



Wed, 18 Jun 1902 08:00:00 GMT
 I really don't get it: Asynchronous replication every 2 seconds

You're really asking too much.
If you would set the interval to 2 seconds, the only thing your server would
do is replicate. Once a minute is already placing a burden on the system.
For what purpose do you replicate?
If you do this to maintain a live backup copyh, you should use the hot
standby option.

Hth,

Sybrand Bakker, Oracle DBA


Quote:
> I'm trying to configure (using oracle replication manager) 2 databases
> to replicate every 2 seconds.
> It replicates twice a minute, and not 30 times a minute ?
> even I have said: interval 2 seconds.

> Can someone explain me step by step how to configure asynchronous
> replication or give me some tips, etc.

> Another question, if you modify something in the configuration, how
> fast will the modifications be modified by the Oracle server.
> Immediatelly, or do you have to wait a minute, 10 minutes, ... Can you
> test immediatelly or do you have to wait for a while.

> thank you in advance,
> Sander



Wed, 18 Jun 1902 08:00:00 GMT
 I really don't get it: Asynchronous replication every 2 seconds
Hi Sybrand,

The problem is that I did not design it, I only have to implement it.
It has to be asynchronous. No synchrone, no standby.

I have been wondering if it is possible to have asynchronous
replication every 2 a 3 seconds, because Oracle polls only once a
minute.

thanks,
Sander

Quote:
>You're really asking too much.
>If you would set the interval to 2 seconds, the only thing your server would
>do is replicate. Once a minute is already placing a burden on the system.
>For what purpose do you replicate?
>If you do this to maintain a live backup copyh, you should use the hot
>standby option.
>> I'm trying to configure (using oracle replication manager) 2 databases
>> to replicate every 2 seconds.
>> It replicates twice a minute, and not 30 times a minute ?
>> even I have said: interval 2 seconds.
>> Can someone explain me step by step how to configure asynchronous
>> replication or give me some tips, etc.
>> Another question, if you modify something in the configuration, how
>> fast will the modifications be modified by the Oracle server.
>> Immediatelly, or do you have to wait a minute, 10 minutes, ... Can you
>> test immediatelly or do you have to wait for a while.



Wed, 18 Jun 1902 08:00:00 GMT
 I really don't get it: Asynchronous replication every 2 seconds
Yes, you can do it.  In test environments I've done it every 10 seconds
(10/86400).  You're burning up a lot of cpu and io for this - seems like
there are better ways.  What are you trying to accomplish?
Jim


Quote:
> Hi Sybrand,

> The problem is that I did not design it, I only have to implement it.
> It has to be asynchronous. No synchrone, no standby.

> I have been wondering if it is possible to have asynchronous
> replication every 2 a 3 seconds, because Oracle polls only once a
> minute.

> thanks,
> Sander

> >You're really asking too much.
> >If you would set the interval to 2 seconds, the only thing your server
would
> >do is replicate. Once a minute is already placing a burden on the system.
> >For what purpose do you replicate?
> >If you do this to maintain a live backup copyh, you should use the hot
> >standby option.

> >> I'm trying to configure (using oracle replication manager) 2 databases
> >> to replicate every 2 seconds.
> >> It replicates twice a minute, and not 30 times a minute ?
> >> even I have said: interval 2 seconds.

> >> Can someone explain me step by step how to configure asynchronous
> >> replication or give me some tips, etc.

> >> Another question, if you modify something in the configuration, how
> >> fast will the modifications be modified by the Oracle server.
> >> Immediatelly, or do you have to wait a minute, 10 minutes, ... Can you
> >> test immediatelly or do you have to wait for a while.



Wed, 18 Jun 1902 08:00:00 GMT
 I really don't get it: Asynchronous replication every 2 seconds
I have to synchronise 2 databases (on 2 servers). If someone modifies
a record it should as soon as possible modified on the second server.
First I used synchronous master-replication, but the problem with that
is if server2 is down, server1 will not modify the record. The same
vice versa, if I modify something on server 2 it should be propagated
as soon possible to server 1.

So I thought I will use asynchronous, 2 a 3 seconds, almost the same
as synchronous.

thanks,
Sander

Quote:
>Yes, you can do it.  In test environments I've done it every 10 seconds
>(10/86400).  You're burning up a lot of cpu and io for this - seems like
>there are better ways.  What are you trying to accomplish?
>> The problem is that I did not design it, I only have to implement it.
>> It has to be asynchronous. No synchrone, no standby.

>> I have been wondering if it is possible to have asynchronous
>> replication every 2 a 3 seconds, because Oracle polls only once a
>> minute.
>> >You're really asking too much.
>> >If you would set the interval to 2 seconds, the only thing your server
>would
>> >do is replicate. Once a minute is already placing a burden on the system.
>> >For what purpose do you replicate?
>> >If you do this to maintain a live backup copyh, you should use the hot
>> >standby option.
>> >> I'm trying to configure (using oracle replication manager) 2 databases
>> >> to replicate every 2 seconds.
>> >> It replicates twice a minute, and not 30 times a minute ?
>> >> even I have said: interval 2 seconds.
>> >> Can someone explain me step by step how to configure asynchronous
>> >> replication or give me some tips, etc.
>> >> Another question, if you modify something in the configuration, how
>> >> fast will the modifications be modified by the Oracle server.
>> >> Immediatelly, or do you have to wait a minute, 10 minutes, ... Can you
>> >> test immediatelly or do you have to wait for a while.



Wed, 18 Jun 1902 08:00:00 GMT
 I really don't get it: Asynchronous replication every 2 seconds
Make sure that your job_queue_interval is set to 1 for both database



Quote:
> I have to synchronise 2 databases (on 2 servers). If someone modifies
> a record it should as soon as possible modified on the second server.
> First I used synchronous master-replication, but the problem with that
> is if server2 is down, server1 will not modify the record. The same
> vice versa, if I modify something on server 2 it should be propagated
> as soon possible to server 1.

> So I thought I will use asynchronous, 2 a 3 seconds, almost the same
> as synchronous.

> thanks,
> Sander

> >Yes, you can do it.  In test environments I've done it every 10
seconds
> >(10/86400).  You're burning up a lot of cpu and io for this - seems
like
> >there are better ways.  What are you trying to accomplish?

> >> The problem is that I did not design it, I only have to implement
it.
> >> It has to be asynchronous. No synchrone, no standby.

> >> I have been wondering if it is possible to have asynchronous
> >> replication every 2 a 3 seconds, because Oracle polls only once a
> >> minute.

> >> >You're really asking too much.
> >> >If you would set the interval to 2 seconds, the only thing your
server
> >would
> >> >do is replicate. Once a minute is already placing a burden on the
system.
> >> >For what purpose do you replicate?
> >> >If you do this to maintain a live backup copyh, you should use
the hot
> >> >standby option.

> >> >> I'm trying to configure (using oracle replication manager) 2
databases
> >> >> to replicate every 2 seconds.
> >> >> It replicates twice a minute, and not 30 times a minute ?
> >> >> even I have said: interval 2 seconds.

> >> >> Can someone explain me step by step how to configure
asynchronous
> >> >> replication or give me some tips, etc.

> >> >> Another question, if you modify something in the configuration,
how
> >> >> fast will the modifications be modified by the Oracle server.
> >> >> Immediatelly, or do you have to wait a minute, 10 minutes, ...
Can you
> >> >> test immediatelly or do you have to wait for a while.

--
                 Alex Shterenberg

Sent via Deja.com http://www.deja.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 6 post ] 

 Relevant Pages 

1. One out of every two .Requery don't work on my small LAN

2. Server Properties don't see second processor.

3. Replication Job ID's don't match

4. i'm getting really bored with this multilanguage problem

5. HELP: Getting parent table values who don't have corresponding child values

6. Getting Error 13, help - don't understand why

7. triggers don't get exported, dba jobs don't run

8. Don't understand Fullpath() - not getting results I expect

9. Don't duplicate v Don't resend trade-off theory

10. 3D GETs don't align

11. Merge Replication-What's it really doing?

12. Getting error while 'Synchronsing replication'


 
Powered by phpBB® Forum Software