Hello expert,
I was trying to experiment which command give me better performance for rman backup section size clause or maxpiecesize clause? I could not do that because both can not be used together.Can anybody tell me which one to be used for good performance?
RMAN> @section.rcv
RMAN> backup incremental level 0 database section size 20G;
Starting backup at 12-OCT-17
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=859 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=953 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=1048 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=1145 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 10/12/2017 10:21:58
RMAN-06808: SECTION SIZE cannot be used when piece limit is in effect
RMAN> **end-of-file**
My rman settings
RMAN configuration parameters for database with db_unique_name CCBX are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 8 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET PARALLELISM 4;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK MAXOPENFILES 4 MAXPIECESIZE 10 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle_homes/appccbx/oracle/product/12.1.0.2/dbs/snapcf_ccbx.f'; # default
Regards
Dhritiman Deb