Invention Grant
- Patent Title: Method and system for automatic maintenance of standby databases for non-logged workloads
-
Application No.: US15828146Application Date: 2017-11-30
-
Publication No.: US11010267B2Publication Date: 2021-05-18
- Inventor: Ian Stuart Neall , Yunrui Li , Steven J. Mcgee , Yi Ding , German Shegalov , Shanshan Song
- Applicant: ORACLE INTERNATIONAL CORPORATION
- Applicant Address: US CA Redwood Shores
- Assignee: ORACLE INTERNATIONAL CORPORATION
- Current Assignee: ORACLE INTERNATIONAL CORPORATION
- Current Assignee Address: US CA Redwood Shores
- Agency: Vista IP Law Group, LLP
- Main IPC: G06F11/20
- 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.
Public/Granted literature
- US20190095297A1 METHOD AND SYSTEM FOR AUTOMATIC MAINTENANCE OF STANDBY DATABASES FOR NON-LOGGED WORKLOADS Public/Granted day:2019-03-28
Information query