Invention Grant
- Patent Title: Method and system for supporting data consistency on an active standby database after DML redirection to a primary database
-
Application No.: US15885281Application Date: 2018-01-31
-
Publication No.: US10949413B2Publication Date: 2021-03-16
- Inventor: Sachin Vijaykumar Sonawane , Mahesh Baburao Girkar , Yunrui Li , Thomas Baby , Vivekanandhan Raja
- 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: G06F16/30
- IPC: G06F16/30 ; G06F16/23 ; G06F16/27 ; G06F11/14

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.
Public/Granted literature
Information query