Eric Ian Fish - Kentfield CA, US Scott Roger Corbin - Spooner WI, US Joel Shepherd - Golden CO, US George Allen Pearson - Pleasant Hill CA, US Timothy Lee Rathbun - Danville CA, US
Assignee:
Oracle International Corporation - Redwood Shores CA
International Classification:
G06F 12/00
US Classification:
707624
Abstract:
A computer readable medium includes executable instruction to compare databases. The executable instructions are configured to identify when a segment of a first database is conditionally out of synchronization with a corresponding segment of a second database to establish a conditionally out of synchronization state at a first time. Executable instructions allow a latency period after the first time in which changes are made to the first database and the second database. Executable instructions also determine after the latency period whether the segment of the first database is in synchronization with the corresponding segment of the second database. Executable instructions also populate a resynchronization table, which is used by a replication mechanism to bring asynchronous rows into synchronization.
Apparatus And Method For Log Based Replication Of Distributed Transactions Using Globally Acknowledged Commits
Scott Roger Corbin - Spooner WI, US Joel Shepherd - Golden CO, US Alok Pareek - Brisbane CA, US Chris McAllister - San Mateo CA, US
Assignee:
Oracle International Corporation - Redwood Shores CA
International Classification:
G06F 7/00
US Classification:
707615, 707635, 707674, 707702
Abstract:
A computer readable storage medium includes executable instructions to read source node transaction logs to capture transaction data, including local transaction data, global transaction identifiers and participating node data. The global transaction identifiers and participating node data are stored in target node queues. The target node queues are accessed to form global transaction data. Target tables are constructed based upon the local transaction data and the global transaction data.