公开(公告)号：US10891291B2

公开(公告)日：2021-01-12

申请号：US15339525

申请日：2016-10-31

Applicant: Oracle International Corporation

Inventor： Yunrui Li ,  Kumar Rajamani

IPC: G06F16/2453 ,  G06F16/951 ,  G06F16/2458 ,  G06F16/23 ,  G06F16/22 ,  G06F16/27 ,  G06F16/25

Abstract: A refreshable PDB clone is associated with a PDB-specific logical timestamp (LT) service that continuously reflects the LT of the most recent changes that have fully committed within the PDB clone during a refresh operation. Such an LT service is used to perform queries over the changing data in the PDB clone while the PDB clone is undergoing a refresh operation. Furthermore, a PDB-specific LT service can facilitate write operations in a standby CDB, where the standby CDB is a physical standby of a source CDB. Specifically, a standby CDB is configured with a private read-write PDB that does not replicate data from the source CDB. This private PDB may accommodate a write operation required by a query over data in the standby CDB. A PDB-specific LT service provides LTs for such a private PDB where the PDB-specific LT service provides LTs to order changes made within the private PDB.

公开(公告)号：US20200026774A9

公开(公告)日：2020-01-23

申请号：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.

公开(公告)号：US20180060177A1

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

申请号：US15244867

申请日：2016-08-23

Applicant: Oracle International Corporation

Inventor： Prashanth Shanthaveerappa ,  Giridhar Ravipati ,  Margaret Susairaj ,  Kumar Rajamani

IPC: G06F11/14 ,  G06F17/30

Abstract: Techniques herein make and use a pluggable database archive file (AF). In an embodiment, a source database server of a source container database (SCD) inserts contents into an AF from a source pluggable database (SPD). The contents include data files from the SPD, a listing of the data files, rollback scripts, and a list of patches applied to the SPD. A target database server (TDS) of a target container database (TCD) creates a target pluggable database (TPD) based on the AF. If a patch on the list of patches does not exist in the TCD, the TDS executes the rollback scripts to adjust the TPD. In an embodiment, the TDS receives a request to access a block of a particular data file. The TDS detects, based on the listing of the data files, a position of the block within the AF. The TDS retrieves the block based on the position.

公开(公告)号：US20170116213A1

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

申请号：US15093506

申请日：2016-04-07

Applicant: Oracle International Corporation

Inventor： Sanket Jain ,  Kumar Rajamani ,  Jaebock Lee ,  Nicolas Michael ,  Yixiao Shen ,  Giridhar Ravipati

IPC: G06F17/30

CPC classification number: G06F16/24566 ,  G06F16/172 ,  G06F16/214 ,  G06F16/258

Abstract: Embodiments provide a migration instruction that effectuates the migration of a pluggable database from a source database server instance to a destination database server instance. Upon receiving the migration instruction, the migrating pluggable database is opened at the destination instance. Connections are terminated at the source instance at a rate that is determined based on statistics maintained for one or more of: the migrating pluggable database, the source instance, the destination instance, a container database, etc. Furthermore, once the migration instruction is received, a certain amount of time is provided before the source instance flushes the dirty buffers for the migrating pluggable database from the buffer cache of the source instance. The delay in flushing dirty buffers from buffer cache allows the source instance to provide data blocks, of the migrating pluggable database, directly to the destination database server instance from the cache.

公开(公告)号：US20140095546A1

公开(公告)日：2014-04-03

申请号：US13841272

申请日：2013-03-15

Applicant: ORACLE INTERNATIONAL CORPORATION

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

IPC: G06F21/62

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

Abstract translation: 描述了普通用户和角色的技术以及常用权限和角色。 在一种方法中，容器数据库的DBMS允许创建跨容器数据库共享的常见角色和通用用户。 因此，当建立常见角色或公共用户时，常见角色或普通用户将被传播到容器数据库的每个数据库。 在另一种方法中，容器数据库的DBMS允许通常或本地授予权限和角色。 通常授予特权或角色时，特权将应用于容器数据库的每个数据库。 当本地授予特权或角色时，权限仅适用于权限或角色的授予人建立连接的数据库。

公开(公告)号：US20210081355A1

公开(公告)日：2021-03-18

申请号：US17003630

申请日：2020-08-26

Applicant: Oracle International Corporation

Inventor： Todd A. Bottger ,  Hochak Hung ,  Kumar Rajamani

IPC: G06F16/11 ,  H04L29/08 ,  G06F16/16

Abstract: Techniques described herein automatically check for persistently inactive instances, based on defined metrics, and auto-archive such instances to lower-cost cloud resources. An inactivity time threshold is dynamically adjustable to a longer or shorter time period based on current load running on limited/more expensive resources to more aggressively or less aggressively archive the inactive instances, thus enabling additional active instances to run on the limited/more expensive resources and supporting more total users.

公开(公告)号：US20210056123A1

公开(公告)日：2021-02-25

申请号：US17090732

申请日：2020-11-05

Applicant: Oracle International Corporation

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

IPC: G06F16/27 ,  G06F16/13 ,  G06F16/11 ,  G06F16/178 ,  G06F16/23

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.

公开(公告)号：US10860237B2

公开(公告)日：2020-12-08

申请号：US14313926

申请日：2014-06-24

Applicant: Oracle International Corporation

Inventor： Margaret Susairaj ,  Sumanta Chatterjee ,  Kumar Rajamani

IPC: G06F3/06 ,  G06F16/11 ,  G06F16/27

Abstract: Techniques are described herein for cloning a database. According to some embodiments, a database server receives a request to clone a source database. In response to receiving the request, the database server retrieves a set of one or more storage credentials for a set of one or more respective storage systems on which a set of files of the source database are stored. The set of storage credentials grant permission to the database server to create snapshot copies on the set of storage systems. The database server generates, for a target database using the set of storage credentials, a snapshot copy of each respective file in the set of files of the source database. The snapshot copy of the respective file points to the same set of one or more data blocks as the respective file until at least one of the data blocks is modified.

公开(公告)号：US10733316B2

公开(公告)日：2020-08-04

申请号：US15244395

申请日：2016-08-23

Applicant: Oracle International Corporation

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

IPC: G06F16/21 ,  G06F21/62 ,  G06F16/22 ,  G06F16/2455 ,  G06F21/00 ,  G06F16/25

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.

公开(公告)号：US20190278856A9

公开(公告)日：2019-09-12

申请号：US15266917

申请日：2016-09-15

Applicant: Oracle International Corporation

Inventor： Philip Yam ,  Thomas Baby ,  Andre Kruglikov ,  Kumar Rajamani

IPC: G06F17/30 ,  G06F11/14

Abstract: Techniques are provided for diverting, to cloned metadata, live access to original metadata of an application container that is being concurrently upgraded. In an embodiment, a database server stores, within an application container of an application, original metadata that defines objects for use by pluggable databases of the application. The database server receives a maintenance request to adjust the original metadata. The database server creates, in response to receiving the maintenance request, a reference container that contains cloned metadata that is a copy of the original metadata. The database server receives, during or after creating the reference container, a read request to read one of the objects. The database server concurrently performs both of: executing the maintenance request upon the original metadata, and executing the read request upon the cloned metadata of the reference container.