-
公开(公告)号：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.
-
公开(公告)号：US11550667B2
公开(公告)日：2023-01-10
申请号：US16791091
申请日：2020-02-14
Applicant: Oracle International Corporation
Inventor： Prashanth Shanthaveerappa , Giridhar Ravipati , Margaret Susairaj , Kumar Rajamani
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.
-
公开(公告)号：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.
-
公开(公告)号：US10860605B2
公开(公告)日：2020-12-08
申请号：US15215446
申请日：2016-07-20
Applicant: Oracle International Corporation
Inventor： Jaebock Lee , Kumar Rajamani , Sanket Jain , Giridhar Ravipati
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.
-
公开(公告)号：US10579478B2
公开(公告)日：2020-03-03
申请号：US15244867
申请日：2016-08-23
Applicant: Oracle International Corporation
Inventor： Prashanth Shanthaveerappa , Giridhar Ravipati , Margaret Susairaj , Kumar Rajamani
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.
-
Patent Agency Ranking
公开(公告)号：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.
-
公开(公告)号：US20200026608A9
公开(公告)日：2020-01-23
申请号：US15244867
申请日：2016-08-23
Applicant: Oracle International Corporation
Inventor： Prashanth Shanthaveerappa , Giridhar Ravipati , Margaret Susairaj , Kumar Rajamani
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.
-
公开(公告)号：US20200004838A9
公开(公告)日：2020-01-02
申请号：US15266902
申请日：2016-09-15
Applicant: Oracle International Corporation
Inventor： Andre Kruglikov , Kumar Rajamani , Debaditya Chatterjee
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.
-
49.发明申请公开(公告)号：US20180121511A1
公开(公告)日：2018-05-03
申请号：US15339525
申请日：2016-10-31
Applicant: Oracle International Corporation
Inventor： Yunrui Li , Kumar Rajamani
IPC: G06F17/30
CPC classification number: G06F16/24549 , G06F16/2282 , G06F16/2358 , G06F16/2365 , G06F16/2379 , G06F16/2477 , G06F16/256 , G06F16/27 , G06F16/951
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.
-
公开(公告)号：US20180075086A1
公开(公告)日：2018-03-15
申请号：US15266917
申请日：2016-09-15
Applicant: Oracle International Corporation
Inventor： Philip Yam , Thomas Baby , Andre Kruglikov , Kumar Rajamani
CPC classification number: G06F16/2379 , G06F8/65 , G06F11/1474 , G06F2201/87
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.
-
-
-
-
-
-
-
-
-
Search Results
56
records
(took 0.025 seconds)
