Page Inconsistency Recovery and Avoidance
Original Publication Date: 1989-Mar-01
Included in the Prior Art Database: 2005-Jan-29
Disclosed is a process for recovering from and avoiding page inconsistency (due to file system non-atomic write and allocate space operations) using a write ahead logging protocol. In particular, during a restart redo phase, we may have allocated a page to a file, but not yet initialized the page to correspond to the new allocation. In this case, we need to prevent an old consistency indicator and/or an old Log Sequence Number (LSN) from being inadvertently used. The condition could occur wherein a valid page format is detected because the file was created on an old database and then deleted. Also, if the same file name has been deleted and recreated, during the redo process, we could be applying an update to a page which had actually belonged to a different database, causing unpredictable results.