Consider using the crash recovery procedure described in Section 22.2 (intended for physical logging) when logical logging is used. Explain how the procedure has to be modified to handle crashes that occur during recovery. Assume that the effect of each update is confined to a single page.
What will be an ideal response?
Problem: The crash might occur during Phase 3. It makes a difference during the second execution of recovery (after the crash during Phase 3) whether the application of an inverse operation to an updated item has already been performed. Hence, LSNs must be used to determine whether an operation should be applied to a page.
You might also like to view...
The first row of a data source for a mail merge is known as the:
A) merge field. B) primary row. C) header row. D) filter.
The network security manager has been notified by customer service that employees have been sending unencrypted confidential information via email. Which of the following should the manager select to BEST detect and provide notification of these occurrences?
A. DLP B. SSL C. DEP D. UTM