3 Replies Latest reply on May 3, 2010 5:44 AM by 657203

    Incremental Backup using RMAN

    user645399
      Dear Buddies,

      Need some light on this.

      backup incremental level 1 for recover of copy
      with tag 'incremental_update' level 0 database;

      or

      run

      recover copy of database with tag 'incremental_update';
      backup incremental level 1
      for recover of copy with tag 'incremental_update'
      database;
      }

      Do they perform the same?

      I have a doubt about this backup, does it do the incremental backup and apply them to the level 0 backup immediately? or only when recovery takes place? or at the end of a certain period.
      The incremental backups are not needed when the next 0 level backup is taken.

      Please advice.

      With Regards,

      Nith
        • 1. Re: Incremental Backup using RMAN
          Chinar
          Hi,yes incremental backup immediately apply to 0 level backup using "RECOVER COPY OF DATABASE WITH TAG 'incr_tag'" statement . And when you take 0 level backup (full) then already do not need previous incremental 1 level backup. Also you can use as :

          RUN {
          BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'incr_TAG'
          DATABASE;
          RECOVER COPY OF DATABASE WITH TAG 'incr_TAG';
          }
          • 2. Re: Incremental Backup using RMAN
            Chinar
            see also http://www.comp.dit.ie/btierney/Oracle11gDoc/backup.111/b28273/rcmsynta007.htm
            • 3. Re: Incremental Backup using RMAN
              657203
              This is called Incrementally Updated Backup which is new feature starting from 10g.

              With this Incremental Merge approach, the daily RMAN incremental backup
              script will look like :

              RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY
              WITH TAG WEEKLY DATABASE;

              RMAN> RECOVER COPY OF DATABASE WITH TAG WEEKLY;

              When this command is executed every day, the incremental backups are applied
              to the Level 0 backup with the tag WEEKLY. Each incremental backup is merged
              with the current full backup, making it a complete up-to-date backup as of
              that day.