公开(公告)号：US20180075044A1

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

申请号：US15266902

申请日：2016-09-15

Applicant: Oracle International Corporation

Inventor： Andre Kruglikov ,  Kumar Rajamani ,  Debaditya Chatterjee

IPC: G06F17/30 ,  G06F9/445

Abstract: Techniques herein use rules automation and template pluggable databases to facilitate deployment into container databases. In an embodiment, a system of computers loads rules into a rules engine. Each rule associates a predicate with suitable container databases. The system receives a request to install a target pluggable database. The rules engine detects satisfied rules whose predicates match the request. Based on the suitable container databases of the satisfied rules, the rules engine selects a particular container database. The system installs the target pluggable database into the particular container database. In an embodiment, a system of computers stores a plurality of template pluggable databases in a repository. The repository receives an installation request. Based on the installation request, the system selects a particular template pluggable database. The system installs the particular template pluggable database into a 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

IPC: G06F11/14 ,  G06F17/30

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.

公开(公告)号：US20170116298A1

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

申请号：US15215443

申请日：2016-07-20

Applicant: Oracle International Corporation

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

IPC: G06F17/30 ,  G06F11/14

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

公开(公告)号：US20170116282A1

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

申请号：US15192837

申请日：2016-06-24

Applicant: Oracle International Corporation

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

IPC: G06F17/30

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

Abstract: A pluggable database (PDB) that is encoded using a particular character set (differing character set) may be plugged into a container database (CDB) and queried, even when the CDB in which the particular PDB resides is encoded using a different character set. The DBMS records what character set is used to encode the PDB. Any predicate that may prune results from a PDB that is encoded in a differing character set is converted to the differing character set as needed, such that the predicate may be applied within the PDB to prune results. At times, cross-container views will require data from a PDB that is encoded using a differing character set. The data returned from a recursive query over the PDB is converted to being encoded using the character set of the root database of the CDB.

公开(公告)号：US20170116235A1

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

申请号：US15266030

申请日：2016-09-15

Applicant: Oracle International Corporation

Inventor： Philip Yam ,  Kumar Rajamani ,  Jaebock Lee

IPC: G06F17/30

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

Abstract: A database server instance automatically detects configuration issues when a pluggable database (PDB) is plugged into a new destination container database (CDB). The database server instance identifies one or more update templates, within the destination CDB, that, when run over the relocated PDB, will update the configuration of the PDB to conform to the configuration of the destination CDB. Instead of requiring an administrator to initiate update scripts from a DBMS kernel to reconfigure a PDB, the DBMS creates the update templates by recording commands run within PDBs in connection with system updates. These recorded update templates may then be run over relocated PDBs, to configure the PDBs according to the configuration of the destination CDB. Further, the update templates may be pre-recorded update templates, which record commands to perform configuration updates, to PDBs, that have never before been performed within the CDB.

公开(公告)号：US20150254240A1

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

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