-
1.发明申请公开(公告)号：US20190095297A1
公开(公告)日：2019-03-28
申请号：US15828146
申请日：2017-11-30
Applicant: ORACLE INTERNATIONAL CORPORATION
Inventor： Ian Stuart Neall , Yunrui Li , Steven J. Mcgee , Yi Ding , German Shegalov , Shanshan Song
Abstract: A computer program product, system, and computer implemented method for automatic maintenance of standby databases for non-logged workloads, the process comprising: maintaining a redo stream of redo records sent from a primary database to a standby database, identifying a change made at the primary database for which a redo record was not created, inserting a placeholder redo record into the redo stream corresponding to the change identified at the primary database for which the redo record was not created, sending, to the standby database, a copy of one or more data blocks corresponding to the change that is associated with the placeholder redo record, receiving the placeholder redo record from the redo stream, identifying the copy of the one or more data blocks sent from the primary database corresponding to the placeholder redo record, and applying the copy of one or more data blocks to update the standby database.
-
公开(公告)号：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: 一种方法，系统和计算机程序产品。 用于非侵入式重新部署备用数据库设施的方法包括配置具有共享锁管理器进程的数据库系统以同步两个或多个并发访问实例，然后授予对数据库块的高速缓存的锁定请求。 在某个时刻，共享锁管理器进程可能会失败，并且监视进程检测到共享锁管理器进程的故障或其他停止。 启动新的共享锁管理器进程和其他进程，其中至少一个用于识别高速缓存中尚未写入数据库的数据库块。 所识别的块被形成恢复一组重做操作。 在此期间，暂时阻止访问数据库块的缓存的传入请求，至少在恢复组重做操作已经形成之前。
-
3.发明授权公开(公告)号：US11010267B2
公开(公告)日：2021-05-18
申请号：US15828146
申请日：2017-11-30
Applicant: ORACLE INTERNATIONAL CORPORATION
Inventor： Ian Stuart Neall , Yunrui Li , Steven J. Mcgee , Yi Ding , German Shegalov , Shanshan Song
Abstract: A computer program product, system, and computer implemented method for automatic maintenance of standby databases for non-logged workloads, the process comprising: maintaining a redo stream of redo records sent from a primary database to a standby database, identifying a change made at the primary database for which a redo record was not created, inserting a placeholder redo record into the redo stream corresponding to the change identified at the primary database for which the redo record was not created, sending, to the standby database, a copy of one or more data blocks corresponding to the change that is associated with the placeholder redo record, receiving the placeholder redo record from the redo stream, identifying the copy of the one or more data blocks sent from the primary database corresponding to the placeholder redo record, and applying the copy of one or more data blocks to update the standby database.
-
-
Search Results
3
records
(took 0.01 seconds)
