2 Replies Latest reply: Jan 28, 2013 8:57 AM by 908753 RSS

    Parallel backup vs section backup

    908753
      Hi, i would like to know whats the difference between a configured backup with parallel channels and the "section size" parameter in these cases.


      CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
      run{
      ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT '/disk1/backups/%U';
      ALLOCATE CHANNEL disk2 DEVICE TYPE DISK FORMAT '/disk2/backups/%U';
      ALLOCATE CHANNEL disk3 DEVICE TYPE DISK FORMAT '/disk3/backups/%U';
      ALLOCATE CHANNEL disk4 DEVICE TYPE DISK FORMAT '/disk4/backups/%U';
      BACKUP TABLESPACE USERS;
      }

      comparated with this:


      CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
      run{
      ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT '/disk1/backups/%U';
      ALLOCATE CHANNEL disk2 DEVICE TYPE DISK FORMAT '/disk2/backups/%U';
      ALLOCATE CHANNEL disk3 DEVICE TYPE DISK FORMAT '/disk3/backups/%U';
      ALLOCATE CHANNEL disk4 DEVICE TYPE DISK FORMAT '/disk4/backups/%U';
      BACKUP TABLESPACE USERS SECTION SIZE 25G;
      }
      In this case could SECTION SIZE parameter improve performance?


      Thanks.
      Paulo.