公开(公告)号：US10191671B2

公开(公告)日：2019-01-29

申请号：US14835507

申请日：2015-08-25

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Andre Kruglikov ,  Kumar Rajamani ,  Jaebock Lee ,  Sanket Jain ,  Giridhar Ravipati

IPC: G06F17/30 ,  G06F3/06 ,  G06F11/14 ,  G06F21/62 ,  G06F12/084 ,  G06F13/16

Abstract: Techniques for common users and roles, and commonly-granted privileges and roles are described. In one approach, the DBMS of a container database allows for the creation of common roles and common users that are shared across the container database. Thus, when a common role or a common user is established, the common role or common user is propagated to each database of the container database. In another approach, the DBMS of a container database allows privileges and roles to be granted commonly or locally. When a privilege or role is granted commonly, the privilege applies in each of the databases of a container database. When a privilege or role is granted locally, the privilege applies only in the database to which the grantor of the privilege or role established a connection.

公开(公告)号：US20180075041A1

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

申请号：US15266340

申请日：2016-09-15

Applicant: Oracle International Corporation

Inventor： Margaret Susairaj ,  Giridhar Ravipati ,  Kumar Rajamani ,  Yunrui Li ,  Jaebock Lee ,  Sanket Jain

IPC: G06F17/30 ,  G06F11/14

Abstract: Techniques are provided for using a sparse file to create a hot archive of a pluggable database of a container database. In an embodiment and while a source pluggable database is in service, a source database server creates a clone of the source pluggable database. Also while the source pluggable database is in service, the source database server creates an archive of the source pluggable database that is based on the clone. Eventually, a need arises to consume the archive. A target database server (which may also be the source database server) creates a target pluggable database based on the archive.

公开(公告)号：US20170116435A1

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

申请号：US15244395

申请日：2016-08-23

Applicant: Oracle International Corporation

Inventor： Prashanth Shanthaveerappa ,  Sanket Jain ,  Kumar Rajamani ,  Andre Kruglikov

IPC: G06F21/62 ,  G06F17/30

CPC classification number: G06F21/6227 ,  G06F16/21 ,  G06F16/2255 ,  G06F16/24552 ,  G06F16/256 ,  G06F21/00 ,  G06F21/62

Abstract: Techniques are described herein for allowing a container DBMS to impose restrictions, on a per-pluggable-database basis, on operations based on the pluggable database to which the users that request the operations belong. In one embodiment, lockdown profiles can be created and mapped to pluggable databases. Lockdown profiles specify PDB-wide restrictions on operations. The restrictions may apply to all operations of a given type, may apply to specific features, may require use of specific parameter values, etc. All users that belong to a pluggable database are restricted by the restrictions specified in the lockdown profile to which their pluggable database is mapped, unless the lockdown profile has a user-specific exemption for them. Bitmaps and/or hash tables may be used to more quickly determine, at query runtime, whether a query violates any profile-specified restrictions. Execution of queries that violate any profile-specified restrictions is prevented.

公开(公告)号：US20170116249A1

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

申请号：US15215435

申请日：2016-07-20

Applicant: Oracle International Corporation

Inventor： Giridhar Ravipati ,  Kumar Rajamani ,  Yunrui Li ,  Jaebock Lee ,  Sanket Jain

IPC: G06F17/30

CPC classification number: G06F16/27 ,  G06F11/14 ,  G06F11/1469 ,  G06F16/119 ,  G06F16/13 ,  G06F16/178 ,  G06F16/214 ,  G06F16/2358 ,  G06F16/2365 ,  G06F16/273 ,  G06F2201/84

Abstract: Embodiments create a clone of a PDB while the PDB accepts write operations. While the PDB remains in read-write mode, the DBMS copies the data of the PDB and sends the data to a destination location. The DBMS performs data recovery on the PDB clone based on redo entries that record changes made to the source PDB while the DBMS copied the source PDB files. This data recovery makes all changes, to the PDB clone, that occurred to the source PDB during the copy operation. The redo information, on which the data recovery is based, is foreign to the PDB clone since the redo entries were recorded for a different PDB. In order to apply foreign redo information to perform recovery on the PDB clone, a DBMS managing the PDB clone maintains mapping information that maps PDB source reference information to corresponding information for the PDB clone.

公开(公告)号：US20170116207A1

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

申请号：US15215446

申请日：2016-07-20

Applicant: Oracle International Corporation

Inventor： Jaebock Lee ,  Kumar Rajamani ,  Sanket Jain ,  Giridhar Ravipati

IPC: G06F17/30

CPC classification number: G06F16/27 ,  G06F11/14 ,  G06F11/1469 ,  G06F16/119 ,  G06F16/13 ,  G06F16/178 ,  G06F16/214 ,  G06F16/2358 ,  G06F16/2365 ,  G06F16/273 ,  G06F2201/84

Abstract: Embodiments minimize downtime involved in moving a PDB between CDBs by allowing read-write access to the PDB through most of the moving operation, and by transparently forwarding connection requests, for the PDB, from the source CDB to the destination CDB. The files of a source PDB are copied from a source CDB to a destination CDB, during which the source PDB may be in read-write mode. The source PDB is then closed to write operations so that changes to the source PDB cease. Another round of recovery is performed on the PDB clone, which applies all changes that have been performed on the source PDB during the copy operation and the PDB clone is opened for read and write operations. Forwarding information is registered with the source location, which information is used to automatically forward connection requests, received at the source location for the moved PDB, to the destination location.

公开(公告)号：US09396220B2

公开(公告)日：2016-07-19

申请号：US14202091

申请日：2014-03-10

Applicant: Oracle International Corporation

Inventor： Yunrui Li ,  Kumar Rajamani ,  Giridhar Ravipati ,  Chi Cao Minh ,  Jaebock Lee ,  Sanket Jain ,  Jonghyun Lee

IPC: G06F17/30

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

Abstract: A pluggable database is transported between a source DBMS and a destination DBMS, in a way that minimizes downtime of the pluggable database. While a copy of the pluggable database is being made at the destination DBMS, transactions continue to execute against the pluggable database at the source DBMS and change the pluggable database. Eventually, the transactions terminate or cease executing. Redo records generated for the transactions are applied to the copy of the pluggable database at the source DBMS. Undo records generated for at least some of the transactions may be stored in a separate undo log and transported to the destination DBMS. The transported pluggable database is synchronized at a destination DBMS in a “pluggable-ready state”, where it may be plugged into the destination container DBMS.

Abstract translation: 可插拔数据库在源DBMS和目标DBMS之间传输，从而最大限度地减少可插拔数据库的停机时间。 虽然目标DBMS正在进行可插拔数据库的副本，但是事务将继续针对源DBMS上的可插拔数据库执行，并更改可插拔数据库。 最终，交易终止或停止执行。 为事务生成的重做记录应用于源DBMS的可插拔数据库的副本。 至少为某些事务生成的撤销记录可以存储在单独的撤销日志中，并传送到目标DBMS。 传输的可插拔数据库在目标DBMS上以“可插拔就绪状态”进行同步，可以插入到目标容器DBMS中。

公开(公告)号：US20240069779A1

公开(公告)日：2024-02-29

申请号：US17893656

申请日：2022-08-23

Applicant: Oracle International Corporation

Inventor： Harsha Vardhan NHS ,  Hochak Hung ,  Rahul Manohar Kadwe ,  Uday Kiran Jangolla ,  Kumar Rajamani

IPC: G06F3/06

CPC classification number: G06F3/065 ,  G06F3/0614 ,  G06F3/0679

Abstract: Techniques are provided for synchronizing database system metadata between primary and standby persistent storage systems using an object store. A first persistent storage system enabled to store first configuration metadata describing the configuration of the first persistent storage system. A first broker process of the first persistent storage system detects receipt, at an object store endpoint, of a new version of an object message sent by a second broker process of a second persistent storage system. The object message specifies a particular value of a configuration attribute of second configuration metadata from the second persistent storage system. In response to detecting receipt of the new version of the object message, the first broker process reads the particular value of the configuration attribute in the object message. The first broker process sets the configuration attribute in the first configuration metadata to the particular value.

公开(公告)号：US11416495B2

公开(公告)日：2022-08-16

申请号：US17090732

申请日：2020-11-05

Applicant: Oracle International Corporation

Inventor： Jaebock Lee ,  Kumar Rajamani ,  Sanket Jain ,  Giridhar Ravipati

IPC: G06F16/00 ,  G06F16/2455 ,  G06F16/172 ,  G06F16/25 ,  G06F16/21 ,  G06F16/27 ,  G06F16/11 ,  G06F16/178 ,  G06F16/23 ,  G06F16/13

Abstract: Embodiments minimize downtime involved in moving a PDB between CDBs by allowing read-write access to the PDB through most of the moving operation, and by transparently forwarding connection requests, for the PDB, from the source CDB to the destination CDB. The files of a source PDB are copied from a source CDB to a destination CDB, during which the source PDB may be in read-write mode. The source PDB is then closed to write operations so that changes to the source PDB cease. Another round of recovery is performed on the PDB clone, which applies all changes that have been performed on the source PDB during the copy operation and the PDB clone is opened for read and write operations. Forwarding information is registered with the source location, which information is used to automatically forward connection requests, received at the source location for the moved PDB, to the destination location.

公开(公告)号：US10803078B2

公开(公告)日：2020-10-13

申请号：US15331534

申请日：2016-10-21

Applicant: Oracle International Corporation

Inventor： Sanket Jain ,  Kumar Rajamani ,  Giridhar Ravipati ,  Jaebock Lee

IPC: G06F16/00 ,  G06F16/25 ,  G06F16/27 ,  G06F16/951 ,  G06F16/21 ,  G06F3/06 ,  G06F9/455

Abstract: In an approach, a database management system is configured in a manner that allows all pluggable databases within a cluster to be treated, from the perspective of a user, as though stored on a single container database, even when the pluggable databases are distributed across a plurality of container databases. When a command is received by a database server that is to be executed on all or a subset of the pluggable databases within the cluster, the database inspects mapping information replicated on all container databases within the cluster by a cluster synchronization server to determine which container databases store pluggable databases implicated by the command. The command is then forwarded to the database servers responsible for the determined container databases for execution. As a result, the commands issued by the user can be agnostic in regard to the actual location of the pluggable databases within the cluster.

公开(公告)号：US10789131B2

公开(公告)日：2020-09-29

申请号：US15254884

申请日：2016-09-01

Applicant: Oracle International Corporation

Inventor： Kumar Rajamani ,  Muthu Olagappan ,  Yunrui Li ,  Giridhar Ravipati ,  Jing Zheng

IPC: G06F11/14 ,  G06F16/27

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.