Incremental Backups in RMAN
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Incremental Backups in RMAN

  1. #1
    Join Date
    Dec 2001
    Posts
    337

    Incremental Backups in RMAN

    Hi all,

    I was just wondering using about incremental backup strategy with RMAN. What is the effect of doing an incremenal backup level 0 every day? Does it mean that whole db will be backep daily or does it mean only changed blocks are being backed up?. Reason i ask is that i have been noticing that our backup sizes have been going down and was wondering if this has anything to do with it!

    Thanks in advance,
    Chucks

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Level 0 = Full backup.

    Level 1 = Incremental backup.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Dec 2001
    Posts
    337
    Thanks for that. So that means taking a full backup would mean the size of backup increasing marginally, so i am now wondering why the backups vary in size i.e it was 12G last night and 25G last week?

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    All RMAN backups backup blocks that have been used at some point. Blockes never used are not backed up. For example, you have a table that takes up 1000 blocks. You then truncate this table and you have 1000 blocks that have been used, but are empty. Logically, you would think that your backup would skip those empty blocks, but it doesn't. Those blocks continue to be backed up along with blocks that contain data.

    I am guessing you are running into a scenario where you had a bunch of empty blocks being backed up and something happened in your DB (drop tablespace, resize datafile down, etc.) that got rid of those empty blocks.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Jan 2004
    Location
    Paris, France
    Posts
    52

    Re: Incremental Backups in RMAN

    Originally posted by Chucks_k
    What is the effect of doing an incremenal backup level 0 every day? Does it mean that whole db will be backep daily or does it mean only changed blocks are being backed up?.
    Chucks [/B]
    The only difference between a full backup and a Level 0 Inc backup is that Level 0 Inc backup can be use as a reference for higher level inc backup whereas full backup can not.

    Latyr

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