System and method for reconciling transactions between a replication system and a recovered database
First Claim
Patent Images
1. A system for performing replication between a source device and a target device, the system comprising:
- a source database having first data files and log files storing replication transactions corresponding to changes made to the first data files;
a recovered target database having second data files comprising data associated with at least one replication transaction stored in the log files; and
a replication device capable of replicating at least a portion of the first data files to the recovered target database by posting to the recovered target database the changes made to the first data files, the replication device comprising;
at least one poster queue configured to store information indicative of the replication transactions, anda reconcile process configured to purge at least one replication transaction from the at least one poster queue when the at least one replication transaction has already been applied to the recovered target database.
24 Assignments
0 Petitions
Accused Products
Abstract
The invention is a reconcile system for providing data replication between a source system and a target system. The reconcile system includes a reconcile process that determines a recovery position for a failed or otherwise desynchronized target system, and purges queues of the reconcile system of stale transactions occurring before the recovery position, thereby ensuring synchronization between the source and target systems.
-
Citations
20 Claims
-
1. A system for performing replication between a source device and a target device, the system comprising:
-
a source database having first data files and log files storing replication transactions corresponding to changes made to the first data files; a recovered target database having second data files comprising data associated with at least one replication transaction stored in the log files; and a replication device capable of replicating at least a portion of the first data files to the recovered target database by posting to the recovered target database the changes made to the first data files, the replication device comprising; at least one poster queue configured to store information indicative of the replication transactions, and a reconcile process configured to purge at least one replication transaction from the at least one poster queue when the at least one replication transaction has already been applied to the recovered target database. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A method of recovering or instantiating a target database during replication from a source database to the target database, the method comprising:
-
logging replication transactions in a replication system, wherein the replication transactions are associated with changes made to a source database; applying the replication transactions to a target database to maintain in the target database a copy of the source database; recovering the target database by rolling back information applied to the target database such that the recovered target database contains a copy of certain changes represented by the replication transactions contained in the replication system; and purging the replication transactions from the replication system that represent the certain changes already applied to the recovered target database. - View Dependent Claims (12, 13, 14, 15, 16)
-
-
17. A replication system for reconciling information stored in a replication device with a recovered database, the replication system comprising:
-
first means for storing data files and log files, wherein the log files store replication transactions corresponding to changes made to the data files; second means for storing a rolled back copy of the data files after recovery of the second means, wherein the rolled back copy of the data files comprises data associated with at least one replication transaction stored in the log files; and means for replicating at least a portion of the data files to the second means by posting to the second means the changes made to the data files, the means for replicating comprising; means for storing information indicative of the replication transactions, and means for purging at least one replication transaction from the means for storing information when the at least one replication transaction has already been applied to the second means. - View Dependent Claims (18, 19, 20)
-
Specification