5. Crash recovery for steal, no-force policy: The following list gives pages, objects on these pages and their values in

[answerhappygod]

5 Crash Recovery For Steal No Force Policy The Following List Gives Pages Objects On These Pages And Their Values In 1 (114.3 KiB) Viewed 81 times

5. Crash recovery for steal, no-force policy: The following list gives pages, objects on these pages and their values in the stable database at a certain point in time: Page 1: x = 63 y = 84 Page 2: z = 93 k = 24 The following is the list of the most recent stable log records at the same point in time. The database uses the steal, no-force policy. [nr: 320, ta: 12, obj: z, b: 23, a: 93] [nr: 321, ta: 13, obj: k, b: 34, a: 24] [nr: 322, ta: 12, obj:z, b: 93, a: 54] [nr: 323, ta: 12, obj: y, b: 84, a: 87] [nr: 324, ta: 12, commit] [nr: 325, ta: 14, obj: x, b: 63, a: 64] [nr: 326, redoLsn: 320, undoLsn: 321] [nr: 327, ta: 14, obj: y, b: 87, a: 65) a) You are supposed to perform crash recovery. What operations do you have to perform on which transactions? Give the content of the stable database after the crash recovery. b) Was a database buffer page with an uncommitted write written to the stable database? If yes, say which page and identify the time interval when it was written to the stable database. Give the interval as two log sequence numbers before and after, and say how you came to that conclusion. If no, give reasons for your answer. [8 marks]