2 Replies Latest reply: Jul 18, 2014 1:33 AM by Hemant K Chitale RSS

    Archivelog backup job conflicting with L1 backup job

    John_75

      DB Version: 11.2.0.4

      Platform: RHEL 6.3

       

       

      We have an archivelog backup that starts at 10:00 PM and an Incremental backup that starts at 11:50PM.

      The archivelog backup usually finishes at 11:00PM. But, lately , it has been taking longer.Sometimes it finishes only at 12:30AM which is like 40minutes after the incremental backup has started. ie Archivelog backup is overlapping with the Incremental backup.

       

      One of our colleagues suggested to add "FILESPERSET 1" to speed up archivelog backup. So he changed the archivelog backup script from

       

      BACKUP FORMAT 'manhArc_%s_%p_%t' ARCHIVELOG ALL DELETE ALL INPUT;

      to

      BACKUP FILESPERSET 1 FORMAT 'manhArc_%s_%p_%t' ARCHIVELOG ALL DELETE ALL INPUT;

       

      The rationale he gave was that "this will prevent the channels getting stuck with some inaccesible archivelogs"

       

      Question1. Is adding "FILESPERSET 1" actually helpful in this scenario ?

       

      Question2. "FILESPERSET 1" in archivelog script means 1 backup piece for each archivelog. Right ? That means a lot of backup pieces in the backup media.