Content-independent and database management system-independent synthetic full backup of a database based on snapshot technology

Patent metadata

Field	Value
Publication number	US-2019129799-A1
Application number	US-201816232946-A
Country	US
Kind code	A1
Filing date	Dec 26, 2018
Priority date	Apr 21, 2015
Publication date	May 2, 2019
Grant date	—

Abstract

The illustrative storage management system uses snapshot technologies and performs block-level analysis thereof and to synthesize full backups of a database, regardless of the database management system (DBMS) and content of the database and without involving native DBMS utilities. Synthetic full copies are created efficiently and use network transport resources sparingly. Successive snapshots of the database may be hardware snapshots and/or software snapshots. The illustrative storage management system tracks which data blocks in the database change over time after a baseline full copy is saved to secondary storage. Only the changed blocks are subsequently moved to secondary storage as incremental backups and are indexed for future reference. A synthetic full backup of the database, at a given point in time, may be created by synthesizing the original full backup with changed blocks from any number of later incremental backups. The synthetic full backup comprises pointers to appropriate data blocks, ignoring intermediate changes, and pointing to the most current data block in secondary storage relative to the given point in time chosen for the synthetic full backup. The illustrative storage management system may restore the synthetic full backup without native DBMS utilities.

First claim

What is claimed is:

1 . A non-transitory computer-readable medium storing instructions that, when executed by a computing device that comprises one or more processors and computer memory, cause the computing device to:
store a copy of a first snapshot of a database to a storage device, wherein a database management system (DBMS) changes data in the database; after the first snapshot, cause successive snapshots of the database to be generated, wherein for a given successive snapshot:
(i) from a block filter that is independent of data block content, receive identifiers of changed data blocks within the given successive snapshot that changed compared to corresponding data blocks in an immediately preceding snapshot of the database,
(ii) extract the changed data blocks from the given successive snapshot,
(iii) generate an incremental backup copy of the database that corresponds to the given successive snapshot and comprises the changed data blocks extracted from the given successive snapshot, and
(iv) track the changed data blocks in the incremental backup copy in an index of changed data blocks;
use the index to find, in the copy of the first snapshot and in incremental backup copies corresponding to the successive snapshots, data blocks that are most current in time including changed data blocks and skipping over changed data blocks that are not most current in time; consolidate the data blocks that are most current in time to generate a synthetic full block-level backup copy of the database; store the synthetic full block-level backup copy of the database to the storage device; and independent of database content, restore the database from the synthetic full block-level backup copy without using a native restore feature of the database management system (DBMS).

2 . The non-transitory computer-readable medium of claim 1 , wherein the index tracks the changed data blocks using pointers.

3 . The non-transitory computer-readable medium of claim 1 , wherein the synthetic full block-level backup copy of the database is generated based on pointers in the index that point to the data blocks that are most current in time.

4 . The non-transitory computer-readable medium of claim 1 , wherein the synthetic full block-level backup copy of the database comprises pointers obtained from the index that point to the data blocks that are most current in time.

5 . The non-transitory computer-readable medium of claim 1 , wherein the copy of the first snapshot comprises all data blocks in the first snapshot.

6 . The non-transitory computer-readable medium of claim 1 , wherein a media agent that executes on the computing device performs according to the instructions.

7 . The non-transitory computer-readable medium of claim 1 , wherein the synthetic full block-level backup copy is independent of type of database management system.

8 . The non-transitory computer-readable medium of claim 1 , wherein a data agent, which is a component of a data storage management system that also comprises the computing device, monitors changes to the database made by the database management system (DBMS) using the block filter.

9 . The non-transitory computer-readable medium of claim 1 , wherein the successive snapshots of the database are generated by a storage device that stores the database.

10 . The non-transitory computer-readable medium of claim 1 , wherein the successive snapshots of the database of the database are generated by a computing device that hosts the database management system (DBMS).

11 . A method performed by a media agent that executes on a computing device comprising one or more processors and computer memory:
storing a copy of a first snapshot of a database to a storage device, wherein a database management system (DBMS) changes data in the database; after the first snapshot, causing successive snapshots of the database to be generated, wherein for a given successive snapshot:
(i) from a block filter that is independent of data block content, receiving identifiers of changed data blocks within the given successive snapshot that changed compared to corresponding data blocks in an immediately preceding snapshot of the database,
(ii) extracting the changed data blocks from the given successive snapshot,
(iii) generating an incremental backup copy of the database that corresponds to the given successive snapshot and comprises the changed data blocks extracted from the given successive snapshot, and
(iv) tracking the changed data blocks of the incremental backup copy in an index of changed data blocks;
using the index to find, in the copy of the first snapshot and in incremental backup copies corresponding to the successive snapshots, data blocks that are most current in time including changed data blocks and skipping over changed data blocks that are not most current in time; consolidating the data blocks that are most current in time into a synthetic full block-level backup copy of the database; storing the synthetic full block-level backup copy of the database to the storage device; and independent of database content, restoring the database from the synthetic full block-level backup copy without using a native restore feature of the database management system (DBMS).

12 . The method of claim 11 , wherein the index tracks the changed data blocks using pointers.

13 . The method of claim 11 , wherein the synthetic full block-level backup copy of the database is generated based on pointers in the index that point to the data blocks that are most current in time.

14 . The method of claim 11 , wherein the synthetic full block-level backup copy of the database comprises pointers obtained from the index that point to the data blocks that are most current in time.

15 . The method of claim 11 , wherein the copy of the first snapshot comprises all data blocks in the first snapshot.

16 . The method of claim 11 , wherein the synthetic full block-level backup copy is independent of type of database management system.

17 . The method of claim 11 , wherein a data agent, which is a component of a data storage management system that also comprises the computing device, monitors changes to the database made by the database management system (DBMS) using the block filter.

18 . The method of claim 11 , wherein the successive snapshots of the database are generated by a storage device that stores the database.

19 . The method of claim 11 , wherein the media agent restores the database from the synthetic full block-level backup copy in conjunction with a data agent, which is a component of a data storage management system that also comprises the computing device, and wherein the data agent monitors changes to the database made by the database management system (DBMS) using the block filter.

20 . The method of claim 11 , wherein the restored database is directly accessible as primary data to the database management system (DBMS).

Assignees

• Commvault Systems Inc

Inventors

• Kumarasamy Paramasivam

Classifications

• G06F2201/84

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

• G06F2201/80

  Database-specific techniques · CPC title

• G06F11/1448

  Management of the data involved in backup or backup restore · CPC title

• G06F11/1435 Primary

  using file system or storage system metadata · CPC title

• G06F11/1451 Primary

  by selection of backup contents · CPC title