Method and system for building a database from backup data images

• US 7,840,539 B2
• Filed: 01/24/2006
• Issued: 11/23/2010
• Est. Priority Date: 01/24/2006
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Mooney, David MacKay, Roecken, Michael, Rodger, Kelly D.
• Primary Examiner(s): Vital; Pierre M
• Assistant Examiner(s): Lee; Rachel J
• Application Number:
  US11/338,212
• Publication Number:
  US 20070174325A1
• Time in Patent Office: 1,764 Days
• Field of Search: None
• US Class Current: 707/674
• CPC Class Codes: G06F 11/1448 Management of the data involved in backup or backup restore
• CPC Class Codes: G06F 11/1469 Backup restoration techniques
• CPC Class Codes: G06F 11/1471 involving logging of persistent data for recovery

Abstract

Building a database from stored backup data images. In one aspect, an identification of a target image is received, the target image including a copy of a logical storage unit of data from a previous database and description information that describes the previous database. The target image holds a copy of a subset of the data of the previous database. A received list has at least one desired logical storage unit of data from the previous database to be included in a built database. The desired logical storage unit is restored from at least one stored data image to the built database using the description information in the target image. Other aspects include the target image being a database image, and the desired logical storage units of data being a subset of database data.

Claims

1. A method for building a database from stored data images, comprising:

receiving an identification of a previously-stored target backup image from any of one or more previously-stored data backup images, wherein the target backup image identifies a previous complete database and includes a copy of at least one table space of data from the previous complete database and description information that describes the previous complete database, wherein the description information includes a set of table space definitions describing a table space structure of the previous complete database;

receiving a list specifying a plurality of desired table spaces of data from the previous complete database to be included in a built database, the list specifying only a subset of the table spaces of the previous complete database;

restoring the desired table spaces from the one or more previously-stored data backup images to create the built database using the description information in the target backup image, the one or more previously-stored data backup images being a backup of the data and not being used in operating the previous complete database, wherein the built database is a partial database including only the subset of table spaces and is a newly-created database including the structure provided for the previous complete database, and wherein restoring the desired table spaces includes using the set of table space definitions in the target backup image to determine a table space structure for the built database, and retrieving and using the description information from the target backup image,

at least one of the desired table spaces being included in the target backup image and being restored from the target backup image to the built database, wherein one of the one or more previously-stored data backup images is the target backup image, and wherein a desired point in time of a structure of the built database is equal to a point in time of storage of the target backup image,

the target backup image not including all of the desired table spaces for the built database, and wherein the description information retrieved from the target backup image includes a recovery history file describing the one or more previously-stored data backup images that include the desired table spaces, at least one of the previously-stored data backup images including the desired table spaces which are not in the target backup image,

a copy of the recovery history file being included in each of the one or more previously-stored data backup images, each copy of the recovery history file describing the target backup image and all of the one or more previously-stored data backup images storing all of the data of the previous complete database, wherein each copy of the recovery history file includes information identifying the following;

a) each of all table spaces of the previous complete database that were stored in corresponding data backup images,

b) each of the corresponding data backup images in which each of the table spaces of the previous complete database was stored, and

c) each point in time that each of the corresponding data backup images of the previous complete database were backed up; and

wherein restoring the desired table spaces includes scanning the recovery history file of the target backup image to determine desired backup images that include the desired table spaces not included in the target backup image, and restoring the desired backup images to the built database.

2. The method of claim 1, wherein at least one of the desired backup images was stored at a different point in time than the target backup image.

3. The method of claim 2, further comprising sorting the desired backup images chronologically into a chronological order according to a time at which they were stored, and wherein the chronological order is included in the restoration of the desired backup images to the built database, the desired backup images being restored one at a time to the built database.

4. The method of claim 1, wherein at least one of the desired backup images includes a copy of incremental data relative to a different previous backup image, the incremental data resulting from an incremental backup of data.

5. The method of claim 3, further comprising replaying log information to update the data restored from the desired backup images and synchronize the data from the desired backup images with the data from the target backup image.

6. The method of claim 1 further comprising restoring a catalog table space from the target backup image or one of the previously-stored data backup images, the catalog table space being a table space of the previous complete database that includes control information that is required to use the built database.

17. The method of claim 1 wherein a particular past point in time is received from a user to which the user wishes the database to be built, and the identification of the target backup image is not received from the user, and further comprising:

finding and identifying a backup image closest in time to the particular past point in time to be used as the target backup image, such that the identification of the previously-stored target backup image identifies the backup image closest in time to the particular past point in time.

7. A computer program product comprising a computer readable storage medium including program instructions implemented by a computer system for building a database from stored data images, the program instructions for:

receiving an identification of a previously-stored target backup image from any of one or more previously-stored data backup images, wherein the target backup image identifies a previous complete database and includes a copy of at least one table space of data from the previous complete database and description information that describes the previous complete database, wherein the description information includes a set of table space definitions describing a table space structure of the previous complete database;

receiving a list specifying a plurality of desired table spaces of data from the previous complete database to be included in a built database, the list specifying only a subset of the table spaces of the previous complete database;

restoring the desired table spaces from the one or more previously-stored data backup images to create the built database using the description information in the target backup image, the one or more previously-stored data backup images being a backup of the data and not being used in operating the previous complete database, wherein the built database is a partial database including only the subset of table spaces and is a newly-created database including the structure provided for the previous complete database, and wherein restoring the desired table spaces includes using the set of table space definitions in the target backup image to determine a table space structure for the built database, and retrieving and using the description information from the target backup image,

at least one of the desired table spaces being included in the target backup image and being restored from the target backup image to the built database, wherein one of the one or more previously-stored data backup images is the target backup image, and wherein a desired point in time of a structure of the built database is equal to a point in time of storage of the target backup image,

the target backup image not including all of the desired table spaces for the built database, and wherein the description information retrieved from the target backup image includes a recovery history file describing the one or more previously-stored data backup images that include the desired table spaces, at least one of the previously-stored data backup images including the desired table spaces which are not in the target backup image,

a copy of the recovery history file being included in each of the one or more previously-stored data backup images, each copy of the recovery history file describing the target backup image and all of the one or more previously-stored data backup images storing all of the data of the previous complete database, wherein each copy of the recovery history file includes information identifying the following;

a) each of all table spaces of the previous complete database that were stored in corresponding data backup images,

b) each of the corresponding data backup images in which each of the table spaces of the previous complete database was stored, and

c) each point in time that each of the corresponding data backup images of the previous complete database were backed up; and

wherein restoring the desired table spaces includes scanning the recovery history file of the target backup image to determine desired backup images that include the desired table spaces not included in the target backup image, and restoring the desired backup images to the built database.

8. The computer program product of claim 7, wherein restoring the desired table spaces includes scanning the recovery history file of the target backup image to determine desired backup images that include the desired table spaces not included in the target backup image, and restoring the desired backup images to the built database, wherein at least one of the desired backup images was stored at a different point in time than the target backup image, and further comprising sorting the desired backup images chronologically into a chronological order according to a time at which they were stored, wherein the chronological order is included in the restoration of the desired backup images to the built database, the desired backup images being restored one at a time to the built database.

9. The computer program product of claim 7, wherein at least one of the desired backup images includes a copy of incremental data relative to a different previous backup image, the incremental data resulting from an incremental backup of data.

10. The computer program product of claim 8, further comprising replaying log information to update the data restored from the desired backup images and synchronize the data from the desired backup images with the data from the target backup image.

11. The computer program product of claim 7 further comprising restoring a catalog table space from the target backup image or one of the previously-stored data backup images, the catalog table space being a table space of the previous complete database that includes control information that is required to use the built database.

18. The computer program product of claim 7 wherein a particular past point in time is received from a user to which the user wishes the database to be built, and the identification of the target backup image is not received from the user, and further comprising:

finding and identifying a backup image closest in time to the particular past point in time to be used as the target backup image, such that the identification of the previously-stored target backup image identifies the backup image closest in time to the particular past point in time.

12. A system for building a database from stored data images, the system comprising:

a memory;

a database for storing a built database;

data storage that stores a target backup image, wherein the target backup image is any of one or more previously-stored data backup images and identifies a previous complete database and includes a copy of at least one table space of data from the previous complete database and description information that describes the previous complete database, wherein the description information includes a set of table space definitions describing a table space structure of the previous complete database;

a build processor in communication with the database and the data storage, the build processor operative to receive an identification of the target backup image and a list specifying a plurality of desired table spaces of data from the previous complete database to be included in a built database, the list specifying only a subset of the table spaces of the previous complete database,

wherein the build processor restores the desired table spaces from the one or more previously-stored data backup images to create the built database using the description information in the target backup image, the one or more previously-stored data backup images being a backup of the data and not being used in operating the previous complete database, wherein the built database is a partial database including only the subset of table spaces and is a newly-created database including the structure provided for the previous complete database, and wherein restoring the desired table spaces includes using the set of table space definitions in the target backup image to determine a table space structure for the built database, and retrieving and using the description information from the target backup image,

at least one of the desired table spaces being included in the target backup image and being restored from the target backup image to the built database, wherein one of the one or more previously-stored data backup images is the target backup image, and wherein a desired point in time of a structure of the built database is equal to a point in time of storage of the target backup image,

the target backup image not including all of the desired table spaces for the built database, and wherein the description information retrieved from the target backup image includes a recovery history file describing the one or more previously-stored data backup images that include the desired table spaces, at least one of the previously-stored data backup images including the desired table spaces which are not in the target backup image,

a copy of the recovery history file being included in each of the one or more previously-stored data backup images, each copy of the recovery history file describing the target backup image and all of the one or more previously-stored data backup images storing all of the data of the previous complete database, wherein each copy of the recovery history file includes information identifying the following;

a) each of all table spaces of the previous complete database that were stored in corresponding data backup images,

b) each of the corresponding data backup images in which each of the table spaces of the previous complete database was stored, and

c) each point in time that each of the corresponding data backup images of the previous complete database were backed up; and

wherein the build processor restores the desired table spaces including scanning the recovery history file of the target backup image to determine desired backup images that include the desired table spaces not included in the target backup image, and restoring the desired backup images to the built database.

13. The system of claim 12, wherein the build processor restores the desired table spaces including scanning the recovery history file of the target backup image to determine desired backup images that include the desired table spaces not included in the target backup image, and restoring the desired backup images to the built database, wherein at least one of the desired backup images was stored at a different point in time than the target backup image, and wherein the build processor sorts the desired backup images chronologically into a chronological order according to a time at which they were stored, wherein the chronological order is included in the restoration of the desired backup images to the built database, the desired backup images being restored one at a time to the built database.

14. The system of claim 12, wherein at least one of the desired backup images includes a copy of incremental data relative to a different previous backup image, the incremental data resulting from an incremental backup of data.

15. The system of claim 13, wherein the build processor replays log information to update the data restored from the desired backup images and synchronize the data from the desired backup images with the data from the target backup image.

16. The system of claim 12 wherein the build processor restores a catalog table space from the target backup image or one of the previously-stored data backup images, the catalog table space being a table space of the previous complete database that includes control information that is required to use the built database.

19. The system of claim 12 wherein a particular past point in time is received from a user to which the user wishes the database to be built, and the identification of the target backup image is not received from the user, and wherein the build processor finds and identifies a backup image closest in time to the particular past point in time to be used as the target backup image, such that the identification of the previously-stored target backup image identifies the backup image closest in time to the particular past point in time.