Zero and near-zero data loss database backup and recovery

摘要

A method, system and computer program product for low loss database backup and recovery. The method commences by transmitting, by a first server to a third server, a copy of a database snapshot backup, the transmitting commencing at a first time. Then capturing, by the first server, a stream of database redo data, the capturing commencing before or upon transmitting the database snapshot backup, and continuing until a third time. The stream of database redo data is received by an intermediate server after which the intermediate server transmits the stream of database redo data to the third server. Now, the third server has the database snapshot backups and the database redo data. The third server can send to a fourth server all or portion of the database redo data to be applied to the copy of the database snapshot backup restored there to create a restored database.

主权项

1. A computer implemented method for database backup and recovery of database transactions, the method comprising:
transmitting, from a first server to a backup server, backup copies of a database of the first server, the backup copies comprising one or more full backups and one or more incremental backups, wherein the one or more full backups are interval-spaced full images of the database at the first server and the one or more incremental backups are incremental images of the database that are provided to the backup server at various periodic intervals; storing the backup copies in a storage facility of the backup server rather than maintaining the database of first server itself at the backup server; transmitting database redo data from the first server to an intermediate server or the backup server prior to committing a database transaction at the first server, wherein the database redo data represent changes to the database corresponding to a database transaction at the first server, and wherein if the database redo data is transmitted to the intermediate server, the intermediate server transmits the database redo data to the backup server; storing the transmitted database redo data in at least the intermediate server or the backup server; receiving an acknowledgment from the intermediate server or the backup server to the first server,
wherein the acknowledgement, if received from the intermediate server, indicates: (a) receipt of the database redo data from the first server at the intermediate server and (b) storage of the database redo data in a storage facility at the intermediate server,wherein the acknowledgement, if received from the backup server, indicates: (a) receipt of the database redo data from the first server at the backup server and (b) storage of the database redo data in a storage facility at the backup server; identifying a series of redo data records from the one or more redo data stored at the backup server after receipt of the transmitted database redo data from the intermediate server or the first server at the backup server, wherein the series of redo data records capture changes to the database at the first server after specific points in time in which the one or more full backups and the one or more incremental backups capture a state of the database; and generating a restored database at a destination server different from the backup server using at least one of the backup copies of the database at the backup server along with the series of redo data records via communication with the backup server.