Oracle Replication [message #75295] |
Tue, 03 December 2002 08:00 |
Cristovão Bento
Messages: 8 Registered: September 2002
|
Junior Member |
|
|
Hi there i have several questions that i would like to find an answer to.
The scenario that have is: Two Master Sites (MS1 and MS2). All the tables are within a Master Group called MG. There is also Link's Between the 2 Master sites connecting them and enabling an Asynchronous Replication. I have one application that performs Mass Inserts into the MS1, these operations are replicated to the MS2.
First i would like to know what are the physical limits for the Oracle Replication Queues?. I mean if the MS2 cant be reached how long would MS1 keep the information to be replicated? and would it be sent when MS2 cames up?
What about SQL instructions like "RENAME, DROP, CREATE, TABLE..." how can i replicate these?
Also i would like to know if oracle has any kind of funcionality that permits us to compare two databases. For example, if i had an error while replicating instructions to the MS2. I could do an Audit to MS1 and MS2 and check the diferences and make the corrections. Is this possible?
Thanks in advance
Cristóvão Bento
|
|
|
|