Redo mining during rolling upgrade
AssigneeOracle International Corporation
InventorSAIKRISHNAN KRISHNAMURTHY
Life of this patent
Estimating the term…
Abstract
In some embodiments, a client replication service manages log mining during a rolling upgrade, in which the primary role is switched over from an original primary DBMS to a new primary DBMS having updated software. The client replication service or specifically a mining engine maintains an original session on the original primary DBMS to mine redo logs associated with the original primary DBMS until the original primary DBMS is not a primary DBMS anymore. At that time, if the mining of those redo logs is not complete, the client replication service further starts a downstream session on the new primary DBMS to mine copies of the unmined redo logs.
Claims20
A method of mining redo logs during a rolling upgrade, comprising:
- starting mining redo logs associated with an original primary DBMS in an original session on the original primary DBMS;
- receiving a first notification that the original primary DBMS is no longer a primary DBMS;
- terminating, in response to the first notification, the original session;
- receiving a second notification that a logical standby DBMS of the original primary DBMS is converted to a new primary DBMS;
- starting, in response to the second notification, mining foreign redo logs registered with the new primary DBMS in a downstream session on the new primary DBMS,
- the foreign redo logs being copies of the redo logs associated with the original primary DBMS.
A non-transitory storage medium storing sequences of instructions which, when executed by one or more computing devices, cause:
- starting mining redo logs associated with an original primary DBMS in an original session on the original primary DBMS;
- receiving a first notification that the original primary DBMS is no longer a primary DBMS;
- terminating, in response to the first notification, the original session;
- receiving a second notification that a logical standby DBMS of the original primary DBMS is converted to a new primary DBMS;
- starting, in response to the second notification, mining foreign redo logs registered with the new primary DBMS in a downstream session on the new primary DBMS,
- the foreign redo logs being copies of the redo logs associated with the original primary DBMS.
A system for mining redo logs during a rolling upgrade, comprising:
- a memory;
- a processor cooperating with the memory to perform:
- in response to a physical standby DBMS of an original primary DBMS being converted to a logical standby DBMS in a rolling upgrade, updating new session information for a mining engine on the logical standby DBMS to indicate a downstream mode, while the mining engine continues mining redo logs associated with the original primary DBMS in an original session on the original primary DBMS;
- causing transporting of copies of redo logs associated with the original primary DBMS to the logical standby DBMS and registering the copies of redo logs as foreign redo logs on the logical standby DBMS,
- in response to the logical standby DBMS being converted to a new primary DBMS in the rolling upgrade, the mining engine starting mining at least one of the foreign redo logs that has not been mined in the original session based on the new session information in a downstream session on the new primary DBMS, instead of the original session on the original primary DBMS.
Dependencies are inferred from the claim text.