Invention Publication
- Patent Title: REDO AVOIDANCE DURING DATABASE RECOVERY
-
Application No.: US18162342Application Date: 2023-01-31
-
Publication No.: US20240256398A1Publication Date: 2024-08-01
- Inventor: Akshay Manchale Sridhar , Matthew Woicik , James E. Mace
- Applicant: Salesforce, Inc.
- Applicant Address: US CA San Francisco
- Assignee: Salesforce, Inc.
- Current Assignee: Salesforce, Inc.
- Current Assignee Address: US CA San Francisco
- Main IPC: G06F11/14
- IPC: G06F11/14 ; G06F16/23

Abstract:
Techniques are disclosed relating to a database recovery routine to start up a database system in response to a database failure. The database system accesses checkpoint information identifying a set of active database transactions that were active at a flush point that occurred before the database failure. As a part of the database recovery routine, the database system replays database transactions that occurred between a recovery point and the flush point. The database transactions include the set of active database transactions but exclude any committed or aborted database transactions that occurred between the recovery point and the flush point such that less than a total number of database transactions occurring between the recovery point and the flush point are replayed. The database system further replays, without excluding committed or aborted database transactions, database transactions occurring between the flush point and a recovery end point at which the database failure occurred.
Information query