-
公开(公告)号：US10789131B2
公开(公告)日：2020-09-29
申请号：US15254884
申请日：2016-09-01
Applicant: Oracle International Corporation
Inventor： Kumar Rajamani , Muthu Olagappan , Yunrui Li , Giridhar Ravipati , Jing Zheng
Abstract: Techniques are provided for creating a backup of a source pluggable database (SPD) of a source container database and porting the backup for recovery into a different target container database. In an embodiment, a source database server retrieves metadata that describes backups of the SPD. The source database server inserts, into an unplugged pluggable database of the SPD, the metadata that describes each of the backups. For example, unplugging the SPD may automatically create the unplugged pluggable database. Eventually, the unplugged pluggable database may be plugged into the target container database. A target database server transfers the metadata that describes each of the backups from the unplugged pluggable database and into the target container database. Based on at least one backup and the metadata that describes backups of the SPD, the target database server restores a target pluggable database within the target container database.
-
公开(公告)号：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
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.
-
公开(公告)号：US09298564B2
公开(公告)日：2016-03-29
申请号：US13830349
申请日：2013-03-14
Applicant: ORACLE INTERNATIONAL CORPORATION
Inventor： J. William Lee , Vipin Gokhale , Muthu Olagappan , Sanket Hase , Vivekanandhan Raja , Michael John Skarpelos , Michael Stewart
CPC classification number: G06F3/0619 , G06F3/065 , G06F3/067 , G06F11/1448 , G06F11/1469 , G06F11/1471 , G06F12/084 , G06F13/1663 , G06F17/30289 , G06F17/30292 , G06F17/3048 , G06F17/30557 , G06F17/30566 , G06F17/30595 , G06F17/30867 , G06F21/6218 , G06F2201/80 , G06F2201/835 , G06F2212/60 , G06F2212/62
Abstract: In an approach, a database server maintains a container database which comprises: one or more pluggable databases, a root database that stores an undo log for rolling back transactions on the consolidated database, and a redo log for replaying modifications to the container database. The database server restores a particular pluggable with a backup version that corresponds to a first point in time. The database server generates a clone database loaded with a backup version of the root database that corresponds to the first point in time. The database server applies the redo log to recover the particular pluggable database and the clone database to a second point in time that is later than the first point in time. The database server identifies, based on the clone database, one or more active transactions on the particular pluggable database. The database server rolls back the one or more active transactions.
Abstract translation: 在一种方法中，数据库服务器维护一个容器数据库，它包括：一个或多个可插拔数据库，存储用于在统一数据库上回滚事务的撤销日志的根数据库，以及重播对容器数据库的修改的重做日志。 数据库服务器使用与第一个时间点对应的备份版本恢复特定的可插拔。 数据库服务器生成加载有与第一个时间点相对应的根数据库的备份版本的克隆数据库。 数据库服务器应用重做日志将特定的可插拔数据库和克隆数据库恢复到晚于第一个时间点的第二个时间点。 数据库服务器根据克隆数据库识别特定可插拔数据库上的一个或多个活动事务。 数据库服务器回滚一个或多个活动事务。
-
公开(公告)号：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: 根据本文描述的实施例，备份服务器维护一组数据的备份数据，其包括用于第一块和第二块的数据。 用于第一和第二块的备份数据包括用于第一和第二块的多个版本的备份数据。 存储第一块的每个版本和第二块的每个版本的不同水印。 响应于对该组数据执行恢复操作的请求，通过将恢复目标与版本的水印进行比较来选择第一块的特定版本和第二块的特定版本以用于恢复操作 的第一块和第二块。 所选择的版本的第一块具有与所选择的第二块版本不同的水印。
-
公开(公告)号：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
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.
-
Patent Agency Ranking
公开(公告)号：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
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放置在保护策略中，指示符合磁带备份的业务目标的标准，利用率计划可以通过优化的硬件资源分配自动安排磁带备份作业。
-
公开(公告)号：US11669411B2
公开(公告)日：2023-06-06
申请号：US17113091
申请日：2020-12-06
Applicant: Oracle International Corporation
Inventor： Giridhar Ravipati , Yunrui Li , Kumar Rajamani , Muthu Olagappan
CPC classification number: G06F11/1469 , G06F11/1464 , G06F11/1471 , G06F2201/80
Abstract: A computer program product, system, and computer implemented method for management of a consolidated database and implementing pluggable database recovery with redo filtering in a consolidated database according to some embodiments. Generally, the process includes ongoing activities that maintain activity logs and summarize the activity for respective activity logs (e.g., in an activity vector maintained in a consolidated database catalog). In some embodiments, event-based activities corresponding to recovery processes are triggered by an administrator or an automated process, completed and then do not occur again until another triggering event. The event-based activities can leverage the summary information to quickly determine which online activity logs are relevant to the type of recovery operation for a particular pluggable database. In this way the approach provided herein enables recovery without requiring that all log activity be analyzed to determine whether it is relevant to a particular pluggable database.
-
公开(公告)号：US10915549B2
公开(公告)日：2021-02-09
申请号：US15215443
申请日：2016-07-20
Applicant: Oracle International Corporation
Inventor： Giridhar Ravipati , Kumar Rajamani , Yunrui Li , Muthu Olagappan , Jaebock Lee , Sanket Jain
Abstract: Embodiments incrementally refresh a clone of a source PDB while the source PDB accepts write operations. Specifically, refreshing the PDB clone incorporates changes made to the source PDB since a refresh reference time stamp, which marks the time at which the PDB clone was created or, if the PDB clone has been previously refreshed, the time at which the PDB clone was last refreshed. A PDB clone is incrementally refreshed by incorporating, into the PDB clone data, those source data blocks that have changed since the refresh reference time stamp. Recovery is performed on the PDB clone, once the blocks are copied, to apply any changes made to the source PDB while the blocks were being copied, which recovery makes the PDB clone files consistent. This recovery is based on redo entries recorded for the source PDB during the time it took to copy the blocks to the PDB clone.
-
公开(公告)号：US20200026609A9
公开(公告)日：2020-01-23
申请号：US15254884
申请日：2016-09-01
Applicant: Oracle International Corporation
Inventor： Kumar Rajamani , Muthu Olagappan , Yunrui Li , Giridhar Ravipati , Jing Zheng
Abstract: Techniques are provided for creating a backup of a source pluggable database (SPD) of a source container database and porting the backup for recovery into a different target container database. In an embodiment, a source database server retrieves metadata that describes backups of the SPD. The source database server inserts, into a unplugged pluggable database of the SPD, the metadata that describes each of the backups. For example, unplugging the SPD may automatically create the unplugged pluggable database. Eventually, the unplugged pluggable database may be plugged into the target container database. A target database server transfers the metadata that describes each of the backups from the unplugged pluggable database and into the target container database. Based on at least one backup and the metadata that describes backups of the SPD, the target database server restores a target pluggable database within the target container database.
-
公开(公告)号：US20180060181A1
公开(公告)日：2018-03-01
申请号：US15254884
申请日：2016-09-01
Applicant: Oracle International Corporation
Inventor： Kumar Rajamani , Muthu Olagappan , Yunrui Li , Giridhar Ravipati , Jing Zheng
Abstract: Techniques are provided for creating a backup of a source pluggable database (SPD) of a source container database and porting the backup for recovery into a different target container database. In an embodiment, a source database server retrieves metadata that describes backups of the SPD. The source database server inserts, into a unplugged pluggable database of the SPD, the metadata that describes each of the backups. For example, unplugging the SPD may automatically create the unplugged pluggable database. Eventually, the unplugged pluggable database may be plugged into the target container database. A target database server transfers the metadata that describes each of the backups from the unplugged pluggable database and into the target container database. Based on at least one backup and the metadata that describes backups of the SPD, the target database server restores a target pluggable database within the target container database.
-
-
-
-
-
-
-
-
-
Search Results
12
records
(took 0.016 seconds)
