Integrated database and log backup

Patent metadata

Field	Value
Publication number	US-10013313-B2
Application number	US-201514856208-A
Country	US
Kind code	B2
Filing date	Sep 16, 2015
Priority date	Sep 16, 2014
Publication date	Jul 3, 2018
Grant date	Jul 3, 2018

Abstract

Systems and methods of performing backup of databases and associated logs with one schedule such that a backup of both a database and its associated log can be restored or recovered to a desired point in time. A backup request associated with a backup type is received and defined by a service level agreement. The service level agreement includes a combined schedule for backing up both data stored in the database and log data associated with a database.

First claim

The invention claimed is:

1. A computerized method of performing backup of databases and associated logs with one schedule such that a backup of both a database and its associated log can be restored or recovered to a desired point in time, the method being executed by a processor in communication with memory storing instructions configured to cause the processor to:
receive a backup request, the backup request associated with a backup type defined by a service level agreement, the service level agreement defining a schedule for backing up a database associated with an application, the service level agreement including a combined schedule for backing up data stored in the database and log data associated with the database;
determine the backup type, the backup type including at least one of a database backup type, a log backup type, and a composite database backup and log backup type;
when the backup type comprises a database backup type:
transmit a database backup type instruction at a first time, to a host agent running on a database server, to create a first database backup, and
assign a first identifier to the first database backup, the first identifier including a first composite backup identifier indicative of a first set of log backups that share a first dependency relationship with the first database backup;

when the backup type comprises a log backup type:
transmit a log backup type instruction at a second time, to the host agent running on the database server, to create a first log backup,
assign the first identifier to the first log backup when the first time comprises a most recent prior database backup time to the second time, and
assign a second identifier to the first log backup when a most recent prior database backup time to the second time is associated with a second database backup, the second identifier including a second composite backup identifier indicative of a second set of log backups that share a second dependency relationship with the second database backup, the second set of log backups including the first log backup;

when the backup type comprises a composite database and log backup type:
transmit a composite database and log backup type instruction at a third time, to the host agent running on the database server, to create a composite database and log backup including a third database backup and a second log backup, and
assign a third identifier to the composite database and log backup, the third identifier including a third composite backup identifier indicative of a third set of log backups that share a third dependency relationship with the third database backup, the third set of log backups including the second log backup;

thereby performing data backup of databases and associated logs with one schedule such that a full backup of both a database and its associated log can be retrieved for a desired point in time.

2. The computerized method of claim 1 , wherein the processor is further caused to:
expire at least one of the first log backup and the second log backup based on at least one of:
a log expiration request, and
a corresponding database backup being expired, the corresponding database backup sharing an identifier with the at least one of the first log backup and the second log backup; and

expire at least one of the first database backup, the second database backup, and the third database backup based on a database expiration request,
such that space becomes available for use by another backup.

3. The computerized method of claim 2 , wherein each of the log expiration request and the database expiration request comprise at least one of:
an on demand request from a user; and
a scheduled expiration request based on the service level agreement.

4. The computerized method of claim 1 , wherein the processor is further configured to use the method of claim 1 for restore and recovery of the database associated with the application.

5. The computerized method of claim 1 , wherein the second composite backup identifier equals the third composite backup identifier when the third time comprises a most recent prior database backup time to the second time.

6. The computerized method of claim 1 , wherein each of the first log backup, the second log backup, the first database backup, the second database backup, and the third database backup comprise a snapshot.

7. The computerized method of claim 1 , wherein:
the first identifier further includes a first recovery range indicating a first set of database and log backups available for restoration and recovery, the first recovery range including the first database backup;
the second identifier further includes a second recovery range indicating a second set of database and log backups available for restoration and recovery, the second recovery range including the first log backup, the second database backup, and other log backups captured between the second time and the most recent prior database backup time; and
the third identifier further includes a third recovery range, the third recovery range including the composite database and log backup and any log backups subsequent to the composite database and log backup associated with the third composite backup identifier.

8. A computing system for performing backup of databases and associated logs with one schedule such that a backup of both a database and its associated log can be restored or recovered to a desired point in time, the computing system comprising:
a processor;
a memory coupled to the processor and including instructions that, when executed by the processor, cause the processor to:
receive a backup request, the backup request associated with a backup type defined by a service level agreement, the service level agreement defining a schedule for backing up a database associated with an application, the service level agreement including a combined schedule for backing up data stored in the database and log data associated with the database;
determine the backup type, the backup type including at least one of a database backup type, a log backup type, and a composite database backup and log backup type;
when the backup type comprises a database backup type:
transmit a database backup type instruction at a first time, to a host agent running on a database server, to create a first database backup, and
assign a first identifier to the first database backup, the first identifier including a first composite backup identifier indicative of a first set of log backups that share a first dependency relationship with the first database backup;

when the backup type comprises a log backup type:
transmit a log backup type instruction at a second time, to the host agent running on the database server, to create a first log backup,
assign the first identifier to the first log backup when the first time comprises a most recent prior database backup time to the second time, and
assign a second identifier to the first log backup when a most recent prior database backup time to the second time is associated with a second database backup, the second identifier including a second composite backup identifier indicative of a second set of log backups that share a second dependency relationship with the second database backup, the second set of log backups including the first log backup;

when the backup type comprises a composite database and log backup type:
transmit a composite database and log backup type instruction at a third time, to the host agent running on the database server, to create a composite database and log backup including a third database backup and a second log backup, and
assign a third identifier to the composite database and log backup, the third identifier including a third co

Assignees

• Actifio Inc

Inventors

• Zhang Xiangdong
• Tekade Uday
• Kumar Sachindra
• Mutalik Madhav

Classifications

• G06F11/1456

  Hardware arrangements for backup · CPC title

• G06F2201/815

  Virtual · CPC title

• G06F3/065

  Replication mechanisms · CPC title

• G06F11/1464

  for networked environments · CPC title

• G06F16/2365

  Ensuring data consistency and integrity · CPC title