1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

What is the Difference between incomplete recovery and complete recovery?

Discussion in 'Security, Backup and Recovery' started by kimipatel, Sep 17, 2012.

  1. kimipatel

    kimipatel Active Member

    Messages:
    53
    Likes Received:
    1
    Trophy Points:
    140
    Hi,

    What is the Difference between incomplete recovery and complete recovery?Which stage we decide we need incomplete or complete recovery..?

    Thanks
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Incomplete recovery is used when you want to recover to a specific point in time prior to the most recent log transactions; you can do this by time or by change (SCN). An example of this would be:

    You have a level 0 backup from Sunday, September 9th and level 1 incrementals until today. Development needs a copy of the database through September 12th at midnight. A restore and recover until time (09-13-2012 00:00:00) would be an incomplete recovery [we go to the next day at midnight to recover all of the transactions through the end of the day on September 12].

    A complete recovery is one where a recover database is run until no more logs are available -- the database is brought current through the current day and time available in the redo/archive logs.
     
  3. kimipatel

    kimipatel Active Member

    Messages:
    53
    Likes Received:
    1
    Trophy Points:
    140
    Thanks.. Nice example you give me for better understood... I really appreciate your answer.. Thanks a lot....