which backgroundnprocess works when we perform recover
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: which backgroundnprocess works when we perform recover

  1. #1
    Join Date
    Feb 2009
    Posts
    49

    which backgroundnprocess works when we perform recover

    which background process works in background when we perform recovery

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    I can picture SMON and DBWn doing most of the leg work.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Feb 2009
    Posts
    49
    SMON ok.But how come DBWn....Can you pls expain in detail..what about RECO....?

    But still I think SMON will come in to picture for automatic instance recovery.....I was asking manual recovery.....

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Why DBWn? let me answer with a question: Who writes to the datafiles?

    RECO process is related to distributed transactions, not to database recovery.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    Feb 2009
    Location
    Azerbaijan, Baku
    Posts
    24
    SMON - performs instance recovery

    PMON - performs process recovery (user process) which cleans up database buffer cache and frees resources that the user process was using

    DBW - When we issue recovery, archive redo log files begin to apply to data files. It's DBW duty

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