Oracle International Corporation

Michael Harvey

Nitin Karkhanis

Jiangbin Luo

Juan R Loaiza

Mahesh Baburao Girkar

Steve Lee

Benedicto Garin

Hongjie Yang

Steven McGee

Robert McGuirk

Stephen John Vivian

Sean Joseph Connolly

Gary Allison

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

A graphical user interface based method of configuring automatic failover from a primary database system to a standby database system that is coupled to the primary database system by a network. Also coupled to the network is an observer process that is independent of the database systems and that initiates the failover process. The observer periodically pings the database systems to determine whether a failover is necessary. The graphical user interface permits a user to specify the primary and secondary database systems, configure the observer, and specify conditions under which a failover may occur and to enable automatic failover. A failover context is created from the inputs to the GUI and stored in persistent storage belonging to the database systems. If the Observer's context is stale, the Observer fetches the database system's context.

System and method of configuring a database system with replicated data and automatic failover and recovery

Growing community of inventors

Hollis, NH, United States of America

Michael Harvey