DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2005

    RMAN Incrmental backup clarification

    I was reading RMAN book. FOr diffrential, it's all clear but I have question about incremental backup method:

    If you have Sunday backup as level 0, this will backup the entire database. You do level 2 backup on Monday so whatever blocks changed from Sunday to Monday will be backup. you do another level 2 backup on tues so RMAN will backup blocks changed from Mon to Tues and from Sun to Mon as well.

    Let's say, you do level 1 backup on Wed, the book said it will contain all the block changed from Monday, Tues and Wed. Thing I am not clear is that if level 2 will backup whatever the changed on Mon and Tues, why can't we do another level 2 backup on Wed instead of level 1??? Why do we need level 1 on Wed ????

    thanks and have a great weekend.

  2. #2
    Join Date
    Nov 2000
    you can do another level 2 on Wednesday, there's nothing stopping you. The point to a level 1 is to reduce the mean time to recovery (MTTR) if your database dies Friday. If you had a bunch of level 2's, you would have to apply Mon, Tue, Wed, Thur, Fri. If you had a level 1 on Wed, you would have to apply Wed, Thu, Fri.

    Personally, I like Level 0 on the weekend and Level 1 cumulative on the other days. This way you are (almost) assured of applying only the latest level 1 during a restore.
    Jeff Hunter
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jan 2005
    that made sense.

    As usual, thanks so much for your help.

  4. #4
    Join Date
    Jan 2005
    I have another question regarding about RMAN.

    Let's say, if you have a full backup on the weekend and incremental backup on the weekday, I am thinking about splitting these into two folder: one call D:\BACKUP\FULL and one for D:\BACKUP\INCREMENTAL.

    The reason I am doign this so that the SYS admin can backup the FULL folder on the weekend and INCREMENTAL folder on the weekday so that it cut down the backup time and resources on the weekday.

    1. is it how you guys set up in your shop???
    2. any issues for recovery????

    thanks again

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.