中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

9 records (took 0.014 seconds)

    Automatic recovery of a failed standby database in a cluster
    2.
    发明授权
    Automatic recovery of a failed standby database in a cluster 有权
    自动恢复群集中的故障备用数据库

    公开(公告)号：US09514160B2

    公开(公告)日：2016-12-06

    申请号：US13794112

    申请日：2013-03-11

    Applicant: Oracle International Corporation

    Inventor： Shanshan Song ,  Yunrui Li ,  Tolga Yurek ,  Mahesh Girkar ,  Neil MacNaughton

    IPC: G06F17/30

    CPC classification number: G06F17/30289 ,  G06F17/30575 ,  G06F17/30581

    Abstract: A method, system, and computer program product. The method for non-intrusive redeployment of a standby database facility comprises configuring a database system having a shared lock manager process to synchronize two or more concurrent access instances, then granting lock requests for access to a cache of database blocks. At some moment in time, the shared lock manager process may fail, and a monitor process detects the failure or other stoppage of the shared lock manager process. A new shared lock manager process and other processes are started, at least one of which serves for identifying the database blocks in the cache that have not yet been written to the database. The identified blocks are formed into a recovery set of redo operations. During this time, incoming requests for access to the cache of database blocks are briefly blocked, at least until the recovery set of redo operations has been formed.

    Abstract translation: 一种方法，系统和计算机程序产品。 用于非侵入式重新部署备用数据库设施的方法包括配置具有共享锁管理器进程的数据库系统以同步两个或多个并发访问实例，然后授予对数据库块的高速缓存的锁定请求。 在某个时刻，共享锁管理器进程可能会失败，并且监视进程检测到共享锁管理器进程的故障或其他停止。 启动新的共享锁管理器进程和其他进程，其中至少一个用于识别高速缓存中尚未写入数据库的数据库块。 所识别的块被形成恢复一组重做操作。 在此期间，暂时阻止访问数据库块的缓存的传入请求，至少在恢复组重做操作已经形成之前。

    Automatic Query Offloading to a Standby Database
    4.
    发明申请
    Automatic Query Offloading to a Standby Database 审中-公开

    公开(公告)号：US20190392067A1

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

    申请号：US16016978

    申请日：2018-06-25

    Applicant: Oracle International Corporation

    Inventor： Sachin Sonawane ,  Mahesh Girkar

    IPC: G06F17/30

    Abstract: Embodiments allow a primary database system (“primary”) to automatically detect queries directed to the primary database that may be offloaded to a standby database system (“standby”), and then to automatically offload the offload-eligible queries to a standby. The primary identifies offload-eligible queries based on a record of up-to-date database objects within each standby that replicates the primary database. The record of up-to-date standby objects is updated based on heartbeat messages from each standby, and commit timestamps for transactions on the primary. Evaluation of whether a query is offload-eligible is triggered by one or more trigger conditions that include: inclusion of an offload optimizer hint in the query, an estimated run-time of the query, etc. Embodiments further allow an offloaded query over particular changed data in the primary database to access, on a standby database, uncommitted changes made to the particular data in the primary database.

    DATA GUARD AT PDB (PLUGGABLE DATABASE) LEVEL
    8.
    发明申请
    DATA GUARD AT PDB (PLUGGABLE DATABASE) LEVEL 有权

    公开(公告)号：US20230033806A1

    公开(公告)日：2023-02-02

    申请号：US17389835

    申请日：2021-07-30

    Applicant: Oracle International Corporation

    Inventor： Yunrui Li ,  Giridhar Ravipati ,  Ian Neall ,  Frank Lange ,  Jing Zheng ,  Mahesh Girkar ,  David Gagne ,  Nitin Karkhanis ,  Sadhana Kyathappala ,  Qingguang Cui

    IPC: G06F16/27 ,  G06F16/23 ,  G06F11/14

    Abstract: Herein is high availability for online transaction processing with redundancy and redo for a federation of pluggable databases and container databases. In an embodiment of a federation of container database management systems that includes a first container database, first redo data of a first pluggable database in a second container database is obtained based on a database dictionary in the first container database. To the first pluggable database in the first container database, the first redo data of the first pluggable database in the second container database is applied. Based on the database dictionary in the first container database, second redo data of a second pluggable database in a third container database is obtained. To the second pluggable database in the first container database, without modifying content of the first pluggable database in the first container database, the second redo data of the second pluggable database in the third container database is applied.

    Automatic query offloading to a standby database
    9.
    发明授权
    Automatic query offloading to a standby database 有权

    公开(公告)号：US11468060B2

    公开(公告)日：2022-10-11

    申请号：US16016978

    申请日：2018-06-25

    Applicant: Oracle International Corporation

    Inventor： Sachin Sonawane ,  Mahesh Girkar

    IPC: G06F16/245 ,  G06F16/2453 ,  G06F16/23 ,  G06F16/25 ,  G06F16/242 ,  G06F16/2457

    Abstract: Embodiments allow a primary database system (“primary”) to automatically detect queries directed to the primary database that may be offloaded to a standby database system (“standby”), and then to automatically offload the offload-eligible queries to a standby. The primary identifies offload-eligible queries based on a record of up-to-date database objects within each standby that replicates the primary database. The record of up-to-date standby objects is updated based on heartbeat messages from each standby, and commit timestamps for transactions on the primary. Evaluation of whether a query is offload-eligible is triggered by one or more trigger conditions that include: inclusion of an offload optimizer hint in the query, an estimated run-time of the query, etc. Embodiments further allow an offloaded query over particular changed data in the primary database to access, on a standby database, uncommitted changes made to the particular data in the primary database.

Patent Agency Ranking