公开(公告)号：US09563655B2

公开(公告)日：2017-02-07

申请号：US13791517

申请日：2013-03-08

Applicant: Oracle International Corporation

Inventor： Jin-Jwei Chen ,  Benedicto Elmo Garin, Jr. ,  Mahesh Baburao Girkar ,  Raymond Guzman

IPC: G06F17/30

CPC classification number: G06F17/30371 ,  G06F17/30368 ,  G06F17/30575

Abstract: 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.

Abstract translation: 一种用于低损失数据库备份和恢复的方法，系统和计算机程序产品。 该方法通过由第一服务器向第三服务器发送数据库快照备份的副本，该传输从第一次开始。 然后，由第一台服务器捕获数据库重做数据流，捕获在发送数据库快照备份之前或之后开始，并持续至第三次。 数据库重做数据流由中间服务器接收，中间服务器将数据库重做数据流发送到第三个服务器。 现在，第三台服务器具有数据库快照备份和数据库重做数据。 第三台服务器可以向第四台服务器发送要应用于数据库快照备份副本的全部或部分数据库重做数据，以恢复其中的数据库快照备份，以创建还原的数据库。

公开(公告)号：US09910736B2

公开(公告)日：2018-03-06

申请号：US14588149

申请日：2014-12-31

Applicant: Oracle International Corporation

Inventor： Steven Wertheimer ,  Muthu Olagappan ,  Raymond Guzman ,  William Fisher ,  Beldalker Anand ,  Sriram Nagaraja Rao ,  Chris Plakyda ,  Debjyoti Roy ,  Senad Dizdar

IPC: G06F17/30 ,  G06F11/14

CPC classification number: G06F11/1451 ,  G06F11/14 ,  G06F11/1453 ,  G06F11/1464 ,  G06F11/1469 ,  G06F17/30575 ,  G06F2201/815 ,  G06F2201/84

Abstract: According to embodiments described herein, a backup server maintains backup data for a set of data, which includes data for a first block and a second block. Backup data for the first and second block include backup data for a plurality of versions of the first and second block. A distinct watermark is stored for each version of the first block and each version of the second block. In response to a request to perform a restoration operation on the set of data, a particular version of the first block and a particular version of the second block are selected to use in the restoration operation by comparing a restoration target with the watermarks of the version of the first block and second block. The selected version of the first block has a different watermark than the selected version of the second block.

公开(公告)号：US20150254141A1

公开(公告)日：2015-09-10

申请号：US14202433

申请日：2014-03-10

Applicant: Oracle International Corporation

Inventor： Steven Wertheimer ,  Raymond Guzman ,  Muthu Olagappan ,  William Fisher ,  Vladimir Begun ,  Sriram Nagaraja Rao ,  Beldalker Anand

IPC: G06F11/14 ,  G06F17/30

CPC classification number: G06F11/1451 ,  G06F11/1456 ,  G06F11/1461 ,  G06F17/30312 ,  G06F2201/80

Abstract: A method, apparatus, and system for centralized tape management are provided for databases. A centralized availability machine or disk and tape backup server maintains working backup data for a plurality of database management systems (DBMSs) based on receiving, from each of the plurality of DBMSs, differential incremental updates. The updates may be at the database block level, with an index maintained to identify different versions of the blocks for snapshot recovery. The availability machine then determines a utilization schedule for distributing the working backup data to a plurality of tapes using a plurality of tape drives, and stores the working backup data as archived backup data on the plurality of tapes according to the utilization schedule. By placing each DBMS within a protection policy that indicates criteria to meet business goals with respect to tape backups, the utilization schedule can automatically schedule tape backup jobs with optimized hardware resource assignments.

Abstract translation: 为数据库提供集中磁带管理的方法，装置和系统。 基于从多个DBMS中的每一个接收差分增量更新，集中可用性机器或磁盘和磁带备份服务器为多个数据库管理系统（DBMS）维护工作备份数据。 这些更新可能在数据库块级别，维护索引以标识用于快照恢复的块的不同版本。 可用性机器然后确定使用多个磁带驱动器将工作备份数据分发到多个磁带的利用率计划，并且根据利用调度将工作备份数据作为归档备份数据存储在多个磁带上。 通过将每个DBMS放置在保护策略中，指示符合磁带备份的业务目标的标准，利用率计划可以通过优化的硬件资源分配自动安排磁带备份作业。

公开(公告)号：US09612912B2

公开(公告)日：2017-04-04

申请号：US14202433

申请日：2014-03-10

Applicant: Oracle International Corporation

Inventor： Steven Wertheimer ,  Raymond Guzman ,  Muthu Olagappan ,  William Fisher ,  Vladimir Begun ,  Sriram Nagaraja Rao ,  Beldalker Anand

IPC: G06F17/00 ,  G06F11/14 ,  G06F17/30

CPC classification number: G06F11/1451 ,  G06F11/1456 ,  G06F11/1461 ,  G06F17/30312 ,  G06F2201/80

Abstract: A method, apparatus, and system for centralized tape management are provided for databases. A centralized availability machine or disk and tape backup server maintains working backup data for a plurality of database management systems (DBMSs) based on receiving, from each of the plurality of DBMSs, differential incremental updates. The updates may be at the database block level, with an index maintained to identify different versions of the blocks for snapshot recovery. The availability machine then determines a utilization schedule for distributing the working backup data to a plurality of tapes using a plurality of tape drives, and stores the working backup data as archived backup data on the plurality of tapes according to the utilization schedule. By placing each DBMS within a protection policy that indicates criteria to meet business goals with respect to tape backups, the utilization schedule can automatically schedule tape backup jobs with optimized hardware resource assignments.

公开(公告)号：US20150178169A1

公开(公告)日：2015-06-25

申请号：US14588149

申请日：2014-12-31

Applicant: Oracle International Corporation

Inventor： Steven Wertheimer ,  Muthu Olagappan ,  Raymond Guzman ,  William Fisher ,  Beldalker Anand ,  Sriram Nagaraja Rao ,  Chris Plakyda ,  Debjyoti Roy ,  Senad Dizdar

IPC: G06F11/14

CPC classification number: G06F11/1451 ,  G06F11/14 ,  G06F11/1453 ,  G06F11/1464 ,  G06F11/1469 ,  G06F17/30575 ,  G06F2201/815 ,  G06F2201/84

Abstract: According to embodiments described herein, a backup server maintains backup data for a set of data, which includes data for a first block and a second block. Backup data for the first and second block include backup data for a plurality of versions of the first and second block. A distinct watermark is stored for each version of the first block and each version of the second block. In response to a request to perform a restoration operation on the set of data, a particular version of the first block and a particular version of the second block are selected to use in the restoration operation by comparing a restoration target with the watermarks of the version of the first block and second block. The selected version of the first block has a different watermark than the selected version of the second block.

Abstract translation: 根据本文描述的实施例，备份服务器维护一组数据的备份数据，其包括用于第一块和第二块的数据。 用于第一和第二块的备份数据包括用于第一和第二块的多个版本的备份数据。 存储第一块的每个版本和第二块的每个版本的不同水印。 响应于对该组数据执行恢复操作的请求，通过将恢复目标与版本的水印进行比较来选择第一块的特定版本和第二块的特定版本以用于恢复操作 的第一块和第二块。 所选择的版本的第一块具有与所选择的第二块版本不同的水印。