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

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.