Synchronized Backup and Recovery of Database Systems

摘要

Disclosed herein are system, method, and computer program product embodiments for utilizing a backup catalog to perform synchronized backup and recovery of heterogeneous database systems. An embodiment operates by performing a global data backup of a heterogeneous database system comprising a first database management system (DBMS) at a first server and a second DBMS at a second server and recording a global data backup entry identifying the global data backup into a backup catalog. Upon receiving log backup notifications regarding asynchronous log backups on the first server and the second server, log backup entries identifying the asynchronous log backups are recorded into the backup catalog. To successfully perform a point-in-time recovery, the embodiment operates by using the backup catalog to identify data and log backups required for the recovery of the first and second servers to a recovery timestamp associated with the point-in-time recovery.

主权项

1. A method, comprising:
first performing a global data backup of a heterogeneous database system comprising a first database management system (DBMS) at a first server and a second DBMS at a second server; first recording a global data backup entry and data backup information associated with the global data backup into a backup catalog; receiving log backup notifications regarding asynchronous log backups on the first server and the second server; second recording log backup entries and log backup information associated with the log backup notifications into the backup catalog; and second performing a point-in-time recovery of the heterogeneous database system using the backup catalog, wherein at least one of the first performing, first recording, receiving, second recording, and second performing are performed by one or more computers.