Intelligent log gap detection to prevent unnecessary backup promotion
AssigneeEMC IP Holding Company LLC
InventorsKrishnendu Bagchi, Shelesh Chopra
Life of this patent
Estimating the term…
Abstract
An intelligent log gap detection to prevent unnecessary backup promotion. Specifically, the method and system disclosed herein entail determining whether to pursue a requested database backup type or to promote the requested database backup type to another database backup type, in order to preclude data loss across high availability databases. When a decision is made to pursue the requested database backup type, storage space, intended for backup consolidation on a backup system or media, is saved for future backup requests rather than being consumed as would be the case would the requested database backup type had been promoted.
Claims20
A method for intelligent log gap detection, comprising:
- receiving a first database backup request for a first database backup on a database availability cluster (DAC);
- making a first determination that a first full database backup has already been performed;
- obtaining, based on the first determination, a checkpoint log sequence number (LSN) associated with the first full database backup;
- identifying at least a second database backup that depends from the first full database backup;
- identifying a latest database backup from the at least second database backup;
- obtaining a last LSN associated with the latest database backup;
- making a second determination that the last LSN mismatches a first last log backup LSN (LLBL);
- detecting, based on the second determination, a log gap across the DAC;
- and
- promoting, based on detecting the log gap, the first database backup to a second full database backup.
A system, comprising:
- a cluster backup service (CBS) programmed to:
- receive a first database backup request for a first database backup on a database availability cluster (DAC);
- make a first determination that a first full database backup has already been performed;
- obtain, based on the first determination, a checkpoint log sequence number (LSN) associated with the first full database backup;
- identify at least a second database backup that depends from the first full database backup;
- identify a latest database backup from the at least second database backup;
- obtain a last LSN associated with the latest database backup;
- make a second determination that the last LSN mismatches a first last log backup LSN (LLBL);
- a
- detect, based on the second determination, a log gap across the DAC;
- and
- promote, based on detecting the log gap, the first database backup to a second full database backup.
A non-transitory computer readable medium (CRM) comprising computer readable program code, which when executed by a computer processor, enables the computer processor to:
- receive a first database backup request for a first database backup on a database availability cluster (DAC);
- make a first determination that a first full database backup has already been performed;
- obtain, based on the first determination, a checkpoint log sequence number (LSN) associated with the first full database backup;
- identify at least a second database backup that depends from the first full database backup;
- identify a latest database backup from the at least second database backup;
- obtain a last LSN associated with the latest database backup;
- make a second determination that the last LSN mismatches a first last log backup LSN (LLBL);
- detect, based on the second determination, a log gap across the DAC;
- and
- promote, based on detecting the log gap, the first database backup to a second full database backup.
Dependencies are inferred from the claim text.