Methods for returning a corrupted database to a known, correct state by selectively using redo and undo operations
Both redo operations and undo operations are provided for returning a database that is corrupted to a correct state. When corruption of the database is detected, an automatic selection is made of one or more operations from the redo operations and undo operations for returning the database that is corrupted to a correct state. The selected one or more redo and undo operations are then performed on the database, thereby returning the database that is corrupted to a correct state.
1. A method of returning a database that is corrupted to a correct state, the database allowing for a plurality of transactions which operate upon the database, at least some of the transactions including a plurality of operations, the method comprising:
(a) providing both redo operations and undo operations for returning a database that is corrupted to a correct state;
(b) detecting corruption of the database;
(c) automatically selecting for each operation in a transaction that includes a plurality of operations at least one redo operation and at least one undo operation for returning the database that is corrupted to a correct state; and
(d) performing the selected at least one redo operation and at least one undo operation on the operations in the transaction, thereby returning the database that is corrupted to a correct state, wherein the at least one redo operation and at least one undo operation are performed on operations of the same transaction.
2. The method of claim 1 wherein the database is replicated from a source to a target database and the corruption of the database is detected at the target database.
3. The method of claim 2 wherein the selected one or more redo operations and undo operations are performed on transactions in the source database.
4. The method of claim 1 further comprising: (e) iteratively performing steps (b)-(d) using a redo operation if an undo operation was previously performed, and iteratively performing steps (b)-(d) using an undo operation if a redo operation was previously performed.
5. The method of claim 1 further comprising: (e) iteratively performing steps (b)-(d) using a plurality of redo and undo operations.
6. The method of claim 1 wherein the corruption of the database is caused by one or more of split transactions, distributed transactions, precommitted transactions, hung transactions, and misbehaving applications.
7. The method of claim 1 wherein one or more of steps (b), (c) and (d) are performed by user exits.
8. A tangible computer program product for returning a database that is corrupted to a correct state, the database allowing for a plurality of transactions which operate upon the database, at least some of the transactions including a plurality of operations, the computer program product comprising non-transitory computer-readable media encoded with instructions for execution by a processor to perform a method comprising:
(a) providing both redo operations and undo operations for returning a database that is corrupted to a correct state;
(b) detecting corruption of the database;
(c) automatically selecting for each operation in a transaction that includes a plurality of operations at least one redo operation and at least one undo operation for returning the database that is corrupted to a correct state; and
(d) performing the selected at least one redo operation and at least one undo operation on the operations in the transaction, thereby returning the database that is corrupted to a correct state, wherein the at least one redo operation and at least one undo operation are performed on operations of the same transaction.
9. The tangible computer program product of claim 8 wherein the database is replicated from a source to a target database and the corruption of the database is detected at the target database.
10. The tangible computer program product of claim 9 wherein the selected one or more redo operations and undo operations are performed on transactions in the source database.
11. The tangible computer program product of claim 8 wherein the instructions for execution by the processor perform a method further comprising: (e) iteratively performing steps (b)-(d) using a redo operation if an undo operation was previously performed, and iteratively performing steps (b)-(d) using an undo operation if a redo operation was previously performed.
12. The tangible computer program product of claim 8 wherein the instructions for execution by the processor perform a method further comprising: (e) iteratively performing steps (b)-(d) using a plurality of redo and undo operations.
13. The tangible computer program product of claim 8 wherein the corruption of the database is caused by one or more of split transactions, distributed transactions, precommitted transactions, hung transactions, and misbehaving applications.
14. The tangible computer program product of claim 8 wherein one or more of steps (b), (c) and (d) are performed by user exits.