Oracle International Corporation

Steven McGee

Mahesh Baburao Girkar

Juan R Loaiza

Nitin Karkhanis

Steve Lee

Jiangbin Luo

Benedicto Garin

Hongjie Yang

Michael Harvey

Robert McGuirk

David Gagne

Disclosed are methods and apparatuses to provide a redo repeater that allows for no data loss protection without the performance impact to the primary database even when a significant geographical distance separates the primary and standby databases. The Repeater is a lightweight entity that receives redo from the primary database with the purpose of redistributing that redo throughout the primary/standby system configuration. The Repeater able to extend no data loss protection and switchover functionality to terminal standby databases even though the primary database does not need to have a direct connection with those destinations.

Method and system for implementing a redo repeater

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.

No data loss system with reduced commit latency

Growing community of inventors

Bedford, NH, United States of America

Steven McGee