Recreation of archives at a disaster recovery site

• US 6,691,139 B2
• Filed: 01/31/2001
• Issued: 02/10/2004
• Est. Priority Date: 01/31/2001
• Status: Expired due to Term

• Current Assignee: Valtrus Innovations Limited (f/k/a Dolya Holdco 9 Limited) (Key Patent Innovations Limited)
• Original Assignee: Hewlett-Packard Development Company, L.P. (HP Inc.)
• Inventors: Ganesh, Shivaji, Kavanappillil, Ramesh
• Primary Examiner(s): KINDRED, ALFORD W
• Application Number:
  US09/774,839
• Publication Number:
  US 20020103816A1
• Time in Patent Office: 1,105 Days
• Field of Search: 707/1-2, 707/7, 707/100-101, 707/200, 707/204-205, 714/13-15, 711/3, 711/100, 711/143
• US Class Current: 1/1
• CPC Class Codes: G06F 11/1451 by selection of backup contents
• CPC Class Codes: G06F 11/1464 for networked environments
• CPC Class Codes: G06F 11/1471 involving logging of persistent data for recovery
• CPC Class Codes: G06F 11/1474 in transactions G06F16/20 takes precedence
• CPC Class Codes: G06F 11/2064 while ensuring consistency
• CPC Class Codes: G06F 11/2066 Optimisation of the communication load
• CPC Class Codes: G06F 11/2071 using a plurality of controllers
• CPC Class Codes: G06F 11/2079 Bidirectional techniques
• CPC Class Codes: G06F 11/2097 maintaining the standby controller/processing unit updated initialisation or re-synchronisation thereof G06F11/1658 and subgroups
• CPC Class Codes: G06F 2201/80 Database-specific techniques
• CPC Class Codes: Y10S 707/99955 Archiving or backup

Abstract

A method for creating a standby data processing system located at a standby site, which is remotely located from a primary site. The method comprises a first step of computing a difference between an active data file and an archive data file to produce a delta image at the primary site. Another step is transmitting the active data file and the delta image, separately in time sequence, from the primary site to a standby site. A final step is combining the delta image with the active data file at the standby site, to produce an archive data file. An advantage of this method is the creation of a standby data processing system, while using a lower bandwidth to create this additional site.

Claims

1. A method for creating a standby data processing system located at a standby site, which is remotely located from a primary site, comprising the steps of:

(a) computing a difference between an active transaction redo log and an archive transaction redo log to produce a delta image at the primary site;

(b) transmitting the active transaction redo log and the delta image, separately in time sequence, from the primary site to the standby site; and

(c) combining the delta image with the active transaction redo log at the standby site, to produce a standby archive transaction redo log.

2. A method as in claim 1, further comprising the step of storing the standby archive transaction redo log on the standby site.

3. A method as in claim 1, further comprising the step of storing transactions in the standby active transaction redo log as they are trapped at the primary site.

4. A method as in claim 1, further comprising the step of entering transactions from the archive transaction redo log into the standby transaction processing system.

5. A method for creating archive redo logs for a standby database at a remote location, comprising the steps of:

(a) trapping active log writes using a remote mirroring device that is capable of mirroring the log writes to a standby site, to create an online redo log at the standby site;

(b) computing a difference between an online redo log and archive redo log to create a delta image at a primary database, wherein the delta image includes an archive header;

(c) transmitting the delta image to a standby archive log replicator contained in the standby database; and

(d) combining the delta image and archive header with the online redo log to create a standby archive redo log on the standby database.

6. A method as in claim 5, further comprising the step of applying the standby archive redo log by creating links to the standby archive redo log.

7. A method as in claim 5, further comprising the step of transmitting the delta image to a standby archive log replicator using a first remote mirroring device in the primary database and a second remote mirroring device in the standby database.

8. A method as in claim 7, further comprising the step of using replication handles to track the progress of mirror writes on the standby database as compared to the primary database.

9. A method as in claim 8, further comprising the step of checking the primary database queries using the archive log replicator to determine whether archiving is complete.

10. A method as in claim 5, further comprising the step of shipping an entire archive redo log from the primary archive log replicator to the standby archive log replicator asynchronously after archiving becomes slow enough that there is a risk of primary database blocking.

11. A method as in claim 10, further comprising the step of shipping an entire archive redo log from the primary archive log replicator to the standby archive log replicator asynchronously when a spool buffer in a remote mirroring system has been filled.

12. A method for creating archive redo logs from a primary database, for a standby database at a remote location, comprising the steps of:

(a) trapping file system transactions to create an online redo log at the standby database;

(b) computing a difference between an online redo log and archive redo log in the primary database to find the delta image of the archive redo log;

(c) transmitting the delta image to a standby database; and

(d) combining the delta image with the online redo log in the standby database to create standby archive redo log on the standby database.

13. A method as in claim 12, further comprising the step of applying the standby archive redo log by creating a link between the standby database and the standby archive redo log.

14. A method as in claim 12, further comprising the step of transmitting the delta image to a standby archive log replicator using a first remote mirroring device in the primary database and a second remote mirroring device in the standby database.

15. A method as in claim 14, further comprising the step of using replication handles to track the progress of mirror writes on the standby database as compared to the primary database.

16. A method as in claim 12, further comprising the step of checking the primary database with database queries using the archive log replicator to determine whether archiving is complete.

17. A method as in claim 12, further comprising the step of shipping an entire archive redo log from the primary archive log replicator to the standby archive log replicator asynchronously after archiving becomes slow enough that there is a risk of the primary database blocking.

18. A method as in claim 12, further comprising the step of shipping the entire archive redo log from the primary archive log replicator to the standby archive log replicator asynchronously when a spool buffer in a remote mirroring system has been filled.

19. A system for creating a standby data processing system located at a standby site, which is remotely located from a primary site, comprising the steps of:

means for computing a difference between an active data file and an archive data file to produce a delta image at the primary site;

means for transmitting the active data file and the delta image, separately in time sequence, from the primary site to the standby site; and

means for combining the delta image with the active data file at the standby site, to produce a standby archive data file.

20. An article of manufacture comprising:

a computer usage medium having computer readable program code means embodied therein for creating archive redo logs for a standby database at a remote location, the computer readable program code means in said article of manufacture comprising;

computer readable program code means for trapping active log writes using a remote mirroring device that is capable of mirroring the log writes to a standby site, to create an online redo log at the standby site;

computer readable program code means for computing a difference between an online redo log and archive redo log to create a delta image at a primary database;

computer readable program code means for transmitting the delta image to a standby archive log replicator contained in the standby database; and

computer readable program code means for combining the delta image with the online redo log to create a standby archive redo log on the standby database.