Online database migration

• US 9,792,321 B2
• Filed: 07/09/2013
• Issued: 10/17/2017
• Est. Priority Date: 07/09/2013
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Buehne, Stephan, Spiegelberg, Elmar
• Primary Examiner(s): OBERLY, VAN HONG
• Application Number:
  US13/937,545
• Publication Number:
  US 20150019487A1
• Time in Patent Office: 1,561 Days
• Field of Search: 707602
• CPC Class Codes: G06F 16/119 Details of migration of file systems migration mechanisms in storage systems G06F3/0647
• CPC Class Codes: G06F 16/214 Database migration support
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing

Abstract

Various arrangements for performing an online migration between server systems is presented. A transfer, from a source server system to a target server system, of a database, may be initiated. During the transfer, the database of the source server system may remain online. A timing indication of when transfer of the database was initiated may be recorded. While transferring the database, modifications to the records of the database may be received. The plurality of modifications may be stored, and, for each modification of the plurality of modifications, a timing indication of when the modification was received may be stored. After completing the transfer of the database to the target server system, the plurality of modifications to the database stored by the target server system may be applied while the source server system is online.

Claims

1. A method for performing an online migration of a plurality of databases between server systems, the method comprising:

initiating transfer, from a source database server in a source server system to a target database server in a target server system, of a plurality of databases, wherein the source server system is online and responding to database requests during transfer of the plurality of databases, and wherein the source database server and the target database server are distinct servers;

for each particular database within the plurality of databases;

determining, using a scheduler computer system, a particular time at which the particular database is to be copied to the target database server;

initializing, by the scheduler computer system, copying of the particular database to the target database server at the determined particular time; and

recording, by the source server system, a chronological indication of when the copying of the particular database was initialized by the scheduler computer system,

wherein the copying of each of the plurality of databases is initialized by the scheduler computer system at a different time, and wherein the copying of each of the plurality of databases requires a different length of time;

during the copying of the plurality of databases, receiving, by the source server system, a plurality of change requests, each change request associated with at least one of the plurality of databases;

storing, by the source server system, the plurality of change requests and, for each change request of the plurality of change requests, a chronological indication of when the change request was received; and

for each particular change request of the received plurality of change requests;

determining one or more of the particular databases affected by the particular change request;

comparing the chronological indication of when the particular change request was received to the one or more chronological indications of when the copying of the one or more of the particular affected databases was initialized; and

determining whether to apply the particular change request to the source server system or the target server system, based on the comparison of the chronological indication of when the particular change request was received to the chronological indications of when the copying of the particular affected databases was initialized; and

verifying, by the target server system, the plurality of databases.

2. The method for performing the online migration of the plurality of databases between server systems of claim 1, wherein the chronological indications of when the plurality of change requests were received are numbers assigned chronologically to database transactions performed by the source server system.

3. The method for performing the online migration of the plurality of databases between server systems of claim 1, wherein determining whether to apply a first particular change request to the source server system or the target server system comprises:

determining a first database affected by the first particular change request;

accessing a chronological indication indicative of when the copying of the first database was initialized; and

determining to apply the first change request to the first database as stored by the target server system based on determining that the chronological indication of when the first change request was received is greater than the chronological indication indicative of when the copying of the first database was initialized.

4. The method for performing the online migration of the plurality of databases between server systems of claim 3, wherein determining whether to apply a second particular change request to the source server system or the target server system comprises:

determining a second database affected by the second particular change request;

accessing a chronological indication indicative of when the copying of the second database was initialized; and

determining to apply the second change request to the second database as stored by the source server system based on determining that the chronological indication of when the second change request was received is less than the chronological indication indicative of when the copying of the second database was initialized.

5. The method for performing the online migration of the plurality of databases between server systems of claim 1, the method further comprising:

after copying the plurality of databases to the target database server and applying one or more of the plurality of change requests to the databases stored by the target server system while the source server system is online, causing the source server system to go offline such that the source server system does not respond to database requests; and

after causing the source server system to go offline, causing the target server system to go online such that the target server system responds to database requests.

6. The method for performing the online migration of the plurality of databases between server systems of claim 1, the method further comprising:

while copying the plurality of databases, receiving an increase in a number of migration scripts to run in parallel by the source server system; and

in response to the increase in the number of migration scripts, initiating, by the source server system, transfer of an additional database to the target database server.

7. The method for performing the online migration of the plurality of databases between server systems of claim 1, wherein each of the databases copied to the target database server matches the corresponding database stored in the source database server when copying of the database was initialized.

8. The method for performing the online migration of the plurality of databases between server systems of claim 1, further comprising:

in response to determining that a particular change request is to be applied to the source server system instead of the target server system;

after copying one or more databases affected by the particular change request to the target database server, applying the particular change requests to the affected databases within the target server system while the source server system is online and responding to database requests.

9. The method for performing the online migration of the plurality of databases between server systems of claim 1, wherein one or more index database objects reside in the source server system corresponding to the plurality of databases, and wherein the method further comprises:

generating one or more corresponding index database objects for the plurality of databases copied to the target server system, wherein the index database objects residing the source server system are not copied to the target server system.

10. A system for performing an online migration between server systems, the system comprising:

a source server system, configured to;

initiate a transfer, from a source database server in the source server system to a target database server in a target server system, of a plurality of databases, wherein the source server system is online and responding to database requests during transfer of the plurality of databases, and wherein the source database server is distinct from the target database server;

for each particular database within the plurality of databases;

determine, using a scheduler computer system, a particular time at which the particular database is to be copied to the target database server;

initialize, by the scheduler computer system, copying of the particular database to the target database server at the determined particular time, and

record a chronological indication of when the copying of the particular database was initialized by the scheduler computer system,

wherein the copying of each of the plurality of databases is initialized by the scheduler computer system at a different time, and wherein the copying of each of the plurality of databases requires a different length of time;

during the transferring of the plurality of databases,

receive a plurality of change requests, each change request associated with at least one of the plurality of databases,

store the plurality of change requests and, for each change request of the plurality of change requests, a chronological indication of when the change request was received; and

for each particular change request of the received plurality of change requests;

determine one or more of the particular databases affected by the particular change request;

compare the chronological indication of when the particular change request was received to the one or more chronological indications of when the copying of the one or more of the particular affected databases was initialized; and

determine whether to apply the particular change request to the source server system or the target server system, based on the comparison of the chronological indication of when the particular change request was received to the chronological indications of when the copying of the particular affected databases was initialized.

11. The system for performing the online migration between server systems of claim 10, wherein the chronological indications of when the plurality of change requests were received are numbers assigned chronologically to database transactions performed by the source server system.

12. The system for performing the online migration between server systems of claim 10, wherein determining whether to apply a first particular change request to the source server system or the target server system comprises:

determining a first database affected by the first particular change request;

accessing a chronological indication indicative of when transfer of a first object was initiated; and

accessing a chronological indication indicative of when transfer of the first database was initiated; and

determine to apply the first change request to the first database as stored by the target server system based on determining that the chronological indication of when the first change request was received is greater than the chronological indication indicative of when transfer of the first database was initialized.

13. The system for performing the online migration between server systems of claim 12, wherein determining whether to apply a second particular change request to the source server system or the target server system comprises:

determining a second database affected by the second particular change request;

accessing a chronological indication indicative of when transfer of the second database was initiated; and

determining to apply the second change request to the second database as stored by the source server system based on determining that the chronological indication of when the second change request was received is less than the chronological indication indicative of when transfer of the second database was initialized.

14. The system for performing the online migration between server systems of claim 10, wherein:

after transferring the plurality of databases to the target database server and applying one or more of the plurality of change requests to the databases stored by the target server system while the source server system is online, the source server system being configured to go offline such that the source server system does not respond to database requests; and

after the source server system is offline, the target server system being configured to go online such that the target server system responds to database requests.

15. The system for performing the online migration between server systems of claim 10, wherein the source server system is further configured to receive an increase in a number of migration scripts to run in parallel;

and

in response to the increase in the number of migration scripts, the source server system being configured to initiate transfer of an additional database to the target database server.

16. A computer-readable memory device comprising a set of instructions stored therein which, when executed by a processor, cause the processor to perform an online migration between database systems by:

initiating a transfer, from a source database server in a source database system to a target database server in a target database system, of a plurality of databases, wherein the source database system is online and responding to database requests during transfer of the plurality of databases, and wherein the source database server and the target database server are distinct servers;

for each particular database within the plurality of databases;

determining, using a scheduler computer system, a particular time at which the particular database is to be copied to the target database server;

initializing, by the scheduler computer system, copying of the particular database to the target database server at the determined particular time; and

recording a chronological indication of when the copying of the particular database was initialized by the scheduler computer system,

wherein the copying of each of the plurality of databases is initialized by the scheduler computer system at a different time, and wherein the copying of each of the plurality of databases requires a different length of time;

receiving a plurality of change requests while copying the plurality of databases, each change request associated with at least one of the plurality of databases;

storing the plurality of change requests and, for each change request of the plurality of change requests, a chronological indication of when the change request was received; and

for each particular change request of the received plurality of change requests;

determining one or more of the particular databases affected by the particular change request;

comparing the chronological indication of when the particular change request was received to the one or more chronological indications of when the copying of the one or more of the particular affected databases was initialized; and

determining whether to apply the particular change request to the source database system or the target database system, based on the comparison of the chronological indication of when the particular change request was received to the chronological indications of when the copying of the particular affected databases was initialized; and

verifying the plurality of databases.

17. The computer-readable memory device of claim 16, wherein the chronological indications of when the plurality of change requests were received are numbers assigned chronologically to database transactions performed by the source database system.

18. The computer-readable memory device of claim 16, wherein determining whether to apply a first particular change request to the source server system or the target server system comprises:

determining a first database affected by the first particular change request;

accessing a chronological indication indicative of when the copying of the first database was initialized; and

determining to apply the first change request to the first database as stored by the target server system based on determining that the chronological indication of when the first change request was received is greater than the chronological indication indicative of when the copying of the first database was initialized.

19. The computer-readable memory device of claim 18, wherein determining whether to apply a second particular change request to the source server system or the target server system comprises:

determining a second database affected by the second particular change request;

accessing a chronological indication indicative of when the copying of the second database was initialized; and

determining to apply the second change request to the second database as stored by the source server system based on determining that the chronological indication of when the second change request was received is less than the chronological indication indicative of when the copying of the second database was initialized.

20. The computer-readable memory device of claim 16, further comprising instructions stored therein which, when executed by the processor, cause the processor to perform an online migration between database systems by:

while copying the plurality of databases, receiving an increase in a number of migration scripts to run in parallel by the source server system; and

in response to the increase in the number of migration scripts, initiating, by the source server system, transfer of an additional database to the target database server.