Logical equivalent replication with snapshot based fallback of database systems

A system comprising:

• a processor;
• and
• a non-transitory computer readable media having computer executable instructions stored therein, which, when executed by the processor, causes the system to perform operations comprising:
• registering a first database system comprising a first processor and a first memory with a separate and distinct second database system comprising a second processor and a second memory, the first database system comprises multiple snapshots;
• and
• performing a failback operation to restore a state of the first database system comprising:
• identifying a most recent snapshot in persistence storage of the second database system that is also present in persistent storage on the first database system, the most recent snapshot being identified as an active snapshot;
• opening the snapshot comprising data known to have existed on the first database system and the second database system at a first time;
• requesting transaction log information from the second database system, the transaction log information being a delta log corresponding to transactions performed on the second database system beginning with the first time;
• and
• applying the transaction log information to the snapshot data on the first database system;
• wherein:
• older snapshots are deleted after the opened snapshot is identified as an active snapshot;
• after applying the transaction log information to the snapshot data on the first database system, the data on the first database system is logically equivalent and physically different to data on the second database system.

Anon-transitory computer program product storing instructions which, when executed by at least one processor, result in operations comprising:

• registering a first database system comprising a first processor and a first memory with a separate and distinct second database system comprising a second processor and a second memory, the first database system comprises multiple snapshots;
• and
• performing a failback operation to restore a state of the first database system comprising:
• identifying a most recent snapshot in persistence storage of the second database system that is also present in persistent storage on the first database system, the most recent snapshot being identified as an active snapshot;
• opening the snapshot comprising data known to have existed on the first database system and the second database system at a first time;
• requesting transaction log information from the second database system, the transaction log information being a delta log corresponding to transactions performed on the second database system beginning with the first time;
• and
• applying the transaction log information to the snapshot data on the first database system;
• wherein:
• older snapshots are deleted after the opened snapshot is identified as an active snapshot;
• after applying the transaction log information to the snapshot data on the first database system, the data on the first database system is logically equivalent and physically different to data on the second database system.