Invention Grant
- Patent Title: Zero-data-loss with asynchronous redo shipping to a standby database
-
Application No.: US15266375Application Date: 2016-09-15
-
Publication No.: US10698771B2Publication Date: 2020-06-30
- Inventor: Hongjie Yang , Yunrui Li , Mahesh Baburao Girkar
- 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: Hickman Palermo Becker Bingham LLP
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00 ; G06F11/14 ; G06F16/27 ; G06F11/20

Abstract:
Herein are techniques of zero data loss with asynchronously replicated redo logs. In an embodiment, a first server instance (FSI) of a plurality of server instances (PSI) of a primary database (PDB) sends, to a standby database (SDB) during an shutdown of FSI, a first recovery count (RC) and a remainder of an instance redo log (IRL). In response to recovering FSI, a second server instance of PSI increments a recovery counter to a second RC (SRC), publishes SRC to PSI, and sends SRC to SDB. After restarting FSI, FSI makes a change to contents of PDB, and stores, into IRL, a redo entry that defines the change. During failover, a database management system (DBMS) detects whether RCs associated with FSRL and SSRL are unanimous. If unanimous, DBMS fully rolls forward SDB by replaying FSRL and SSRL. Otherwise, DBMS limits replay and indicates that FSRL and SSRL might be inconsistent.
Public/Granted literature
- US20180074915A1 Zero-Data-Loss with Asynchronous Redo Shipping to a Standby Database Public/Granted day:2018-03-15
Information query