Invention Grant
- Patent Title: Ensuring database log recovery consistency
-
Application No.: US13458687Application Date: 2012-04-27
-
Publication No.: US08738586B2Publication Date: 2014-05-27
- Inventor: Ivan Schreter
- Applicant: Ivan Schreter
- Applicant Address: DE Walldorf
- Assignee: SAP AG
- Current Assignee: SAP AG
- Current Assignee Address: DE Walldorf
- Agency: Mintz Levin Cohn Ferris Glovsky and Popeo, P.C.
- Main IPC: G06F17/00
- IPC: G06F17/00 ; G06F17/30

Abstract:
A plurality of transactions are executed in a data storage application. Thereafter, log entries are sequentially stored according to the plurality of transactions in at least one log. Each log segment has a first globally unique identifier (GUID) uniquely identifying the log segment and includes a second GUID uniquely identifying an immediately preceding log segment in the sequence. In addition, the current position in the at least one log is stored along with the current log segment GUID together with data pages during data backup. Subsequently, a position in the at least one log from which to initiate replay of the log segments and a GUID for a corresponding log segment at the determined position at database recovery time is determined based on information stored during data backup. Replay of the log segments is then initiated starting at the determined position. Related apparatus, systems, techniques and articles are also described.
Public/Granted literature
- US08768891B2 Ensuring database log recovery consistency Public/Granted day:2014-07-01
Information query