Patent ID: 9384100
Filing Date: 2016-07-05
CPC Classification: G06F

Claim Text:
1. In a computer system including at least one processor and a memory, and which is included in a computer networking environment including a plurality of other computing systems and at least one database server, a computer-implemented method for implementing a transitional redo phase during recovery following a failure of the database or database server, the transitional redo phase allowing at least limited access to the database prior to a final redo phase which provides full recovery, the computer-implemented method comprising the following acts: following detection of a database failure, scanning a database transaction log to identify dirty pages that represent pages having unprocessed data transactions; determining which dirty pages are to be prioritized for processing during the transitional redo phase and prior to a full recovery provided during a final redo phase, when all other dirty pages will be processed; processing the prioritized dirty pages during the transitional redo phase and before the final redo phase is reached; making available to database users previously prioritized dirty pages with completed data transactions for the previously prioritized dirty pages that were processed during the transitional redo phase; and beginning the final redo phase to complete full database recovery for the dirty pages, such that all previously prioritized dirty pages with the now completed data transactions and the any other pages that were unaffected by the database failure are accessible by database users during the final redo phase, wherein any remaining dirty pages of the dirty page table that were not prioritized are thus scheduled for processing during the final redo phase are latched before being accessed, such that during the final redo phase, if a page is waiting to be re-processed and if redo is not complete, user requests are blocked until the final redo phase completes processing the requested page.