公开(公告)号：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

IPC: G06F11/20 ,  G06F17/30 ,  G06F11/14

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.

公开(公告)号：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

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

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.