公开(公告)号：US20210271663A1

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

申请号：US17202024

申请日：2021-03-15

Applicant: Oracle International Corporation

Inventor： Sachin Vijaykumar SONAWANE ,  Mahesh BABURAO GIRKAR ,  Yunrui LI ,  Thomas BABY ,  Vivekanandhan RAJA

IPC: G06F16/23 ,  G06F16/27

Abstract: A database session in an active standby server on which an active standby database resides receives a DML statement. The session is suspended while the statement is redirected over a database link to a primary database on which the statement is executed. Information associated with execution of the statement is communicated to the session in the active standby server. Redo records describing changes to the contents of the primary database are applied to the active standby database and control is returned to the session. Prior to commitment of a transaction including the statement, a query directed to data to which the statement was directed is received at the active standby server from a client and executed on the active standby database absent use of a database link based on whether information associated with a database session associated with the client matches the information associated with execution of the statement.

公开(公告)号：US20140095553A1

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

申请号：US13630582

申请日：2012-09-28

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Vsevolod PANTELEENKO ,  Yunrui LI ,  Jonghyun LEE ,  Margaret M. SUSAIRAJ ,  William H. BRIDGE, Jr. ,  Vinay SRIHARI

IPC: G06F17/30

CPC classification number: G06F17/303

Abstract: Techniques for moving data files without interrupting access are described. A first process moves a database file from a first location to a second location while the database file is accessible to one or more other processes for read or write operations. According to one technique, the first process communicates a move status and a copy range into the database file to one or more database server instances executing the one or more other processes. The one or more other processes then perform input/output (IO) operations on the database file based at least in part on the move status and the copy range communicated by the first process.

Abstract translation: 描述了在不中断访问的情况下移动数据文件的技术。 第一个进程将数据库文件从第一个位置移动到第二个位置，而数据库文件可被一个或多个其他进程访问以进行读取或写入操作。 根据一种技术，第一过程将移动状态和复制范围传达到数据库文件中，以执行一个或多个其他进程的一个或多个数据库服务器实例。 所述一个或多个其他进程至少部分地基于由第一进程传送的移动状态和复制范围对数据库文件执行输入/输出（IO）操作。

公开(公告)号：US20230027685A1

公开(公告)日：2023-01-26

申请号：US17818271

申请日：2022-08-08

Applicant: Oracle International Corporation

Inventor： Teck Hua LEE ,  Tirthankar LAHIRI ,  Yunrui LI

IPC: G06F16/23 ,  G06F16/22

Abstract: An approach is described to provide a method, a computer program product, and a computer system to implement hole punching. The described approach provides an automated way to free up space without requiring manual intervention by a DBA to manually reorganize database objects to free up space.

公开(公告)号：US20190102421A1

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

申请号：US15885281

申请日：2018-01-31

Applicant: Oracle International Corporation

Inventor： Sachin Vijaykumar SONAWANE ,  Mahesh Baburao GIRKAR ,  Yunrui LI ,  Thomas Baby ,  Vivekanandhan Raja

IPC: G06F17/30

Abstract: A database session in an active standby server on which an active standby database resides receives a DML statement. The session is suspended while the statement is redirected over a database link to a primary database on which the statement is executed. Information associated with execution of the statement is communicated to the session in the active standby server. Redo records describing changes to the contents of the primary database are applied to the active standby database and control is returned to the session. Prior to commitment of a transaction including the statement, a query directed to data to which the statement was directed is received at the active standby server from a client and executed on the active standby database absent use of a database link based on whether information associated with a database session associated with the client matches the information associated with execution of the statement.

公开(公告)号：US20220179753A1

公开(公告)日：2022-06-09

申请号：US17113091

申请日：2020-12-06

Applicant: Oracle International Corporation

Inventor： Giridhar RAVIPATI ,  Yunrui LI ,  Kumar RAJAMANI ,  Muthu OLAGAPPAN

IPC: G06F11/14

Abstract: A computer program product, system, and computer implemented method for management of a consolidated database and implementing pluggable database recovery with efficient 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.

公开(公告)号：US20210081399A1

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

申请号：US16948306

申请日：2020-09-11

Applicant: Oracle International Corporation

Inventor： Teck Hua LEE ,  Tirthankar LAHIRI ,  Yunrui LI

IPC: G06F16/23 ,  G06F16/22

Abstract: An approach is described to provide a method, a computer program product, and a computer system to implement hole punching. The described approach provides an automated way to free up space without requiring manual intervention by a DBA to manually reorganize database objects to free up space.

公开(公告)号：US20140258224A1

公开(公告)日：2014-09-11

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

公开(公告)号：US20140258223A1

公开(公告)日：2014-09-11

申请号：US13791607

申请日：2013-03-08

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Chi CAO MINH ,  Vinay H. SRIHARI ,  Yunrui LI ,  Jonghyun LEE

IPC: G06F17/30

CPC classification number: G06F17/30575 ,  G06F17/30227 ,  G06F17/30368

Abstract: A method, system, and computer program product for adaptive high-performance database redo log synchronization. The method commences upon performing a write operation of a redo log entry, the write operation concluding with an indication of completion of the write operation of the redo log entry. Any number of committing processes may be waiting for the indication of completion, and upon indication of completion, then (using a first synchronization mode) the processes or proxy measures the waiting time as experienced by the committing processes (e.g., while waiting for the indication of completion of the write operation of the redo log entry). In some cases a second synchronization mode would introduce less latency than the first synchronization mode, so the system changes to a second synchronization mode. The system can also change mode when a predicted second mode waiting time is smaller than the measured waiting time.

Abstract translation: 一种用于自适应高性能数据库重做日志同步的方法，系统和计算机程序产品。 在执行重做日志条目的写入操作时，该方法开始，写入操作以与重做日志条目的写入操作的完成指示结束。 任何数量的提交过程可以等待完成的指示，并且在完成指示之后（使用第一同步模式），处理或代理测量由提交处理所经历的等待时间（例如，在等待指示时 完成重写日志条目的写入操作）。 在一些情况下，第二同步模式将引入比第一同步模式更少的延迟，因此系统改变为第二同步模式。 当预测的第二模式等待时间小于测量的等待时间时，系统也可以改变模式。