DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: media/crash and instance recovery

  1. #1
    Join Date
    Feb 2009
    Posts
    49

    media/crash and instance recovery

    Hi,
    What is the difference between media,crash and instance recovery....?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    media is when you are recovering media (datafiles etc)
    crash is when you are recovering from a crash
    instance is recovering the instance

    you could really merge them into one term called recovery and be done with it

  3. #3
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    instance recovery is done automatically by SMON. it is reqd in case of abonormal shutdown such as shutdown abort or any such reason.
    Instance recovery is recovery of a single database instance. It is also called crash recovery if ur database has only instance.
    Crash recovery is recovery of all instances in database.

  4. #4
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    abt media recovery, this 1 may help u as i also found it useful.
    http://dbapool.com/articles/1029200701.html

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