The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.

The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.

Date of Patent:
Dec. 11, 2018

Filed:

May. 05, 2014
Applicant:

Oracle International Corporation, Redwood Shores, CA (US);

Inventors:

Jonghyun Lee, San Jose, CA (US);

Yunrui Li, Fremont, CA (US);

Mahesh Baburao Girkar, Cupertino, CA (US);

Amrish Srivastava, San Ramon, CA (US);

Assignee:

Oracle International Corporation, Redwood Shores, CA (US);

Attorney:
Primary Examiner:
Int. Cl.
CPC ...
G06F 17/30 (2006.01); G06F 11/00 (2006.01); G06F 11/20 (2006.01); G06F 11/14 (2006.01);
U.S. Cl.
CPC ...
G06F 11/2038 (2013.01); G06F 11/1438 (2013.01); G06F 11/1458 (2013.01); G06F 11/2097 (2013.01); G06F 17/30067 (2013.01); G06F 17/30353 (2013.01); G06F 2201/80 (2013.01); G06F 2201/82 (2013.01); G06F 2201/835 (2013.01);
Abstract

A method, apparatus, and system for a time-based checkpoint target is provided for standby databases. Change records received from a primary database are applied for a standby database, creating dirty buffer queues. As the change records are applied, a mapping is maintained, which maps timestamps to logical times of change records that were most recently applied at the timestamp for the standby database. On a periodic dirty buffer queue processing interval, the mapping is used to determine a target logical time that is mapped to a target timestamp that is prior to a present timestamp by at least a checkpoint delay. The dirty buffer queues are then processed up to the target logical time, creating an incremental checkpoint. On a periodic header update interval, file headers reflecting a consistent logical time for the checkpoint are also updated. The intervals and the checkpoint delay are adjustable by user or application.


Find Patent Forward Citations

Loading…