DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2007

    physical and logical backup


    I havae read concepts like BACKUP. I am not able to understand what is the difference between physical backup and logical backup..?
    what is the difference between cache recovery and instance recovery...?
    could you pls explain me in detail....?

    Thanks and Regards

  2. #2
    Join Date
    Jun 2007
    physical backup is to copy for backing up all the pyhsical files that belongs to database.(like datafiles,controlfiles,logfiles,executables etc).
    In logical backup,you dont take the copies of any physical things,you only extract the data from the datafiles into dump files.(ex : using export )
    instance recovery:The automatic application of redo log records to Oracle uncommitted data blocks after a crash or system failure.
    cache recovery:The part of instance recovery where Oracle applies all committed and uncommitted changes in the redo log files to the affected data blocks. Also known as the rolling forward phase of instance recovery.

  3. #3
    Join Date
    Jul 2007
    thanks a lot balki.........
    Last edited by instance; 07-30-2007 at 05:37 AM.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.