Register Login

Difference between FILESPERSET and MAXOPENFILES in RMAN

Updated May 18, 2018

FILESPERSET vs MAXOPENFILES

Can someone please explain the concept of filesperset parameter in RMAN.

What is the difference between filesperset and maxopenfiles in RMAN? 

What filesperset value can be given for a database of 7TB size with 10channels allocated?


Comments

  • 07 Aug 2015 4:24 pm Abhijeet Mudgal Helpful Answer

    FILESPERSET is no of files being read by each channel at a time. For ex if FILESPERSET is 5 and 10 channels allocated and there are 50 datafiles, each channel will read 5 files at a time and creates one backupset for five datafiles and once the five datafiles backup completes the channel moves to next five datafiles and creates new backupset. 

    FILESPERSET is helpful during restore as the time taken for restoration will be less due to balancing of channels.


×