RMAN backups clarification - Incremental Level=0 (Cumulative/Differential)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: RMAN backups clarification - Incremental Level=0 (Cumulative/Differential)

  1. #1
    Join Date
    Oct 2002
    Posts
    807

    RMAN backups clarification - Incremental Level=0 (Cumulative/Differential)

    What is the difference between the below RMAN commands? Note: They are Level 0. Also, these are all syntactically correct and acceptable to RMAN

    1) "BACKUP INCREMENTAL LEVEL = 0 CUMULATIVE"
    2) "BACKUP INCREMENTAL LEVEL = 0 INCREMENTAL"
    3) "BACKUP INCREMENTAL LEVEL = 0"

    I've read the TRMs..but they don't clarify the above question. Yes, I understand the difference between cumulative and incremental backups..but I don't understand the context in a "level 0" backup. I thought (and documentation states) a level 0 always included ALL the blocks that have ever been modified!

    So what do commands "1" and "2" do? - compare the previous level 0 SCN to do a cumulative/incr backup respectively?!

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    AFAIK, no diff between all.
    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
    Oct 2002
    Posts
    807
    Thanks. No idea why RMAN syntactically accepts the Cumulative or Incremental parameter with a Level 0. I'd seen a bunch of folks post their scripts on Metalink with such parameters! It led me to wonder..hence the question.

    Anyway, when I get the time I'll kick off all the below..will post if there's any significant difference in the backup size. Hopefully there won't be any!

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