Methods and apparatus for updating information in a computer system using logs and state identifiers

• US 5,485,608 A
• Filed: 04/14/1994
• Issued: 01/16/1996
• Est. Priority Date: 06/29/1990
• Status: Expired due to Term

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle Corporation
• Inventors: Rangarajan, Tirumanjanam K., Lomet, David B., Raghavan, Ananth, Spiro, Peter M., Joshi, Ashok M.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Loomis, John C.
• Application Number:
  US08/227,491
• Time in Patent Office: 642 Days
• Field of Search: 395/600, 395/575, 395/650, 395/700
• US Class Current: 1/1
• CPC Class Codes: G06F 11/1471 involving logging of persistent data for recovery
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

A data processing system maintains logs for system and media recovery. The logs contain state identifiers each uniquely identifying the state of a corresponding section of a storage medium, such as a disk. The state identifiers are assigned after changes have been made such that they can be determined from the information in the logs. One implementation involves assigning state identifiers in a known sequence, such as in a monotonically increasing sequence of integers beginning with zero.

Claims

1. In a computer system including a plurality of nodes and a non-volatile storage medium, a method of managing updates to information stored in said non-volatile storage medium, said method comprising the steps of:

obtaining control of a selected section of a plurality of sections of said non-volatile storage medium;

extracting a first state identifier associated with said selected section, said first state identifier having a value corresponding to a state of said selected section before modification;

selecting a selected log from a plurality of logs, said plurality of logs having information concerning updates to be made to said plurality of sections, said selected log having an associated second state identifier corresponding to said first state identifier;

updating information in said selected section in accordance with an action specified in said selected log;

modifying said first state identifier to be a value corresponding to a state of said selected section alter being updated in accordance with said action specified in said selected log; and

releasing control of said selected section.

2. The method of claim 1 wherein said modifying step further includes a step of storing said modified first state identifier into said selected section.

3. The method of claim 1 wherein said modifying step further includes a step of deriving said modified first state identifier from an unmodified first state identifier.

4. The method of claim 3 wherein said first state identifier has one of a plurality of values which are ordered in a known sequence, and wherein said step of deriving said modified first state identifier further includes a step of:

selecting as a value for the modified first state identifier a value that is a succeeding value in said known sequence after said value of said unmodified first state identifier.

5. The method of claim 4 wherein said known sequence is a set of zero and the positive integers ordered in a monotonically increasing series, and wherein said modifying step further includes a step of:

incrementing said unmodified first state identifier by one to form said modified state identifier.

6. The method of claim 5 further including a step of:

writing said selected log onto said disk prior to writing said updated copy back to said disk.

7. The method of claim 3 wherein said step of releasing control of said selected section includes the step of:

removing said lock from said selected section.

8. The method of claim 3 wherein said non-volatile storage medium includes a magnetic disk organized into a plurality of blocks, and wherein said step of reading into said data base cache further includes the step of:

reading a selected block into said data base cache, wherein said step of updating said selected section further includes the step of;

updating said copy of said block in said data base cache to provide an updated copy of said block; and

wherein said step of releasing control of said selected section further includes a step of;

writing said updated copy of said block back to said disk.

9. The method of claim 1, wherein said step of obtaining control includes the steps of:

setting a lock on said selected section to prevent said selected section from being read except by said at least one node until said lock is removed; and

reading into a data base cache in a first node a copy of said selected section.

10. The method of claim 1 wherein said first state identifier is stored in said selected section, and

wherein said step of extracting said first state identifier further includes a step of:

reading said first state identifier out of said selected section.

11. The method of claim 10 wherein said step of modifying said first state identifier further includes a step of:

storing said modified first state identifier into said updated selected section.

12. The method of claim 1, where said computer system further includes a second node and said method further includes a step of:

determining that said modifying step and said releasing step are completed before said selected section is transferred to said second node.

13. The method of claim 1 wherein said modifying step further includes a step of selecting said selected log in a time-ordered sequence.

14. The method of claim 1 wherein said computer system includes a plurality of nodes including a first node, wherein each of said plurality of nodes is associated with at least one of said plurality of logs, and

wherein the step of modifying said first state identifier further includes a step of:

recording said modified first state identifier into a portion of one of said plurality of said logs associated with said first node.

15. A computer system, including a plurality of nodes and a non-volatile storage medium, for managing updates to information stored in said non-volatile storage medium, said computer system comprising:

means for obtaining control or a selected section of a plurality of sections of said non-volatile storage medium;

means for extracting a first state identifier associated with said selected section, said first state identifier having a value corresponding to a state of said selected section before modification;

means for selecting a selected log from a plurality of logs, said plurality of logs having information concerning updates to be made to said plurality of sections, said selected log having an associated second state identifier corresponding to said first state identifier;

means for updating information in said selected section in accordance with an action specified in said selected log;

means for modifying said first state identifier to be a value corresponding to a state of said selected section alter being updated in accordance with said action specified in said selected log; and

means for releasing control of said selected section.

16. The computer system of claim 15 wherein said means for modifying further includes a means for storing said modified first state identifier into said selected section.

17. The computer system of claim 15 wherein said means for modifying further includes a means for deriving said modified first state identifier from an unmodified first state identifier.

18. The computer system of claim 17 wherein said first state identifier has one of a plurality of values which are ordered in a known sequence, and wherein said means for deriving said modified first state identifier further includes:

means for selecting as a value for the modified first state identifier a value that is a succeeding value in said known sequence after said value of said unmodified first state identifier.

19. The computer system of claim 18 wherein said known sequence is a set of zero and the positive integers ordered in a monotonically increasing series, and wherein said means for modifying further includes:

means for incrementing said unmodified first state identifier by one to form said modified state identifier.

20. The computer system of claim 17 wherein said means for releasing control of said selected section further includes:

means for removing said lock from said selected section.

21. The computer system of claim 17 wherein said non-volatile storage medium includes a magnetic disk organized into a plurality of blocks, and wherein said means for reading into said data base cache further includes:

means for reading a selected block into said data base cache, wherein said means for updating said selected section further includes;

means for updating said copy of said block in said data base cache to provide an updated copy of said block; and

wherein said means for releasing control of said selected section further includes;

means for writing said updated copy of said block back to said disk.

22. The computer system of claim 21 further including:

means for writing said selected log onto said disk prior to writing said updated copy back to said disk.

23. The computer system of claim 15, wherein said means for obtaining control further includes:

means for setting a lock on said selected section to prevent said selected section from being read except by said at least one node until said lock is removed; and

means for reading into a data base cache in a first node a copy of said selected section.

24. The computer system of claim 15 wherein said first state identifier is stored in said selected section, and

wherein said means for extracting said first state identifier further includes:

means for reading said first state identifier out of said selected section.

25. The computer system of claim 24 wherein said means for modifying said first state identifier further includes:

means for storing said modified first state identifier into said updated selected section.

26. The computer system of claim 15, wherein said computer system further includes a second node and said computer system further includes:

means for determining that said means for modifying and said means for releasing have completed before said selected section is transferred to said second node.

27. The computer system of claim 15 wherein said means for modifying further includes a means for selecting said selected log in a time-ordered sequence.

28. The computer system of claim 15 wherein said computer system includes a plurality of nodes including a first node, wherein each of said plurality of nodes is associated with at least one of said plurality of logs, and

wherein said means for modifying said first state identifier further includes:

means for recording said modified first state identifier into a portion of one of said plurality of said logs associated with said first node.