Parallel transaction recovery
AssigneeOracle International Corporation
InventorsAmit Ganesh, Gary C. Ngai
Life of this patent
Estimating the term…
Abstract
A method and system for recovering after a crash of an instance in a database is disclosed. According to the method, a plurality of dead transactions associated with the crashed instance are identified. Statistical data is compiled from the identified plurality of dead transactions. Based on the statistical data, it is determined that a particular number of recovery servers should be used to recover the plurality of dead transactions. The plurality of dead transactions are then recovered using the particular number of recovery servers. The particular number of recovery servers can execute in parallel to recover the plurality of dead transactions.
Claims40
A method for performing database recovery after a crash of an instance of a database, wherein multiple transactions were active when the instance crashed, the method comprising the steps of:
- identifying a plurality of dead transactions;
- determining statistical data about said plurality of dead transactions;
- determining that a particular number of recovery servers should be used to recover said plurality of dead transactions based on the statistical data;
- and
- recovering said plurality of dead transactions using said particular number of recovery servers.
A computer-readable medium carrying one or more sequences of one or more instructions for performing database recovery after a crash of an instance of a database, wherein multiple transactions were active when the instance crashed, wherein the execution of the one or more sequences of one or more instructions by one or more processors causes the one or more processors to perform the steps of:
- identifying a plurality of dead transactions;
- determining statistical data about said plurality of dead transactions;
- determining that a particular number of recovery servers should be used to recover said plurality of dead transactions based on the statistical data;
- and
- recovering said plurality of dead transactions using said particular number of recovery servers.
A system for performing database recovery after a crash of an instance of a database, wherein multiple transactions were active when the instance crashed, the system comprising:
- a memory;
- one or more processors coupled to the memory;
- and
- a set of computer instructions contained in the memory, the set of computer instructions including computer instructions which when executed by one or more processors, cause the one or more processors to perform the steps of:
- identifying a plurality of dead transactions;
- determining statistical data about said plurality of dead transactions;
- determining that a particular number of recovery servers should be used to recover said plurality of dead transactions based on the statistical data;
- and
- recovering said plurality of dead transactions using said particular number of recovery servers.
Dependencies are inferred from the claim text.