How to distribute the datafiles backup with FILESPERSET in RMAN Backupset in Oracle
FILESPERSET is defined as the number of files being allowed by each channel at a time
to create a backup set.
IF FILESPERSET is set to 5, then no more than 5 files are included in the backup set.
Performance: FILESPERSET parameter help increase parallelism defined according to your need and helps transport the big backupset files into small sizes and easy to transport. So choose this parameter helps in parallelism when we are restoring the database. So choose it wisely.
Example: if FILESPERSET is set to 5 then 10 channels are allocated in the RMAN backup
and there are 100 datafiles in the Oracle database then each channel will read 5 files
at a time and creates one backup set for five data files and once the five data files
backup completes the channel moves to the next five data files and creates a new backupset.
.RMAN Syntax:
run {
allocate channel c01 type disk;
allocate channel c02 type disk;
allocate channel c03 type disk;
allocate channel c04 type disk;
allocate channel c05 type disk;
backup
incremental level = 0
filesperset = 5
database;
}