Data block based backup

Patent metadata

Field	Value
Publication number	US-9747168-B2
Application number	US-201514843010-A
Country	US
Kind code	B2
Filing date	Sep 2, 2015
Priority date	Oct 15, 2014
Publication date	Aug 29, 2017
Grant date	Aug 29, 2017

Abstract

The present invention relates to a data block based backup method for a data management system. The data management system comprises a file system that controls access by a database application to at least one database container file stored the data management system. The data management system further comprises a backup client that is connected to a remote backup server, whereby a first version of the database container file is saved in the backup server and a first inode containing information on data blocks of the first version of the database container file. The method may include creating a change tracking table for at least the database container file and adding an entry in the change tracking table, whereby the entry has an indication of the respective data block in association with an information indicating the type of the access.

First claim

What is claimed is:

1. A data block based backup method for a data management system, the data management system comprising a file system having a database management application program interface (DMAPI), wherein the file system controls access by a database application to at least one database container file set with a DMAPI event mask and stored in a first storage of the data management system, the data management system further comprising a backup client that is connected to a remote backup server in a client-server configuration, wherein a first version of the database container file is saved in the backup server, a first inode comprising information on data blocks of the first version of the database container file, the method comprising:
creating a change tracking table for at least the database container file, and repeatedly adding an entry in the change tracking table in response to detecting an access of the database application through the DMAPI to a data block of the database container file set with the DMAPI event mask, wherein the entry comprises an indication of the respective data block in association with an information indicating the type of the access, wherein the type of the access comprises at least one of a read and a write access tracked by the DMAPI event mask;
in response to receiving a request to backup the database container file: pausing the execution of the database application and performing a snapshot of a storage volume containing at least the file system and the database container file in a second storage of the data management system;
resuming the database application;
mounting the snapshot storage volume;
recreating the file system including a copy of the database container file in the second storage using the mounted storage volume and recreating the DMAPI event mask associated with the database container file;
identifying entries in the change tracking table referencing the database container file and that are associated with information indicating a write access;
copying the data associated with data blocks of the identified entries to the backup server from the copy of the database container file, thereby backing up a second version of the database container file; and
updating the first inode for indicating the backed up data blocks in the backup server, thereby obtaining a second inode.

2. The method of claim 1 , further comprising:
generating a metadata image of the file system including information on the database container file; and
sending the metadata image to the backup server.

3. The method of claim 2 , further comprising:
detecting a disaster event in the data management system;
pausing the database application;
retrieving the metadata image of the file system and the second inode from the backup
recreating the file system and an empty database container file using the metadata image; and
resuming the database application, wherein in case of a read access by the database application to a given data block of the database container file, retrieving the given data block from the backup server using the second inode.

4. The method of claim 2 , further comprising:
detecting a disaster event in the data management system, wherein the disaster event induces an interruption of the execution of the database application;
retrieving the change tracking table, the metadata image of the file system and the second inode from the backup server;
recreating the file system and an empty database container file using the metadata image;
retrieving data blocks associated with entries having a write and read access type of the database container file in the change tracking table; and
resuming the database application, wherein in case of a read access by the database application to a non-retrieved data block of the database container file, retrieving that data block from the backup server using the second inode.

5. The method of claim 1 , further comprising:
receiving a request to restore the second version of the first database file container; and
upon detecting a read access of the data base application to a data block of the current version of the database container file, using the second inode for retrieving the data block from the backup server.

6. The method of claim 1 , further comprising:
receiving a request to restore the second version of the first database file container;
retrieving the change tracking table from the backup server;
identifying entries of the change tracking table associated with a write access and entries associated with a read access in case the second version is not the last version;
using the second inode for retrieving the data blocks associated with the identified entries; and
upon detecting a read access of the data base application to a non-retrieved data block of the current version of the database container file, using the second inode for retrieving that data block from the backup server.

7. The method of claim 1 , wherein an entry of the tracking change table having information indicating a write or read access is updated only if the corresponding data block is accessed for writing.

8. The method of claim 1 , wherein the file system is a general parallel file system (GPFS).

9. The method of claim 1 , further comprising:
disabling the entries of the change tracking table that have been backed up by at least one of deleting said entries; and
changing the information to indicate a dummy value for the access type.

10. The method of claim 1 , wherein the change tracking table is stored in one of the data management system and the backup server.

11. A computer system for data block based backup for a data management system, the data management system comprising a file system having a database management application program interface (DMAPI), wherein the file system controls access by a database application to at least one database container file set with a DMAPI event mask and stored in a first storage of the data management system, the data management system further comprising a backup client that is connected to a remote backup server in a client-server configuration, wherein a first version of the database container file is saved in the backup server, a first inode comprising information on data blocks of the first version of the database container file, comprising:
one or more processors, one or more computer-readable memories, one or more computer-readable tangible storage medium, and program instructions stored on at least one of the one or more tangible storage medium for execution by at least one of the one or more processors via at least one of the one or more memories, wherein the computer system is capable of performing a method comprising:
creating a change tracking table for at least the database container file, and repeatedly adding an entry in the change tracking table in response to detecting an access of the database application through the DMAPI to a data block of the database container file set with the DMAPI event mask, wherein the entry comprises an indication of the respective data block in association with an information indicating the type of the access, wherein the type of the access comprises at least one of a read and a write access tracked by the DMAPI event mask;
in response to receiving a request to backup the database container file: pausing the execution of the database application and performing a snapshot of a storage volume containing at least the file system and the database container file in a second storage of the data management system;
resuming the database application;
mounting the snapshot storage volume;
recreating the file system including a copy of the

Assignees

• IBM

Inventors

• Haustein Nils
• Mueller-Wicke Dominic
• Prause Thomas
• Steinhauer Sabine U
• Uhl Andreas

Classifications

• G06F11/1451 Primary

  by selection of backup contents · CPC title

• G06F11/1469

  Backup restoration techniques · CPC title

• G06F2201/84

  Using snapshots, i.e. a logical point-in-time copy of the data · CPC title

• G06F2201/80

  Database-specific techniques · CPC title

• G06F17/30

  Physics · mapped topic