Use of RMAN maxpiecesize command
To avoid large size of backupset we can set maxpiecesize of rman backup piece.
I have taken following backup without setting any parameter :
RMAN> backup database; Starting backup at 29-DEC-17 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=8 device type=DISK channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00001 name=D:\ORACLE\ORADATA\TEST1\SYSTEM01.DBF input datafile file number=00002 name=D:\ORACLE\ORADATA\TEST1\SYSAUX01.DBF input datafile file number=00003 name=D:\ORACLE\ORADATA\TEST1\UNDOTBS01.DBF input datafile file number=00004 name=D:\ORACLE\ORADATA\TEST1\USERS01.DBF channel ORA_DISK_1: starting piece 1 at 29-DEC-17 channel ORA_DISK_1: finished piece 1 at 29-DEC-17 piece handle=D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T195530_F4DN2VNO_.BKP tag=TAG20171229T195530 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:01:05 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current control file in backup set including current SPFILE in backup set channel ORA_DISK_1: starting piece 1 at 29-DEC-17 channel ORA_DISK_1: finished piece 1 at 29-DEC-17 piece handle=D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NCSNF_TAG20171229T195530_F4DN4XYX_.BKP tag=TAG20171229T195530 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02 Finished backup at 29-DEC-17
By list backup command we can see all details of backup , here we can see my backup set size is 1013.84M.
RMAN> list backup; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 1 Full 9.36M DISK 00:00:02 29-DEC-17 BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20171229T194540 Piece Name: D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NCSNF_TAG20171229T194540_F4DMJGYG_.BKP SPFILE Included: Modification time: 29-DEC-17 SPFILE db_unique_name: TEST1 Control File Included: Ckp SCN: 894345 Ckp time: 29-DEC-17 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 2 Full 1013.84M DISK 00:00:59 29-DEC-17 BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20171229T195530 Piece Name: D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T195530_F4DN2VNO_.BKP List of Datafiles in backup set 2 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 895016 29-DEC-17 D:\ORACLE\ORADATA\TEST1\SYSTEM01.DBF 2 Full 895016 29-DEC-17 D:\ORACLE\ORADATA\TEST1\SYSAUX01.DBF 3 Full 895016 29-DEC-17 D:\ORACLE\ORADATA\TEST1\UNDOTBS01.DBF 4 Full 895016 29-DEC-17 D:\ORACLE\ORADATA\TEST1\USERS01.DBF BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 3 Full 9.36M DISK 00:00:02 29-DEC-17 BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20171229T195530 Piece Name: D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NCSNF_TAG20171229T195530_F4DN4XYX_.BKP SPFILE Included: Modification time: 29-DEC-17 SPFILE db_unique_name: TEST1 Control File Included: Ckp SCN: 895040 Ckp time: 29-DEC-17 RMAN>
now configure maxpiecesize to 50M.
RMAN> configure channel device type disk maxpiecesize 50m; new RMAN configuration parameters: CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 50 M; new RMAN configuration parameters are successfully stored released channel: ORA_DISK_1
then take full backup of database using RMAN backup database command .
RMAN> backup database; Starting backup at 29-DEC-17 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=8 device type=DISK channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00001 name=D:\ORACLE\ORADATA\TEST1\SYSTEM01.DBF input datafile file number=00002 name=D:\ORACLE\ORADATA\TEST1\SYSAUX01.DBF input datafile file number=00003 name=D:\ORACLE\ORADATA\TEST1\UNDOTBS01.DBF input datafile file number=00004 name=D:\ORACLE\ORADATA\TEST1\USERS01.DBF channel ORA_DISK_1: starting piece 1 at 29-DEC-17 channel ORA_DISK_1: finished piece 1 at 29-DEC-17 piece handle=D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNJ09L_.BKP tag=TAG20171229T200231 comment=NONE channel ORA_DISK_1: starting piece 2 at 29-DEC-17 channel ORA_DISK_1: finished piece 2 at 29-DEC-17 piece handle=D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNJ783_.BKP tag=TAG20171229T200231 comment=NONE channel ORA_DISK_1: starting piece 3 at 29-DEC-17 channel ORA_DISK_1: finished piece 3 at 29-DEC-17 piece handle=D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNJGCC_.BKP tag=TAG20171229T200231 comment=NONE channel ORA_DISK_1: starting piece 4 at 29-DEC-17 channel ORA_DISK_1: finished piece 4 at 29-DEC-17 piece handle=D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNJODM_.BKP tag=TAG20171229T200231 comment=NONE channel ORA_DISK_1: starting piece 5 at 29-DEC-17 channel ORA_DISK_1: finished piece 5 at 29-DEC-17 piece handle=D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNJWG6_.BKP tag=TAG20171229T200231 comment=NONE channel ORA_DISK_1: starting piece 6 at 29-DEC-17 channel ORA_DISK_1: finished piece 6 at 29-DEC-17 piece handle=D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNJZGK_.BKP tag=TAG20171229T200231 comment=NONE channel ORA_DISK_1: starting piece 7 at 29-DEC-17 channel ORA_DISK_1: finished piece 7 at 29-DEC-17 piece handle=D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNK2HM_.BKP tag=TAG20171229T200231 comment=NONE channel ORA_DISK_1: starting piece 8 at 29-DEC-17 channel ORA_DISK_1: finished piece 8 at 29-DEC-17 piece handle=D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNK5H1_.BKP tag=TAG20171229T200231 comment=NONE channel ORA_DISK_1: starting piece 9 at 29-DEC-17 channel ORA_DISK_1: finished piece 9 at 29-DEC-17 piece handle=D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNK8HQ_.BKP tag=TAG20171229T200231 comment=NONE channel ORA_DISK_1: starting piece 10 at 29-DEC-17 channel ORA_DISK_1: finished piece 10 at 29-DEC-17 piece handle=D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNKCK3_.BKP tag=TAG20171229T200231 comment=NONE channel ORA_DISK_1: starting piece 11 at 29-DEC-17 channel ORA_DISK_1: finished piece 11 at 29-DEC-17 piece handle=D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNKGMC_.BKP tag=TAG20171229T200231 comment=NONE channel ORA_DISK_1: starting piece 12 at 29-DEC-17 channel ORA_DISK_1: finished piece 12 at 29-DEC-17 piece handle=D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNKKM5_.BKP tag=TAG20171229T200231 comment=NONE channel ORA_DISK_1: starting piece 13 at 29-DEC-17 channel ORA_DISK_1: finished piece 13 at 29-DEC-17 piece handle=D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNKNMV_.BKP tag=TAG20171229T200231 comment=NONE channel ORA_DISK_1: starting piece 14 at 29-DEC-17 channel ORA_DISK_1: finished piece 14 at 29-DEC-17 piece handle=D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNKQO7_.BKP tag=TAG20171229T200231 comment=NONE channel ORA_DISK_1: starting piece 15 at 29-DEC-17 channel ORA_DISK_1: finished piece 15 at 29-DEC-17 piece handle=D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNKTT2_.BKP tag=TAG20171229T200231 comment=NONE channel ORA_DISK_1: starting piece 16 at 29-DEC-17 channel ORA_DISK_1: finished piece 16 at 29-DEC-17 piece handle=D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNKXTF_.BKP tag=TAG20171229T200231 comment=NONE channel ORA_DISK_1: starting piece 17 at 29-DEC-17 channel ORA_DISK_1: finished piece 17 at 29-DEC-17 piece handle=D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNL0YG_.BKP tag=TAG20171229T200231 comment=NONE channel ORA_DISK_1: starting piece 18 at 29-DEC-17 channel ORA_DISK_1: finished piece 18 at 29-DEC-17 piece handle=D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNL40L_.BKP tag=TAG20171229T200231 comment=NONE channel ORA_DISK_1: starting piece 19 at 29-DEC-17 channel ORA_DISK_1: finished piece 19 at 29-DEC-17 piece handle=D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNL70X_.BKP tag=TAG20171229T200231 comment=NONE channel ORA_DISK_1: starting piece 20 at 29-DEC-17 channel ORA_DISK_1: finished piece 20 at 29-DEC-17 piece handle=D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNLB3B_.BKP tag=TAG20171229T200231 comment=NONE channel ORA_DISK_1: starting piece 21 at 29-DEC-17 channel ORA_DISK_1: finished piece 21 at 29-DEC-17 piece handle=D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNLF6D_.BKP tag=TAG20171229T200231 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:01:20 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current control file in backup set including current SPFILE in backup set channel ORA_DISK_1: starting piece 1 at 29-DEC-17 channel ORA_DISK_1: finished piece 1 at 29-DEC-17 piece handle=D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NCSNF_TAG20171229T200231_F4DNLKFX_.BKP tag=TAG20171229T200231 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 29-DEC-17
Check backup piece size using list backup command .
RMAN> list backup; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 1 Full 9.36M DISK 00:00:02 29-DEC-17 BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20171229T194540 Piece Name: D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NCSNF_TAG20171229T194540_F4DMJGYG_.BKP SPFILE Included: Modification time: 29-DEC-17 SPFILE db_unique_name: TEST1 Control File Included: Ckp SCN: 894345 Ckp time: 29-DEC-17 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 2 Full 1013.84M DISK 00:00:59 29-DEC-17 BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20171229T195530 Piece Name: D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T195530_F4DN2VNO_.BKP List of Datafiles in backup set 2 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 895016 29-DEC-17 D:\ORACLE\ORADATA\TEST1\SYSTEM01.DBF 2 Full 895016 29-DEC-17 D:\ORACLE\ORADATA\TEST1\SYSAUX01.DBF 3 Full 895016 29-DEC-17 D:\ORACLE\ORADATA\TEST1\UNDOTBS01.DBF 4 Full 895016 29-DEC-17 D:\ORACLE\ORADATA\TEST1\USERS01.DBF BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 3 Full 9.36M DISK 00:00:02 29-DEC-17 BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20171229T195530 Piece Name: D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NCSNF_TAG20171229T195530_F4DN4XYX_.BKP SPFILE Included: Modification time: 29-DEC-17 SPFILE db_unique_name: TEST1 Control File Included: Ckp SCN: 895040 Ckp time: 29-DEC-17 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 4 Full 1014.35M DISK 00:01:19 29-DEC-17 List of Datafiles in backup set 4 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 895212 29-DEC-17 D:\ORACLE\ORADATA\TEST1\SYSTEM01.DBF 2 Full 895212 29-DEC-17 D:\ORACLE\ORADATA\TEST1\SYSAUX01.DBF 3 Full 895212 29-DEC-17 D:\ORACLE\ORADATA\TEST1\UNDOTBS01.DBF 4 Full 895212 29-DEC-17 D:\ORACLE\ORADATA\TEST1\USERS01.DBF Backup Set Copy #1 of backup set 4 Device Type Elapsed Time Completion Time Compressed Tag ----------- ------------ --------------- ---------- --- DISK 00:01:19 29-DEC-17 NO TAG20171229T200231 List of Backup Pieces for backup set 4 Copy #1 BP Key Pc# Status Piece Name ------- --- ----------- ---------- 4 1 AVAILABLE D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNJ09L_.BKP 5 2 AVAILABLE D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNJ783_.BKP 6 3 AVAILABLE D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNJGCC_.BKP 7 4 AVAILABLE D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNJODM_.BKP 8 5 AVAILABLE D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNJWG6_.BKP 9 6 AVAILABLE D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNJZGK_.BKP 10 7 AVAILABLE D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNK2HM_.BKP 11 8 AVAILABLE D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNK5H1_.BKP 12 9 AVAILABLE D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNK8HQ_.BKP 13 10 AVAILABLE D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNKCK3_.BKP 14 11 AVAILABLE D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNKGMC_.BKP 15 12 AVAILABLE D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNKKM5_.BKP 16 13 AVAILABLE D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNKNMV_.BKP 17 14 AVAILABLE D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNKQO7_.BKP 18 15 AVAILABLE D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNKTT2_.BKP 19 16 AVAILABLE D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNKXTF_.BKP 20 17 AVAILABLE D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNL0YG_.BKP 21 18 AVAILABLE D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNL40L_.BKP 22 19 AVAILABLE D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNL70X_.BKP 23 20 AVAILABLE D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNLB3B_.BKP 24 21 AVAILABLE D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NNNDF_TAG20171229T200231_F4DNLF6D_.BKP BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 5 Full 9.36M DISK 00:00:01 29-DEC-17 BP Key: 25 Status: AVAILABLE Compressed: NO Tag: TAG20171229T200231 Piece Name: D:\ORACLE\FAST_RECOVERY_AREA\TEST1\BACKUPSET\2017_12_29\O1_MF_NCSNF_TAG20171229T200231_F4DNLKFX_.BKP SPFILE Included: Modification time: 29-DEC-17 SPFILE db_unique_name: TEST1 Control File Included: Ckp SCN: 895239 Ckp time: 29-DEC-17 RMAN>
Here we can see BP key [backup piece key] under Backup Set , 21 different backup pieces are created.
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
Anuradha’s LinkedIn: Anuradha’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
