Is Memory involved in Media recovery ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Is Memory involved in Media recovery ?

  1. #1
    Join Date
    Sep 2002
    Posts
    376

    Is Memory involved in Media recovery ?

    Hi,
    When Oracle is doing instance recovery or when we are doing Media recovery, is any part of the Memory involved.
    Or does oracle writes directly to the datafile or does it pass through the any part of th memory(sga). ?If so which part ?

  2. #2
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    Rman use large_pool_size during backup and recovery.
    Best wishes!
    Dmitri

  3. #3
    Join Date
    Sep 2002
    Posts
    376
    But what about in normal recovery ?

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Buffer cache is havily involved in any kind of recovery. Redo/archived logs contain change vectors and those changes must be performed on actual database blocks. That can be done only inside buffer cache and those changed blocks are then written to disks by DBWR. After all, that's why roll-forward part of recovery is also often refered to as cache recovery.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  5. #5
    Join Date
    Sep 2002
    Posts
    376
    Thanx Jurji,

    I have some more doubts,

    If the changes are done again in the Buffer cache,
    does redo also gets generated for these and is log buffer is also involved.....
    can u tell me the exact flow, how it goes about

  6. #6
    Join Date
    Sep 2002
    Posts
    376
    Hi,
    could somebody tell me about this

  7. #7
    Join Date
    Jul 2001
    Location
    Indiana, USA
    Posts
    6
    What you're asking is much too complicated to explained in a forum post. I suggest you read Oracle's documentation on Backup and Recovery for more information. You will certainly, and fairly easily, find the answer you're looking for.

    Good luck,

    Kevin

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