Database disaster remote site recovery

• US 6,226,651 B1
• Filed: 03/27/1998
• Issued: 05/01/2001
• Est. Priority Date: 03/27/1998
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Shedden, Jack R., Teng, James Zu-Chia, Masuda, Hiromi, Wang, Shyh-Yee
• Primary Examiner(s): Black, Thomas
• Assistant Examiner(s): Mizrahi, Diane D.
• Application Number:
  US09/049,274
• Time in Patent Office: 1,131 Days
• Field of Search: 707/200, 707/201, 707/202, 707/203, 707/204, 707/8
• US Class Current: 1/1
• CPC Class Codes: G06F 11/1471 involving logging of persistent data for recovery
• CPC Class Codes: G06F 11/2064 while ensuring consistency
• CPC Class Codes: G06F 11/2074 Asynchronous techniques
• CPC Class Codes: G06F 2201/80 Database-specific techniques
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

An integrated DBMS solution to recover primary site database based upon the maintenance of a shadow copy of the primary site'"'"'s database data and logs at a remote site. Both the primary site DBMS and the remote site DBMS may support write-ahead logging protocol in which log records are written to a log data set before database updates are entered into the remote site storage. The remote site serves at least two functions: as a “tracker” DBMS and as a “take-over” DBMS. The tracker function maintains a shadow copy of the primary site'"'"'s database data sets at the remote site. The multi-phased take-over function uses the shadow copies to update the remote site database data sets and substitutes them for primary site database data sets made unavailable by an unplanned disaster at the primary site.

Claims

1. A method to maintain a shadow copy of a primary site'"'"'s database data at a remote location, the method comprising the steps of:

initializing a remote site having a mirror image of the primary site'"'"'s database data;

periodically starting and stopping a tracker database management system (DBMS) at the remote site, the DBMS performing a recovery cycle to maintain the shadow copy of the primary site'"'"'s database data at the remote site; and

assigning an end log point to a log at the end of each recovery cycle, the end log point marking the end of log scan point for all data recovery done during the current recovery cycle, the end log point used as a starting point for a next recovery cycle.

2. The method recited in claim 1, the initializing step further comprising:

establishing a mirror image of the primary site'"'"'s database data at the remote site by transmitting all primary site database data and recovery logs from the primary site to the remote site; and

scanning the recovery logs from the last system checkpoint to determine transaction status and an earliest point in the recovery logs from which recovery will be executed.

3. The method recited in claim 2, the steps further comprising transmitting the primary site'"'"'s log data and an image copy of a database data set to the remote site if either the log data or a database data set is reorganized or replaced at the primary site.

4. A method for taking-over a primary site with a remote site, the method comprising the steps of:

initializing and rebuilding the remote site, the remote site including a shadow copy of the primary site'"'"'s database data and logs, the logs reflecting an end log point, the end log point marking an end of log scan point for all data recovery done during prior recovery cycles;

using the shadow copy logs to place the shadow copy database to a state of the primary site'"'"'s database before the primary site became unavailable;

acquiring locks for database data affected by in-doubt transactions;

backing-out data updated by transactions not committed at a time the primary site became unavailable; and

taking-over the primary site with the remote site.

5. The method recited in claim 4, initializing and rebuilding the remote site further comprising the steps of:

scanning the shadow copy logs from a last system checkpoint to determine transaction status at the time the primary site became unavailable; and

beginning forward log recovery from the end of log point in the shadow copy logs.

6. The method recited in claim 5, wherein in-doubt transactions are committed and processed.

7. The method recited in claim 5, wherein in-doubt transactions are rolled back.

8. A method to take-over a primary site with a remote site, the method comprising the steps of:

initializing a remote site having a mirror image of the primary site'"'"'s database data and logs;

maintaining a shadow copy of the primary site database data at a remote location, comprising;

starting and stopping a tracker system at the remote site, the tracker system performing a recovery cycle to maintain the shadow copy of the primary site'"'"'s database data at the remote site; and

assigning an end log point to a log at the end of each recovery cycle, the end log point marking an end of log scan point for all data recovery done during the current recovery cycle, the end log point used as the log scan starting point for a next recovery cycle;

using the shadow copy logs to place the shadow copy database to a state of the primary site'"'"'s database before the primary site became unavailable, including;

acquiring locks for data affected by transactions in-doubt at the time of unavailability; and

backing-out data updated by transactions not committed at the time of unavailability; and

taking-over the primary site with the remote site.

9. The method recited in claim 8, the initializing step further comprising:

establishing a mirror image of the primary site'"'"'s database data at the remote site by transmitting all primary site database data and recovery logs from the primary site to the remote site; and

scanning the recovery logs from the last system checkpoint to determine transaction status and an earliest point in the recovery logs from which recovery required to maintain the shadow copies will be executed.

10. The method recited in claim 9, the steps further comprising transmitting the primary site'"'"'s log data and an image copy of a database data set to the remote site if either the log data or a database data set is reorganized or replaced after the last tracker system recovery.

11. The method recited in claim 10, wherein in-doubt transactions are committed and processed.

12. The medium recited in claim 11, including a method step wherein in-doubt transactions are committed and processed.

13. The method recited in claim 10, wherein in-doubt transactions are rolled back.

14. The signal bearing medium tangibly embodying a program of machine readable instructions executable by a digital processing apparatus to perform a method for taking-over a primary site with a remote site, the method comprising the steps of:

initializing and rebuilding the remote site, the remote site including a shadow copy of the primary site'"'"'s database data and logs, the logs reflecting an end log point, the end log point marking an end of log scan point for all data recovery done during prior recovery cycles;

using the shadow copy logs to place the shadow copy database to a state of the primary site'"'"'s database before the primary site became unavailable;

acquiring locks for database data affected by in-doubt transactions;

backing-out data updated by transactions not committed at a time the primary site became unavailable; and

taking-over the primary site with the remote site.

15. The medium recited in claim 14, initializing and rebuilding the remote site further comprising the steps of:

scanning the shadow copy logs from a last system checkpoint to determine transaction status at the time the primary site became unavailable; and

beginning forward log recovery from the end of log point in the shadow copy logs.

16. The medium recited in claim 15, including a method step wherein in-doubt transactions are rolled back.

17. The signal bearing medium tangibly embodying a program of machine readable instructions executable by a digital processing apparatus to perform a method for taking-over a primary site with a remote site, the method comprising the steps of:

initializing a remote site having a mirror image of the primary site'"'"'s database data and logs;

maintaining a shadow copy of the primary site database data at a remote location, comprising;

periodically starting and stopping a tracker system at the remote site, the tracker system performing a recovery cycle to maintain the shadow copy of the primary site'"'"'s database data at the remote site; and

assigning an end log point to a log at the end of each recovery cycle, the end log point marking an end of log scan point for all data recovery done during the current recovery cycle, the end log point used as the log scan starting point for a next recovery cycle;

using the shadow copy logs to place the shadow copy database to a state of the primary site'"'"'s database before the primary site became unavailable, including;

acquiring locks for data affected by transactions in-doubt at the time of unavailability; and

backing-out data updated by transactions not committed at the time of unavailability; and

taking-over the primary site with the remote site.

18. The medium recited in claim 17, the initializing step further comprising:

establishing a mirror image of the primary site'"'"'s database data at the remote site by transmitting all primary site database data and recovery logs from the primary site to the remote site; and

scanning the recovery logs from the last system checkpoint to determine transaction status and an earliest point in the recovery logs from which recovery required to maintain the shadow copies will be executed.

19. The medium recited in claim 18, the steps further comprising transmitting the primary site'"'"'s log data and an image copy of a database data set to the remote site if either the log data or a database data set is reorganized or replaced after the last tracker system recovery.

20. The medium recited in claim 19, further comprising a method step wherein in-doubt transactions are committed and processed.

21. The medium recited in claim 19, further comprising a method step wherein in-doubt transactions are rolled back.

22. A signal-bearing medium tangibly embodying a program of machine-readable instructions executable by a digital processing apparatus to perform a method for maintaining a shadow copy of a primary site'"'"'s database data at a remote location, said method comprising:

initializing a remote site having a mirror image of the primary site'"'"'s database data;

periodically starting and stopping a tracker database management system (DBMS) at the remote site, the DBMS performing a recovery cycle to maintain the shadow copy of the primary site'"'"'s database data at the remote site; and

assigning an end log point to a log at the end of each recovery cycle, the end log point marking the end of log scan point for all data recovery done during the current recovery cycle, the end log point used as a starting point for a next recovery cycle.

23. The medium recited in claim 22, the method further comprising:

establishing a mirror image of the primary site'"'"'s database data at the remote site by transmitting all primary site database data and recovery logs from the primary site to the remote site; and

scanning the recovery logs from the last system checkpoint to determine transaction status and an earliest point in the recovery logs from which recovery will be executed.

24. The medium recited in claim 23, the method further comprising transmitting the primary site'"'"'s log data and an image copy of a database data set to the remote site if either the log data or a database data set is reorganized or replaced at the primary site.

25. An apparatus to maintain a shadow copy of a primary site'"'"'s database data at a remote location, comprising:

primary site storage including database data and logs;

primary site processor communicatively coupled to the primary site storage, and partially committed to managing the primary site database data and logs;

remote site storage including a shadow copy of the primary site database data and logs;

remote site processor communicatively coupled to the remote site storage, partially committed to managing the remote site database data and logs, the remote site processor communicatively coupled to the primary site and capable of performing method steps to recover the primary site using the remote site by;

initializing a remote site having a mirror image of the primary site'"'"'s database data;

periodically starting and stopping a tracker database management system (DBMS) at the remote site, the tracker system performing a recovery cycle to maintain the shadow copy of the primary site'"'"'s database data at the remote site; and

assigning an end log point to a log at the end of each recovery cycle, the end log point marking the end of log scan point for all data recovery done during the current recovery cycle, the end log point used as a starting point for a next recovery cycle.

26. The apparatus recited in claim 25, the remote site processor capable of further performing the steps of:

establishing a mirror image of the primary site'"'"'s database data at the remote site by transmitting all primary site database data and recovery logs from the primary site to the remote site; and

scanning the recovery logs from the last system checkpoint to determine transaction status and an earliest point in the recovery logs from which recovery will be executed.

27. The apparatus recited in claim 26, the remote site processor capable of further performing the steps of:

transmitting the primary site'"'"'s log data and an image copy of a database data set to the remote site if either the log data or a database data set is reorganized or replaced at the primary site.

28. An apparatus to maintain a shadow copy of a primary site'"'"'s database data at a remote location, comprising:

initializing a remote site having a mirror image of the primary site'"'"'s database data and logs;

maintaining a shadow copy of the primary site database data at a remote location, comprising;

periodically starting and stopping a tracker system at the remote site, the tracker system performing a recovery cycle to maintain the shadow copy of the primary site'"'"'s database data at the remote site; and

assigning an end log point to a log at the end of each recovery cycle, the end log point marking an end of log scan point for all data recovery done during the current recovery cycle, the end log point used as the log scan starting point for a next recovery cycle;

using the shadow copy logs to place the shadow copy database data to a state of the primary site'"'"'s database before the primary site became unavailable, including;

acquiring locks for database data affected by transactions in-doubt at the time of unavailability; and

backing-out data updated by transactions not committed at the time of unavailability; and

taking-over the primary site with the remote site.

29. The apparatus recited in claim 28, the remote site processor capable of further performing the steps of:

establishing a mirror image of the primary site'"'"'s database data at the remote site by transmitting all primary site database d ta and recovery logs from the primary site to the remote site; and

scanning the recovery logs from the last system checkpoint to determine transaction status and an earliest point in the recovery logs from which recovery required to maintain the shadow copies will be executed.

30. The apparatus recited in claim 29, the remote site processor capable of further performing the steps of:

transmitting the primary site'"'"'s log data and an image copy of a database data set to the remote site if either the log data or a database data set is reorganized or replaced after the last tracker system recovery.

31. The apparatus recited in claim 30, the remote site processor capable of further performing steps wherein in-doubt transactions are committed and processed.

32. The apparatus recited in claim 30, the remote site processor capable of further performing steps of wherein in-doubt transactions are rolled back.

33. An apparatus to maintain a shadow copy of a primary site'"'"'s database at a remote location, comprising:

means for storing database data and logs at a primary site;

means for storing a shadow copy of the database data and logs at a remote site and communicatively connected to the primary site;

processor means for maintaining and updating the shadow copy communicatively coupled to the primary site and the remote site, and capable of performing method steps to recover the primary site using the remote site by;

initializing a remote site having a mirror image of the primary site'"'"'s database data and logs;

maintaining a shadow copy of the primary site database at a remote location, comprising;

periodically starting and stopping a tracker system at the remote site, the tracker system performing a recovery cycle to maintain the shadow copy of the primary site'"'"'s database data at the remote site; and

assigning an end log point to a log at the end of each recovery cycle, the end log point marking an end of log scan point for all data recovery done during the current recovery cycle, the end log point used as the log scan starting point for a next recovery cycle;

using the shadow copy logs to place the shadow copy database data to a state of the primary site'"'"'s database before the primary site became unavailable, including;

acquiring locks for data affected by transactions in-doubt at the time of unavailability; and

backing-out data updated by transactions not committed at the time of unavailability; and

taking-over the primary site with the remote site.

34. The apparatus recited in claim 33, the initializing step further comprising:

establishing a mirror image of the primary site'"'"'s database data at the remote site by transmitting all primary site database data and recovery logs from the primary site to the remote site; and

scanning the recovery logs from the last system checkpoint to determine transaction status and an earliest point in the recovery logs from which recovery required to maintain the shadow copies will be executed.

35. The apparatus recited in claim 34, the initializing step further comprising transmitting the primary site'"'"'s log data and an image copy of a database data set to the remote site if either the log data or a database data set is reorganized or replaced after the last tracker system recovery.