Instance Recovery
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Instance Recovery

  1. #1
    Join Date
    Apr 2003
    Location
    Chennai - India
    Posts
    8

    Instance Recovery

    Hi All,

    During data modification according to my perspective the following actions are performed.

    1. pulls data from the data file to the database buffer cache if the data is not available in the buffer.
    2. user is modifiying the data and issues commit.
    3. changes gets logged into redo log file.
    4. after some interval, chkpt occurs - the LGWR pushes the data from the redo buffer to redo data file.
    5. then DBWR writes the data from the data buffer cache to the data file.

    So DBWR will be performed after the LGWR finishes its job.

    If the above statements are true, then I have some doubt in instance recovery.

    If the datafile has all the latest changes then what happens at instance recovery stage. The changes made are available in the redo log file and datafile as well.

    Correct me if I am wrong

    Thanks in advance.
    Thanks and Regards
    Ramu Ganapathi

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142

    Re: Instance Recovery

    Originally posted by ramuganapathi
    2. user is modifiying the data and issues commit.
    3. changes gets logged into redo log file.
    4. after some interval, chkpt occurs - the LGWR pushes the data from the redo buffer to redo data file.
    A commit will not return control (e.g. to the next instruction) until all the redo data for the transaction has been physically written to the redo log file(s) - the check point does NOT do that.
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  3. #3
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    If you are worried about UNcommited changes see the post by Thomasps here: http://www.dbasupport.com/forums/sho...0&pagenumber=4
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width