physical and logical backup
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: physical and logical backup

  1. #1
    Join Date
    Jul 2007
    Posts
    8

    physical and logical backup

    Hi

    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
    Location
    İstanbul/Turkey
    Posts
    25
    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
    Posts
    8
    thanks a lot balki.........
    Last edited by instance; 07-30-2007 at 06: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