David James Gagne

US Patent:

7599967, Oct 6, 2009

Filed:

Mar 20, 2007

Appl. No.:

11/688550

Inventors:

Mahesh Baburao Girkar - Cupertino CA, US
Steven McGee - Bedford NH, US
David Gagne - Goffstown NH, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 17/30

US Classification:

707200, 707202, 707204

Abstract:

Techniques for reducing commit latency in a database system having a primary database system and a standby database system that is receiving a stream of redo data items from the primary. The standby sends an acknowledgment for a received item of redo data before the standby writes the redo data item to a redo log for the stream. When a no more redo event occurs in the standby, the standby sets a “no data lost flag” in the redo log if the stream of redo data items has no gaps and all of the redo data items received in the standby have been written to the redo log. The database system may operate in a first mode in which an acknowledgment is sent as just described and a second mode in which an acknowledgment is sent after the redo data item has been written to the redo log.

US Patent:

20230033806, Feb 2, 2023

Filed:

Jul 30, 2021

Appl. No.:

17/389835

Inventors:

- Redwood Shores CA, US
Giridhar Ravipati - Foster City CA, US
Ian Neall - Henley-on-Thames, GB
Frank Lange - Woerden, NL
Jing Zheng - Foster City CA, US
Mahesh Girkar - Los Altos CA, US
David Gagne - Goffstown NH, US
Nitin Karkhanis - Nashua NH, US
Sadhana Kyathappala - Westford MA, US
Qingguang Cui - Redwood Shores CA, US

International Classification:

G06F 16/27
G06F 16/23
G06F 11/14

Abstract:

Herein is high availability for online transaction processing with redundancy and redo for a federation of pluggable databases and container databases. In an embodiment of a federation of container database management systems that includes a first container database, first redo data of a first pluggable database in a second container database is obtained based on a database dictionary in the first container database. To the first pluggable database in the first container database, the first redo data of the first pluggable database in the second container database is applied. Based on the database dictionary in the first container database, second redo data of a second pluggable database in a third container database is obtained. To the second pluggable database in the first container database, without modifying content of the first pluggable database in the first container database, the second redo data of the second pluggable database in the third container database is applied.