公开(公告)号：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中。

公开(公告)号：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.

公开(公告)号：US20190102411A1

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

申请号：US16135769

申请日：2018-09-19

Applicant: Oracle International Corporation

Inventor： Hochak Hung ,  Kumar Rajamani ,  Jaebock Lee ,  Sanket Jain ,  Giridhar Ravipati ,  John McHugh ,  Churn Don Lee ,  Alexander Chen ,  Jen-Cheng Huang

IPC: G06F17/30 ,  H04L12/24 ,  H04L29/08 ,  G06F15/18

Abstract: Provided herein are data cloud administration techniques that achieve autonomy by using a rules engine that reacts to a database system event by autonomously submitting an asynchronous job to reconfigure a database. In an embodiment, a rules engine receives an event from a DBMS. Based on the event, the rules engine executes a rule to generate a request that indicates configuration details for a database. The rules engine sends the request to a request broker. The request broker dispatches an asynchronous job based on the request. The asynchronous job configures the database based on the configuration details. Thus, databases in a cloud, data grid, or data center may be administered autonomously (without human intervention) base on dynamic conditions that are foreseen and unforeseen.

公开(公告)号：US09684566B2

公开(公告)日：2017-06-20

申请号：US14135202

申请日：2013-12-19

Applicant: Oracle International Corporation

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

IPC: G06F17/30 ,  G06F11/14

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: A container database stores redo records and logical timestamps for multiple pluggable databases. When it is detected that a first read-write instance of the pluggable database is opened and no other read-write instances of the pluggable database are open, offline range data associated with the pluggable database is updated. When it is detected that a second read-write instance of the pluggable database is closed, and the second read-write instance is the last open read-write instance, the offline range data associated with the pluggable database is updated. The pluggable database is restored to a logical timestamp associated with a restore request based on the offline range data.

公开(公告)号：US20170116321A1

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

申请号：US15331534

申请日：2016-10-21

Applicant: Oracle International Corporation

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

IPC: G06F17/30

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.

公开(公告)号：US20160210201A9

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

申请号：US14135202

申请日：2013-12-19

Applicant: Oracle International Corporation

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

IPC: G06F11/14 ,  G06F17/30

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: A container database stores redo records and logical timestamps for multiple pluggable databases. When it is detected that a first read-write instance of the pluggable database is opened and no other read-write instances of the pluggable database are open, offline range data associated with the pluggable database is updated. When it is detected that a second read-write instance of the pluggable database is closed, and the second read-write instance is the last open read-write instance, the offline range data associated with the pluggable database is updated. The pluggable database is restored to a logical timestamp associated with a restore request based on the offline range data.

Abstract translation: 容器数据库存储多个可插拔数据库的重做记录和逻辑时间戳。 当检测到可插拔数据库的第一个读写实例被打开，并且没有可插拔数据库的其他读写实例被打开时，与可插拔数据库关联的脱机范围数据被更新。 当检测到可插拔数据库的第二读写实例被关闭，并且第二读写实例是最后打开的读写实例时，更新与可插拔数据库相关联的脱机范围数据。 基于离线范围数据，可插拔数据库恢复到与恢复请求相关联的逻辑时间戳。

公开(公告)号：US09239763B2

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

申请号：US13631815

申请日：2012-09-28

Applicant: Oracle International Corporation

Inventor： Jaebock Lee ,  Kumar Rajamani ,  Giridhar Ravipati ,  Andre Kruglikov ,  Sanket Jain ,  Chandrasekharan Iyer ,  Philip Yam ,  Yunrui Li

IPC: G06F17/30 ,  G06F11/14 ,  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: A container database may contain multiple database dictionaries, each database dictionary defining a pluggable database. When database sessions are established on a container DBMS, each database session is given access to a pluggable database by establishing the respective database dictionary of the pluggable database as the database dictionary for that database session. Database commands issued through database session can only access the database objects defined in the database dictionary established for the database session.

Abstract translation: 容器数据库可以包含多个数据库字典，每个数据库字典定义可插入数据库。 当在容器DBMS上建立数据库会话时，通过建立可插拔数据库的相应数据库字典作为该数据库会话的数据库字典，为每个数据库会话提供对可插入数据库的访问。 通过数据库会话发出的数据库命令只能访问为数据库会话建立的数据库字典中定义的数据库对象。

公开(公告)号：US09122644B2

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

申请号：US13841272

申请日：2013-03-15

Applicant: ORACLE INTERNATIONAL CORPORATION

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

IPC: G06F17/30 ,  G06F11/14 ,  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允许通常或本地授予权限和角色。 通常授予特权或角色时，特权将应用于容器数据库的每个数据库。 当本地授予特权或角色时，权限仅适用于权限或角色的授予人建立连接的数据库。

公开(公告)号：US20140095530A1

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

申请号：US13631815

申请日：2012-09-28

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Jaebock Lee ,  Kumar Rajamani ,  Giridhar Ravipati ,  Andre Kruglikov ,  Sanket Jain ,  Chandrasekharan Iyer ,  Philip Yam ,  Yunrui Li

IPC: G06F17/30

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: A container database may contain multiple database dictionaries, each database dictionary defining a pluggable database. When database sessions are established on a container DBMS, each database session is given access to a pluggable database by establishing the respective database dictionary of the pluggable database as the database dictionary for that database session. Database commands issued through database session can only access the database objects defined in the database dictionary established for the database session.

Abstract translation: 容器数据库可以包含多个数据库字典，每个数据库字典定义可插入数据库。 当在容器DBMS上建立数据库会话时，通过建立可插拔数据库的相应数据库字典作为该数据库会话的数据库字典，为每个数据库会话提供对可插入数据库的访问。 通过数据库会话发出的数据库命令只能访问为数据库会话建立的数据库字典中定义的数据库对象。