Low-overhead relational database backup and restore operations

• US 20060004846A1
• Filed: 06/16/2004
• Published: 01/05/2006
• Est. Priority Date: 06/16/2004
• Status: Abandoned Application

• Current Assignee: BMC Software Incorporated (KKR & Co., Inc.)
• Original Assignee: BMC Software Incorporated (KKR & Co., Inc.)
• Inventors: Dee, Stanley James, Murley, Michael, Cline, Richard
• Application Number:
  US10/869,220
• Publication Number:
  US 20060004846A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 11/1451 by selection of backup contents

Abstract

A low-overhead relational database backup operation includes creating a single output file object in which a plurality of database tablespaces are stored. The number of tablespaces may be arbitrarily large. Because multiple output file objects are not created, the backup operation eliminates the overhead associated with allocating, opening, deallocating and closing multiple output file objects. Where the number of tablespaces is large, this reduced overhead processing can significantly the speed of backup operations.

Claims

1. A relational database copy method, comprising:

identifying a plurality of tablespaces in a relational database;

gaining access to an output file;

obtaining information from each identified tablespace;

writing the information obtained from each of the identified tablespaces to the output file, one tablespace at a time;

relinquishing access to the output file; and

updating a catalog file to reflect information from the plurality of tablespaces has been written to the output file.

2. The method of claim 1, further comprising the act of cataloging the output file.

3. The method of claim 1, wherein the act of gaining access to an output file comprises:

allocating the output file; and

opening the output file.

4. The method of claim 1, wherein the act of relinquishing access to the output file comprises:

deallocating the output file; and

closing the output file.

5. The method of claim 1, wherein the act of writing comprises writing the information obtained from each of the identified tablespaces to a magnetic tape-based output file.

6. The method of claim 1, wherein the act of obtaining information from each identified tablespace comprises obtaining table data from a first tablespace.

7. The method of claim 6, further comprising obtaining index data from the first tablespace.

8. The method of claim 1, wherein the act of updating a catalog file comprises:

writing an entry in the catalog file for each tablespace whose information was written to the output file; and

associating an identifier for the output file in each such entry.

9. A database method, comprising:

gaining access to an output file;

obtaining information associated with a plurality of objects in a database;

storing the information obtained from each of the plurality of objects in the output file, wherein all data associated with a first object is written to the output file before data associated with a second object is written to the output file;

relinquishing access to the output file; and

updating a catalog file to reflect information from the plurality of objects has been written to the output file.

10. The method of claim 9, wherein the act of gaining access to an output file comprises:

allocating the output file; and

opening the output file.

11. The method of claim 9, wherein the act of relinquishing access to the output file comprises:

deallocating the output file; and

closing the output file.

12. The method of claim 9, wherein the objects comprise tablespaces from a relational database.

13. The method of claim 9, wherein at least one of the objects comprise index data.

14. The method of claim 9, wherein the output file comprises a magnetic-tape output file.

15. The method of claim 9, further comprising the act of cataloging the output file.

16. A relational database backup method, comprising:

allocating an output file;

obtaining data associated with a tablespace;

writing the data to the output file;

repeating the acts of obtaining and writing for at least one additional tablespace; and

deallocating the output file.

17. The method of claim 16, further comprising writing an entry to a relational database-wide catalog file for each tablespace backed-up, said entry identifying the tablespace and the output file.

18. The method of claim 16, further comprising the act of cataloging the output file.

19. The method of claim 16, wherein the act of allocating further comprises opening the output file.

20. The method of claim 16, wherein the act of writing comprises writing the data to a magnetic tape-based output file.

21. The method of claim 16, wherein the act of obtaining data comprises obtaining table data and index data from at least one tablespace.

22. The method of claim 16, wherein the act of deallocating further comprises closing the output file.

23. A relational database copy method, comprising:

allocating an output file on a magnetic tape storage device;

opening the output file;

obtaining data stored in at least two tablespaces in a relational database;

writing the data obtained from each tablespace to the output file, one tablespace at a time;

closing the output file;

deallocating the output file; and

updating a catalog file to reflect information from the plurality of tablespaces has been written to the output file.

24. The method of claim 23, wherein the data stored in at least two tablespaces comprise table data and index data.

25. The method of claim 23, wherein the relational database comprises a DB2 database.

26. A computer database system, comprising:

memory;

a storage device operatively coupled to the memory, said storage device having stored thereon data associated tablespaces, said tablespaces comprising a relational database;

a backup media device operatively coupled to the memory; and

a central processing unit operatively coupled to the memory, storage device and backup media device, said central processing unit adapted to execute instructions to;

identify a first plurality of tablespaces in the relational database,

acquire access to an output file on the backup media device,

obtain data from two or more of the first plurality of tablespaces,

write the obtained data to the output file, one tablespace at a time,

relinquish access to the output file, and

update a catalog file on the storage device to reflect data from the two or more tablespaces has been written to the output file.

27. The computer database system of claim 26, wherein the central processing unit is further adapted to execute instruction to catalog the output file.

28. The computer database system of claim 26, wherein the backup media device comprises a magnetic tape backup device.

29. The computer database system of claim 26, wherein the data comprises table data and index data.

30. A relational database restore operation, comprising:

identifying a plurality of tablespaces to be restored;

identifying a backup file, said backup file including data associated for all of the identified tablespaces;

restoring each of the identified tablespaces form the backup file.

31. The method of claim 30, wherein the act of identifying a backup file comprises searching a database system table catalog file, said database system table catalog file associating each of the plurality of identified tablespaces with the output file.

32. The method of claim 30, wherein the act of restoring comprises:

retrieving information from each of the identified tablespaces from the output file and

writing the retrieved information to a format compatible with a database management system.