Browse Prior Art Database

Method and System for Intelligent Backup of Standby Copies of a Database

IP.com Disclosure Number: IPCOM000219164D
Publication Date: 2012-Jun-25
Document File: 2 page(s) / 19K

Publishing Venue

The IP.com Prior Art Database

Abstract

A method and system is disclosed for automatic back up of the most up- to-date copy of a database which is available on multiple servers.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 51% of the total text.

Page 01 of 2

Method and System for Intelligent Backup of Standby Copies of a Database

Disclosed is a method and system for automatic back up of the most up-to-date copy of a database which is available on multiple servers.

Generally, a database is equipped with an option to provide one or more standby database copies in order to provide high availability and redundancy. These standby copies can either be kept in sync with the production copy, or intentionally lagged by hours or days to protect against logical corruption.

In accordance with the method and system, a backup agent is associated with each server which has a copy of the database. The backup agents associated with the servers have the ability to communicate with each other to automatically decide which one of their database copies is most appropriate to be backed up. In an exemplary instance, at a specified time, the backup agents negotiate with each other as to which of them is most suited to backup their respective copies of the database. In case a situation arises wherein there is the possibility of sudden loss of data (Recovery Point Objective), the backup agents possessing the most up-to-date copy of the database is automatically backed up. In order to identify which database copy is most up-to-date, a record of when each of the database copies has been logged and applied to create a backup copy of the database is tracked. If all of the database copies are equally up-to-date, then the invention takes into account which one would be come online faster in case of a restore (Recovery Time Objective). That is, the database copy with later applied transaction logs would be selected.

Consider an exemplary implementation of the method for determining most suitable database copy to be backed up. If a backup agent detects that it is running on a primary copy of the database, it automatically backs up...