Self-adaptive copy retention management

Patent metadata

Field	Value
Publication number	US-11687505-B2
Application number	US-202117236397-A
Country	US
Kind code	B2
Filing date	Apr 21, 2021
Priority date	Apr 21, 2021
Publication date	Jun 27, 2023
Grant date	Jun 27, 2023

Abstract

A current retention mode is identified as being one of conservative or aggressive. When the retention mode is identified as aggressive, a check is made as to whether used space on backup storage is below a lower threshold. If the used space is below the lower threshold, a switch is made into the conservative mode. If the used space is above the lower threshold, the aggressive mode is maintained. While in the aggressive mode, a backup chain of a database is selected for pruning, the selected backup chain having a shortest retention term of all backup chains not yet pruned and not being a latest backup chain. Log backups of the database in the selected backup chain are identified. Each log backup that has expired is deleted regardless of dependency of other backups on an expired log backup.

First claim

What is claimed is:

1. A method of managing copy retention for backups of a database comprising:
identifying a current retention mode as being one of a conservative mode or an aggressive mode, wherein the conservative mode preserves expired backup copies on which an unexpired backup copy depends, and the aggressive mode deletes the expired backup copies on which the unexpired backup copy depends when a plurality of conditions are satisfied;
when the current retention mode is identified as the aggressive mode, checking whether used space on backup storage is below a lower threshold;
when the used space is below the lower threshold, switching into the conservative mode;
when the used space is above the lower threshold, remaining in the aggressive mode; and
while in the aggressive mode, selecting a backup chain of the database for pruning, the selected backup chain having a shortest retention term of all backup chains of the database not yet pruned, and not being a latest backup chain of all the backup chains;
identifying log backups of the database in the selected backup chain, the log backups comprising a log file of transactions issued by a client, the transactions having been written from memory to the log file and then committed to the database; and
deleting each log backup of the database in the selected backup chain that has expired regardless of dependency of other backups on an expired log backup.

2. The method of claim 1 further comprising:
repeating the selecting a backup chain for pruning, identifying log backups, and deleting each expired log backup regardless of dependency until the used space capacity is below the lower threshold.

3. The method of claim 1 further comprising:
when the current retention mode is identified as the conservative mode, checking whether used space capacity on the backup storage is above an upper threshold, greater than the lower threshold;
when the used space capacity is above the upper threshold, switching from the conservative mode into the aggressive mode; and
upon the switching into the aggressive mode, performing the selecting a backup chain for pruning, identifying log backups, and deleting each expired log backup regardless of dependency.

4. The method of claim 1 further comprising:
upon switching into the conservative mode, maintaining an expired log backup until all other log backups dependent on the expired log backup have also expired.

5. The method of claim 1 wherein the selected backup chain of the database comprises a single full backup of the database, and a plurality of partial backups of the database.

6. The method of claim 1 wherein the selecting a backup chain further comprises:
comparing a first retention term of a first backup chain to a second retention term of a second backup chain;
determining that the first retention term is less than the second retention term; and
selecting the first backup chain for pruning, the first backup chain thereby being the selected backup chain.

7. A system for managing copy retention for backups of a database, the system comprising: a processor; and memory configured to store one or more sequences of instructions which, when executed by the processor, cause the processor to carry out the steps of:
identifying a current retention mode as being one of a conservative mode or an aggressive mode, wherein the conservative mode preserves expired backup copies on which an unexpired backup depends, and the aggressive mode deletes the expired backup copies on which the unexpired backup copy depends when a plurality of conditions are satisfied;
when the current retention mode is identified as the aggressive mode, checking whether used space on backup storage is below a lower threshold;
when the used space is below the lower threshold, switching into the conservative mode;
when the used space is above the lower threshold, remaining in the aggressive mode; and
while in the aggressive mode, selecting a backup chain of the database for pruning, the selected backup chain having a shortest retention term of all backup chains of the database not yet pruned, and not being a latest backup chain of all the backup chains;
identifying log backups of the database in the selected backup chain, the log backups comprising a log file of transactions issued by a client, the transactions having been written from memory to the log file and then committed to the database; and
deleting each log backup of the database in the selected backup chain that has expired regardless of dependency of other backups on an expired log backup.

8. The system of claim 7 wherein the processor further carries out the steps of:
repeating the selecting a backup chain for pruning, identifying log backups, and deleting each expired log backup regardless of dependency until the used space capacity is below the lower threshold.

9. The system of claim 7 wherein the processor further carries out the steps of:
when the current retention mode is identified as the conservative mode, checking whether used space capacity on the backup storage is above an upper threshold, greater than the lower threshold;
when the used space capacity is above the upper threshold, switching from the conservative mode into the aggressive mode; and
upon the switching into the aggressive mode, performing the selecting a backup chain for pruning, identifying log backups, and deleting each expired log backup regardless of dependency.

10. The system of claim 7 wherein the processor further carries out the steps of:
upon switching into the conservative mode, maintaining an expired log backup until all other log backups dependent on the expired log backup have also expired.

11. The system of claim 7 wherein the selected backup chain of the database comprises a single full backup of the database, and a plurality of partial backups of the database.

12. The system of claim 7 wherein the selecting a backup chain further comprises:
comparing a first retention term of a first backup chain to a second retention term of a second backup chain;
determining that the first retention term is less than the second retention term; and
selecting the first backup chain for pruning, the first backup chain thereby being the selected backup chain.

13. A computer program product, comprising a non-transitory computer-readable medium having a computer-readable program code embodied therein, the computer-readable program code adapted to be executed by one or more processors to implement a method for managing copy retention for backups of a database, the method comprising:
identifying a current retention mode as being one of a conservative mode or an aggressive mode, wherein the conservative mode preserves expired backup copies on which an unexpired backup copy depends, and the aggressive mode deletes the expired backup copies on which the unexpired backup copy depends when a plurality of conditions are satisfied;
when the current retention mode is identified as the aggressive mode, checking whether used space on backup storage is below a lower threshold;
when the used space is below the lower threshold, switching into the conservative mode;
when the used space is above the lower threshold, remaining in the aggressive mode; and
while in the aggressive mode, selecting a backup chain of the database for pruning, the selected backup chain having a shortest retention term of all backup chains of the database not yet pruned, and not being a latest backup chain of all the backup chains;
identifying log backups of the database in the selected backup chain, the log backups comprising a log file of transactions issued by a client, the

Assignees

• Emc Ip Holding Co Llc

Inventors

• Liao mengze
• Quesnelle Scott
• Ugur-Ozekinci Yasemin
• Yan Jin Ru
• Zhu Mike Xiaoliang

Classifications

• G06F11/1448

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

• G06F2201/80

  Database-specific techniques · CPC title

• G06F16/215 Primary

  Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors · CPC title

• G06F11/1451

  by selection of backup contents · CPC title

• G06F2201/81

  Threshold · CPC title