Intelligent log gap detection to ensure necessary backup promotion
AssigneeEMC IP Holding Company LLC
InventorsKrishnendu Bagchi, Shelesh Chopra, Bharat Bhushan
Life of this patent
Estimating the term…
Abstract
An intelligent log gap detection to ensure necessary backup promotion. Specifically, a method and system are disclosed, which entail determining whether to pursue a differential database backup or promote the differential database backup to a full database backup, in order to preclude data loss across high availability databases. The deduction pivots on a matching or mismatching between log sequence numbers (LSNs).
Claims20
A method for intelligent log gap detection, comprising:
- receiving a first database backup request for a first differential 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;
- making a second determination that the checkpoint LSN mismatches a first differential base LSN (DBL);
- detecting, based on the second determination, a log gap across the DAC;
- and
- promoting, based on the detecting the log gap, the first differential database backup to a second full database backup.
A system, comprising:
- a cluster backup service (CBS) programmed to:
- receive a database backup request specifying performance of a first differential 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;
- make a second determination that the checkpoint LSN mismatches a differential base LSN (DBL);
- detect, based on the second determination, a log gap across the DAC;
- and
- promote, based on detecting the log gap, the first differential 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 specifying performance of a first differential 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;
- make a second determination that the checkpoint LSN mismatches a first differential base LSN (DBL);
- detect, based on the second determination, a log gap across the DAC;
- and
- promote, based on detecting the log gap, the first differential database backup to a second full database backup.
Dependencies are inferred from the claim text.