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, in a backup catalog, one or more global data backup entries representative of the global data backup performed by the first and second DBMS on the respective first and second servers; receiving log backup notifications, from the first and second servers, indicating asynchronous log backups performed on the first server and the second server; second recording, in the backup catalog, log backup entries representative of the performed asynchronous log backups, in response to receiving the log backup notifications; 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.