Hi
While performing rman full database backup with compression the backup generates small set of many files
even though the following configurations are used
Rman Configuration
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 32 G;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 32 G;
CONFIGURE CHANNEL 2 DEVICE TYPE DISK MAXPIECESIZE 32 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
Backup command
run {
backup as compressed backupset incremental level 0 tag DB_FULL_$TDAY format '$backup_dir/DB_INCFULL_%U_$TDAY.Bkp' database;
sql 'alter system archive log current';
backup as compressed backupset archivelog all tag = ARCH_FULL_$TDAY format '$backup_dir/ARCH_%U_$TDAY.Bkp' delete all input;
backup current controlfile tag = CTL_FULL_$TDAY format '$backup_dir/CTL_%d_DBID%I_%U_$TDAY.Bkp';
CROSSCHECK BACKUP;
DELETE FORCE NOPROMPT OBSOLETE DEVICE TYPE DISK;
DELETE NOPROMPT EXPIRED BACKUP;
delete noprompt archivelog until time 'sysdate-1/24';
}
Backup Files
DB_INCFULL_gqusgohh_1_1_31032020.Bkp,DB_INCFULL_gsusgot4_1_1_31032020.Bkp ... like 132 files
Could any one help to find the root cause for it
We require to keep backup piece in a large file up ,say 32GB in size that is easy manage the files.
Thanks