IP Library › Granted Patent US 7,711,712

Granted Patent B2

US 7,711,712 · App. 11/685,138 · Granted May 4, 2010

System and method for managing consistency among volumes based on application information

Assignee: Hitachi, Ltd.

View Patent ↗

Loading inventors, assignments & file history…

Monitor This Case

Get email alerts when status or documents change.

Order Certified Copies

Most orders are placed with the USPTO same day — all within 24 business hours.

Order via The Patent Place →

Pre-filled with this patent's details

Quick Facts

Patent No.: US 7,711,712
App. No.: 11/685,138
Granted: May 4, 2010
Kind: B2

External Links

USPTO Patent Center↗ Full Patent PDF↗

Abstract

In accordance with new technique, a computerized data recovery system includes a storage subsystem and a backup server operatively coupled to backup storage medium, the storage subsystem including a continuous data protection system. The backup server executes a recovery manager which: collects consistency points from at least two database applications executing on at least one host; collects journal terms of the continuous data protection system for each of the at least two database applications; collects log terms associated with each of the at least two database applications; displays to a user a timeline for a protected term and consistency points for the at least two database applications; receives recovery time selection from a user; receives recovery database application selection from the user; receives baseline database application selection from the user; performs crash recovery for each database application; and performs recovery of data based on transactions associated with the at least two database applications.

Claims (69)

1. A method for data recovery comprising:

a. collecting consistency points from at least two database applications;

b. collecting journal terms associated with continuous data protection for each of the at least two database applications;

c. collecting log terms associated with each of the at least two database applications;

d. displaying to a user a timeline for a protected term and consistency points for the at least two database applications;

e. receiving recovery time selection from a user;

f. receiving recovery database application selection from the user;

g. receiving baseline database application selection from the user;

h. performing crash recovery for each database application; and

i. performing recovery of data based on transactions associated with the at least two database applications;

j. selecting a recovery transaction identifier for the selected database application;

k. checking a current transaction identifier for the selected database application;

l. if the recovery transaction identifier is identical to the current transaction identifier, selecting another database application from the at least two database applications; and

m. if the recovery transaction identifier is not identical to the current transaction identifier, executing alignment of transactions in the selected database application by executing a rollback and roll forward operation.

2. The data recovery method of claim 1 , further comprising:

n. obtaining the baseline database application;

o. retrieving transaction information for a source database application associated with the baseline database application; and

p. selecting an un-processed database application from the at least two databases applications.

3. The data recovery method of claim 1 , further comprising providing a user with graphical user interface for making the selections.

4. The data recovery method of claim 1 , wherein the consistency points comprise at least one of a point-in-time mirror copy, a snapshot point-in-time image, a tape and a continuous data protection marker.

5. The data recovery method of claim 1 , wherein the consistency point comprises at least of hot backup data and cold backup data.

6. The data recovery method of claim 1 , wherein collecting journal terms comprises accessing continuous data protection journal first and last header information via a remote access.

7. The data recovery method of claim 1 , wherein the log comprises at least one of a redo log and an archive log.

8. A computerized data recovery system comprising a storage subsystem and a backup server operatively coupled to backup storage medium, the storage subsystem comprising a continuous data protection system and the backup server executing a recovery manager operable to:

a. collect consistency points from at least two database applications executing on at least one host;

b. collect journal terms of the continuous data protection system for each of the at least two database applications;

c. collect log terms associated with each of the at least two database applications;

d. display to a user a timeline for a protected term and consistency points for the at least two database applications;

e. receive recovery time selection from a user;

f. receive recovery database application selection from the user;

g. receive baseline database application selection from the user;

h. perform crash recovery for each database application; and

i. perform recovery of data based on transactions associated with the at least two database applications;

j. select a recovery transaction identifier for each database application from the at least two database applications;

k. check a current transaction identifier for each database application;

l. if the recovery transaction identifier is not identical to the current transaction identifier, select another database application from the at least two database applications; and

m. execute alignment of transactions in the at least two database applications by executing a rollback and roll forward operation.

9. The computerized data recovery system of claim 8 , wherein the recovery manager further comprises a consistency manager operable to:

n. obtain the baseline database application; and

o. retrieve transaction information for a source database application associated with the baseline database application.

10. The computerized data recovery system of claim 8 , further comprising providing a user with graphical user interface for making the selections.

11. The computerized data recovery system of claim 8 , wherein the consistency points comprise at least one of a point-in-time minor copy, a snapshot point-in-time image, a tape and a continuous data protection marker.

12. The computerized data recovery system of claim 8 , wherein the consistency point comprises at least of hot backup data and cold backup data.

13. The computerized data recovery system of claim 8 , wherein collecting journal terms comprises accessing continuous data protection journal first and last header information via a remote access.

14. The computerized data recovery system of claim 8 , wherein the log comprises at least one of a redo log and an archive log.

15. The computerized data recovery system of claim 8 , wherein the continuous data protection system comprises a journal manager operable to journal at least one of input and output operations for at least one of the database applications.

16. The computerized data recovery system of claim 15 , wherein the continuous data protection system further comprises a second journal manager operable to journal at least one of input and output operations for at least one of the database applications.

17. A computer-readable medium embodying a set of computer instructions, the instructions, when executed by one or more processors causing the one or more processors to:

a. collect consistency points from at least two database applications;

b. collect journal terms associated with continuous data protection for each of the at least two database applications;