{"id":1322,"date":"2015-02-01T11:26:53","date_gmt":"2015-02-01T14:26:53","guid":{"rendered":"http:\/\/www.dbarj.com.br\/?p=1322"},"modified":"2015-02-01T11:42:58","modified_gmt":"2015-02-01T14:42:58","slug":"rman-real-usage-maxsetsize-maxpiecesize-filesperset-section-size-maxopenfiles","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/en\/2015\/02\/rman-real-usage-maxsetsize-maxpiecesize-filesperset-section-size-maxopenfiles\/","title":{"rendered":"RMAN real usage of MAXSETSIZE, MAXPIECESIZE, FILESPERSET, SECTION SIZE, MAXOPENFILES"},"content":{"rendered":"<p>Many people still don&#8217;t get the difference between all that configuration parameters that can be set up during a backup. In this article, I will explain how to use each of them, their differences and the theory behind.<\/p>\n<h2><span style=\"color: #800000;\"><strong>First the theory:<\/strong><\/span><\/h2>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline;\"><strong>Backup Set<\/strong><\/span><\/p>\n<p>Logical structure where the backup is stored. It is a logical container. A backup set can store one or multiple database files, spfiles, control files, etc. <span style=\"text-decoration: underline;\">Do not think physically<\/span>. One backup set can be stored in one or multiple files. Each of those files is called a backup piece. Usually, one backup set has only one backup piece.<\/p>\n<p><span style=\"text-decoration: underline;\"><strong>Backup Piece<\/strong><\/span><\/p>\n<p>Physical structure where the backup is stored. A backup set is composed by one or more physical binary pieces. If you backup to disk, each file generated is a backup piece.<\/p>\n<p><span style=\"text-decoration: underline;\"><strong>Multiplexed Backup Set<\/strong><\/span><\/p>\n<p>A backup set that contains multiple database files. For example, you could multiplex 10 datafiles into one backup set. Only whole files, never partial files, are included in a backup set.<\/p>\n<p>So, do not think that a part of your SYSTEM datafile will be in one backup set and another part of it will be on another backup set. This is <strong>impossible<\/strong>. If your TABLESPACE have more than one datafile, than you can have each datafile in a different backup set.<br \/>\nAlso, if your backup set is physically stored in more than one backup pieces (files), you can have your backed up datafile stored on multiple backup pieces (but not sets).<\/p>\n<p><span style=\"text-decoration: underline;\"><strong>Level of Multiplexing<\/strong><\/span><\/p>\n<p>This is the number of input files <span style=\"text-decoration: underline;\">simultaneously<\/span> read and then written into the same backup piece. So if you have a channel that is reading 4 datafiles at same time and writing them to a backup set, your level of multiplexing is 4. This\u00a0level is directly interfered by some\u00a0configuration parameters, like the max files that a set can have, the max open files read by a channel and the # of files you are currently backing up.<\/p>\n<p><span style=\"text-decoration: underline;\"><strong>File Section<\/strong><\/span><\/p>\n<p>A contiguous range of blocks in a datafile. One datafile is made by multiple sections.<\/p>\n<p><span style=\"text-decoration: underline;\"><strong>Multisection Backup<\/strong><\/span><\/p>\n<p>A backup set in which each backup piece contains a file section. A multisection backup set contains multiple backup pieces, but a backup set never contains only a part of a datafile.<\/p>\n<h2><span style=\"color: #800000;\">Now to practice:<\/span><\/h2>\n<p>&nbsp;<\/p>\n<p>Let&#8217;s use the concepts and play with <strong>MAXSETSIZE, MAXPIECESIZE, FILESPERSET, SECTION SIZE, MAXOPENFILES.<\/strong><\/p>\n<p>For the examples, I will use the following database:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">RMAN&gt; report schema;\r\n\r\nReport of database schema for database with db_unique_name DWQUAL01\r\n\r\nList of Permanent Datafiles\r\n===========================\r\nFile Size(MB) Tablespace           RB segs Datafile Name\r\n---- -------- -------------------- ------- ------------------------\r\n1    840      SYSTEM               ***     +DATA\/dwqual01\/datafile\/system.266.870358459\r\n2    1020     SYSAUX               ***     +DATA\/dwqual01\/datafile\/sysaux.265.870358459\r\n3    610      UNDOTBS1             ***     +DATA\/dwqual01\/datafile\/undotbs1.267.870358459\r\n4    5        USERS                ***     +DATA\/dwqual01\/datafile\/users.270.870358459\r\n5    256      AUDTBS               ***     +DATA\/dwqual01\/datafile\/audtbs.268.870358459\r\n6    15       DVTBS                ***     +DATA\/dwqual01\/datafile\/dvtbs.269.870358459<\/pre>\n<h4><span style=\"color: #000080;\"><strong>MAXSETSIZE<\/strong><\/span><\/h4>\n<p>Defines the maximum size of a backup set. The default MAXSETSIZE for a database is <strong>unlimited<\/strong>.<\/p>\n<p>For the example above, if I put the MAXSETSIZE to <strong>1019M<\/strong>, the backup fails:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">RMAN&gt; CONFIGURE MAXSETSIZE TO 1019M;\r\n\r\nnew RMAN configuration parameters:\r\nCONFIGURE MAXSETSIZE TO 1019 M;\r\nnew RMAN configuration parameters are successfully stored\r\n\r\nRMAN&gt; backup database;\r\n\r\nStarting backup at 31-JAN-15\r\nusing channel ORA_DISK_1\r\nRMAN-00571: ===========================================================\r\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\r\nRMAN-00571: ===========================================================\r\nRMAN-03002: failure of backup command at 01\/31\/2015 19:16:31\r\nRMAN-06183: datafile or datafile copy +DATA\/dwqual01\/datafile\/sysaux.265.870358459 (file number 2) larger than MAXSETSIZE<\/pre>\n<p>But if I change the MAXSETSIZE to 1020M, the backup will run:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">RMAN&gt; CONFIGURE MAXSETSIZE TO 1020M;\r\n\r\nold RMAN configuration parameters:\r\nCONFIGURE MAXSETSIZE TO 1019 M;\r\nnew RMAN configuration parameters:\r\nCONFIGURE MAXSETSIZE TO 1020 M;\r\nnew RMAN configuration parameters are successfully stored\r\n\r\nRMAN&gt; backup database;\r\n\r\nStarting backup at 31-JAN-15\r\nusing channel ORA_DISK_1\r\n...<\/pre>\n<p>Why?\u00a0Because one datafile cannot <strong>never<\/strong> be placed in more than one backup set (I&#8217;ve already told that in the theory section).<br \/>\nIf I limit the size of a backup set to a value lower than my biggest datafile, it won&#8217;t fit there.<br \/>\nSo, remember, that <strong>MAXSETSIZE<\/strong> should be at least as large as the largest datafile.<\/p>\n<h4><span style=\"color: #000080;\"><strong>MAXPIECESIZE<\/strong><\/span><\/h4>\n<p>Defines the maximum size of a backup piece. The default MAXPIECESIZE is <strong>unlimited<\/strong>.<\/p>\n<p>When it is set to default, your backup set is\u00a0usually stored in 1 backup piece (if to disk, this means one file per set).<\/p>\n<p>Let&#8217;s run a simple backup and check:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">RMAN&gt; backup database;\r\n\r\nStarting backup at 31-JAN-15\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=227 device type=DISK\r\nchannel ORA_DISK_1: starting full datafile backup set\r\nchannel ORA_DISK_1: specifying datafile(s) in backup set\r\ninput datafile file number=00002 name=+DATA\/dwqual01\/datafile\/sysaux.265.870358459\r\ninput datafile file number=00001 name=+DATA\/dwqual01\/datafile\/system.266.870358459\r\ninput datafile file number=00003 name=+DATA\/dwqual01\/datafile\/undotbs1.267.870358459\r\ninput datafile file number=00005 name=+DATA\/dwqual01\/datafile\/audtbs.268.870358459\r\ninput datafile file number=00006 name=+DATA\/dwqual01\/datafile\/dvtbs.269.870358459\r\ninput datafile file number=00004 name=+DATA\/dwqual01\/datafile\/users.270.870358459\r\nchannel ORA_DISK_1: starting piece 1 at 31-JAN-15\r\nchannel ORA_DISK_1: finished piece 1 at 31-JAN-15\r\npiece handle=+ARCHIVE\/dwqual01\/backupset\/2015_01_31\/nnndf0_tag20150131t232750_0.628.870478071 tag=TAG20150131T232750 comment=NONE\r\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:15\r\nchannel ORA_DISK_1: starting full datafile backup set\r\nchannel ORA_DISK_1: specifying datafile(s) in backup set\r\nincluding current control file in backup set\r\nincluding current SPFILE in backup set\r\nchannel ORA_DISK_1: starting piece 1 at 31-JAN-15\r\nchannel ORA_DISK_1: finished piece 1 at 31-JAN-15\r\npiece handle=+ARCHIVE\/dwqual01\/backupset\/2015_01_31\/ncsnf0_tag20150131t232750_0.627.870478087 tag=TAG20150131T232750 comment=NONE\r\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\r\nFinished backup at 31-JAN-15\r\n\r\nRMAN&gt; list backup;\r\n\r\n\r\nList of Backup Sets\r\n===================\r\n\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ ---------------\r\n60      Full    1.44G      DISK        00:00:08     31-JAN-15\r\n        BP Key: 600   Status: AVAILABLE  Compressed: NO  Tag: TAG20150131T232750\r\n        Piece Name: +ARCHIVE\/dwqual01\/backupset\/2015_01_31\/nnndf0_tag20150131t232750_0.628.870478071\r\n  List of Datafiles in backup set 60\r\n  File LV Type Ckp SCN    Ckp Time  Name\r\n  ---- -- ---- ---------- --------- ----\r\n  1       Full 1011911    31-JAN-15 +DATA\/dwqual01\/datafile\/system.266.870358459\r\n  2       Full 1011911    31-JAN-15 +DATA\/dwqual01\/datafile\/sysaux.265.870358459\r\n  3       Full 1011911    31-JAN-15 +DATA\/dwqual01\/datafile\/undotbs1.267.870358459\r\n  4       Full 1011911    31-JAN-15 +DATA\/dwqual01\/datafile\/users.270.870358459\r\n  5       Full 1011911    31-JAN-15 +DATA\/dwqual01\/datafile\/audtbs.268.870358459\r\n  6       Full 1011911    31-JAN-15 +DATA\/dwqual01\/datafile\/dvtbs.269.870358459\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ ---------------\r\n61      Full    13.73M     DISK        00:00:01     31-JAN-15\r\n        BP Key: 601   Status: AVAILABLE  Compressed: NO  Tag: TAG20150131T232750\r\n        Piece Name: +ARCHIVE\/dwqual01\/backupset\/2015_01_31\/ncsnf0_tag20150131t232750_0.627.870478087\r\n  SPFILE Included: Modification time: 30-JAN-15\r\n  SPFILE db_unique_name: DWQUAL01\r\n  Control File Included: Ckp SCN: 1011921      Ckp time: 31-JAN-15\r\n\r\nRMAN&gt;<\/pre>\n<p>As you can check above, simply running &#8220;backup database&#8221; with all the default configuration will create one backup set with all the datafiles, stored in a single backup piece, and another backup set with the spfile and control file in another single backup piece.<\/p>\n<p>Now let&#8217;s change the MAXPIECESIZE to <strong>50M<\/strong> and simulate the backup of one tablespace:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">RMAN&gt; CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 50M;\r\n\r\nnew RMAN configuration parameters:\r\nCONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 50 M;\r\nnew RMAN configuration parameters are successfully stored\r\n\r\nRMAN&gt; backup tablespace sysaux;\r\n\r\nStarting backup at 31-JAN-15\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=152 device type=DISK\r\nchannel ORA_DISK_1: starting compressed full datafile backup set\r\nchannel ORA_DISK_1: specifying datafile(s) in backup set\r\ninput datafile file number=00002 name=+DATA\/dwqual01\/datafile\/sysaux.265.870358459\r\nchannel ORA_DISK_1: starting piece 1 at 31-JAN-15\r\nchannel ORA_DISK_1: finished piece 1 at 31-JAN-15\r\npiece handle=+ARCHIVE\/dwqual01\/backupset\/2015_01_31\/nnndf0_tag20150131t192933_0.633.870463773 tag=TAG20150131T192933 comment=NONE\r\nchannel ORA_DISK_1: starting piece 2 at 31-JAN-15\r\nchannel ORA_DISK_1: finished piece 2 at 31-JAN-15\r\npiece handle=+ARCHIVE\/dwqual01\/backupset\/2015_01_31\/nnndf0_tag20150131t192933_0.632.870463777 tag=TAG20150131T192933 comment=NONE\r\nchannel ORA_DISK_1: starting piece 3 at 31-JAN-15\r\nchannel ORA_DISK_1: finished piece 3 at 31-JAN-15\r\npiece handle=+ARCHIVE\/dwqual01\/backupset\/2015_01_31\/nnndf0_tag20150131t192933_0.631.870463777 tag=TAG20150131T192933 comment=NONE\r\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:05\r\nFinished backup at 31-JAN-15\r\n\r\nRMAN&gt; list backup;\r\n\r\n\r\nList of Backup Sets\r\n===================\r\n\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ ---------------\r\n56      Full    91.97M     DISK        00:00:04     31-JAN-15\r\n  List of Datafiles in backup set 56\r\n  File LV Type Ckp SCN    Ckp Time  Name\r\n  ---- -- ---- ---------- --------- ----\r\n  2       Full 1000573    31-JAN-15 +DATA\/dwqual01\/datafile\/sysaux.265.870358459\r\n\r\n  Backup Set Copy #1 of backup set 56\r\n  Device Type Elapsed Time Completion Time Compressed Tag\r\n  ----------- ------------ --------------- ---------- ---\r\n  DISK        00:00:04     31-JAN-15       YES        TAG20150131T192933\r\n\r\n    List of Backup Pieces for backup set 56 Copy #1\r\n    BP Key  Pc# Status      Piece Name\r\n    ------- --- ----------- ----------\r\n    562     1   AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_01_31\/nnndf0_tag20150131t192933_0.633.870463773\r\n    563     2   AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_01_31\/nnndf0_tag20150131t192933_0.632.870463777\r\n    564     3   AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_01_31\/nnndf0_tag20150131t192933_0.631.870463777\r\n\r\nRMAN&gt;<\/pre>\n<p>So here we have one backup set composed of 3 backup pieces (files). Why would you ever do this?<br \/>\nThis is useful if you cannot create backup files bigger than X bytes due to restrictions of your OS or you want to move it to several media disks that have a size limit. It can also be a limit\u00a0imposed by your media manager software.<\/p>\n<h4><span style=\"color: #000080;\">FILESPERSET<\/span><\/h4>\n<p>Specify the maximum number of files in each backup set.\u00a0The FILESPERSET default is <strong>64<\/strong>.<\/p>\n<p>The real number of files in each backup set is\u00a0the minimum of the FILESPERSET setting and the number of files read by each channel.<\/p>\n<p>So if you are backing up only 2\u00a0datafiles, and filesperset is 3, you will have only 2 datafiles in your backup set. Otherwise you are a wizard.<\/p>\n<p>Let&#8217;s change the filesperset to 2 and test:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">RMAN&gt; backup database filesperset 2;\r\n\r\nStarting backup at 31-JAN-15\r\nusing channel ORA_DISK_1\r\n...\r\nFinished backup at 31-JAN-15\r\n\r\nRMAN&gt; list backup;\r\n\r\n\r\nList of Backup Sets\r\n===================\r\n\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ ---------------\r\n63      Full    87.97M     DISK        00:00:03     31-JAN-15\r\n        BP Key: 605   Status: AVAILABLE  Compressed: YES  Tag: TAG20150131T234910\r\n        Piece Name: +ARCHIVE\/dwqual01\/backupset\/2015_01_31\/nnndf0_tag20150131t234910_0.626.870479351\r\n  List of Datafiles in backup set 63\r\n  File LV Type Ckp SCN    Ckp Time  Name\r\n  ---- -- ---- ---------- --------- ----\r\n  2       Full 1012713    31-JAN-15 +DATA\/dwqual01\/datafile\/sysaux.265.870358459\r\n  4       Full 1012713    31-JAN-15 +DATA\/dwqual01\/datafile\/users.270.870358459\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ ---------------\r\n64      Full    5.34M      DISK        00:00:01     31-JAN-15\r\n        BP Key: 606   Status: AVAILABLE  Compressed: YES  Tag: TAG20150131T234910\r\n        Piece Name: +ARCHIVE\/dwqual01\/backupset\/2015_01_31\/nnndf0_tag20150131t234910_0.628.870479357\r\n  List of Datafiles in backup set 64\r\n  File LV Type Ckp SCN    Ckp Time  Name\r\n  ---- -- ---- ---------- --------- ----\r\n  3       Full 1012716    31-JAN-15 +DATA\/dwqual01\/datafile\/undotbs1.267.870358459\r\n  5       Full 1012716    31-JAN-15 +DATA\/dwqual01\/datafile\/audtbs.268.870358459\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ ---------------\r\n65      Full    157.69M    DISK        00:00:04     31-JAN-15\r\n        BP Key: 607   Status: AVAILABLE  Compressed: YES  Tag: TAG20150131T234910\r\n        Piece Name: +ARCHIVE\/dwqual01\/backupset\/2015_01_31\/nnndf0_tag20150131t234910_0.627.870479361\r\n  List of Datafiles in backup set 65\r\n  File LV Type Ckp SCN    Ckp Time  Name\r\n  ---- -- ---- ---------- --------- ----\r\n  1       Full 1012718    31-JAN-15 +DATA\/dwqual01\/datafile\/system.266.870358459\r\n  6       Full 1012718    31-JAN-15 +DATA\/dwqual01\/datafile\/dvtbs.269.870358459\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ ---------------\r\n66      Full    4.09M      DISK        00:00:01     31-JAN-15\r\n        BP Key: 608   Status: AVAILABLE  Compressed: YES  Tag: TAG20150131T234910\r\n        Piece Name: +ARCHIVE\/dwqual01\/backupset\/2015_01_31\/ncsnf0_tag20150131t234910_0.625.870479369\r\n  SPFILE Included: Modification time: 30-JAN-15\r\n  SPFILE db_unique_name: DWQUAL01\r\n  Control File Included: Ckp SCN: 1012721      Ckp time: 31-JAN-15\r\n\r\nRMAN&gt;\r\n<\/pre>\n<p>As you can see above, each backup set has now only 2 datafiles.<\/p>\n<h4><span style=\"color: #000080;\">SECTION SIZE<\/span><\/h4>\n<p>It is useful when you want to enable RMAN channels to back up a single large file in parallel. RMAN divides the work among multiple channels, with each channel backing up one file section in a backup piece. Backing up a file in separate sections can improve the performance of backups of large datafiles.<\/p>\n<p>If you specify a section size that is larger than the size of the file, then RMAN does not use multisection backup for the file. If you specify a small section size that would produce more than 256 sections, then RMAN increases the section size to a value that results in exactly 256 sections.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">RMAN&gt; backup tablespace sysaux section size 1M;\r\n\r\nStarting backup at 01-FEB-15\r\nusing channel ORA_DISK_1\r\nusing channel ORA_DISK_2\r\nusing channel ORA_DISK_3\r\nusing channel ORA_DISK_4\r\n...\r\nFinished backup at 01-FEB-15\r\n\r\nRMAN&gt; list backup;\r\n\r\n\r\nList of Backup Sets\r\n===================\r\n\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ ---------------\r\n100     Full    767.13M    DISK        00:00:38     01-FEB-15\r\n  List of Datafiles in backup set 100\r\n  File LV Type Ckp SCN    Ckp Time  Name\r\n  ---- -- ---- ---------- --------- ----\r\n  2       Full 1042081    01-FEB-15 +DATA\/dwqual01\/datafile\/sysaux.265.870358459\r\n\r\n  Backup Set Copy #1 of backup set 100\r\n  Device Type Elapsed Time Completion Time Compressed Tag\r\n  ----------- ------------ --------------- ---------- ---\r\n  DISK        00:00:38     01-FEB-15       YES        TAG20150201T102000\r\n\r\n    List of Backup Pieces for backup set 100 Copy #1\r\n    BP Key  Pc# Status      Piece Name\r\n    ------- --- ----------- ----------\r\n    701     1   AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.618.870517201\r\n    702     2   AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.611.870517201\r\n    703     3   AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.619.870517201\r\n    704     4   AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.620.870517201\r\n    705     5   AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.624.870517201\r\n    706     6   AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.621.870517201\r\n    707     7   AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.622.870517201\r\n    708     8   AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.623.870517203\r\n    709     9   AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.625.870517203\r\n    710     10  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.627.870517203\r\n    711     11  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.606.870517203\r\n    712     12  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.610.870517203\r\n    713     13  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.628.870517203\r\n    714     14  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.626.870517203\r\n    715     15  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.605.870517203\r\n    716     16  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.629.870517203\r\n    717     17  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.630.870517203\r\n    718     18  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.638.870517203\r\n    719     19  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.637.870517203\r\n    720     20  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.633.870517203\r\n    721     21  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.632.870517203\r\n    722     22  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.631.870517205\r\n    723     23  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.607.870517205\r\n    724     24  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.634.870517205\r\n    725     25  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.635.870517205\r\n    726     26  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.636.870517205\r\n    727     27  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.617.870517205\r\n    728     28  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.616.870517205\r\n    729     29  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.615.870517205\r\n    730     30  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.614.870517205\r\n    731     31  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.613.870517205\r\n    732     32  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.612.870517205\r\n    733     33  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.608.870517205\r\n    734     34  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.609.870517205\r\n    735     35  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.604.870517207\r\n    736     36  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.603.870517207\r\n    737     37  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.602.870517207\r\n    738     38  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.601.870517207\r\n    739     39  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.600.870517207\r\n    740     40  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.599.870517207\r\n    741     41  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.598.870517207\r\n    742     42  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.597.870517207\r\n    743     43  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.596.870517207\r\n    744     44  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.595.870517207\r\n    745     45  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.594.870517207\r\n    746     46  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.593.870517207\r\n    747     47  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.592.870517207\r\n    748     48  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.591.870517207\r\n    749     49  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.590.870517209\r\n    750     50  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.589.870517209\r\n    751     51  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.588.870517209\r\n    752     52  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.587.870517209\r\n    753     53  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.586.870517209\r\n    754     54  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.585.870517209\r\n    755     55  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.584.870517209\r\n    756     56  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.583.870517209\r\n    757     57  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.582.870517209\r\n    758     58  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.581.870517209\r\n    759     59  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.580.870517209\r\n    760     60  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.579.870517209\r\n    761     61  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.578.870517209\r\n    762     62  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.577.870517211\r\n    763     63  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.576.870517211\r\n    764     64  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.575.870517211\r\n    765     65  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.574.870517211\r\n    766     66  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.573.870517211\r\n    767     67  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.572.870517211\r\n    768     68  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.571.870517211\r\n    769     69  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.570.870517211\r\n    770     70  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.569.870517211\r\n    771     71  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.568.870517211\r\n    772     72  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.567.870517211\r\n    773     73  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.566.870517211\r\n    774     74  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.565.870517211\r\n    775     75  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.564.870517213\r\n    776     76  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.563.870517213\r\n    777     77  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.562.870517213\r\n    778     78  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.561.870517213\r\n    779     79  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.560.870517213\r\n    780     80  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.559.870517213\r\n    781     81  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.558.870517213\r\n    782     82  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.557.870517213\r\n    783     83  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.556.870517213\r\n    784     84  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.555.870517213\r\n    785     85  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.554.870517213\r\n    788     86  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.553.870517213\r\n    786     87  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.552.870517213\r\n    787     88  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.551.870517213\r\n    789     89  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.550.870517215\r\n    790     90  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.549.870517215\r\n    791     91  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.548.870517215\r\n    792     92  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.547.870517215\r\n    793     93  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.546.870517215\r\n    794     94  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.545.870517215\r\n    795     95  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.544.870517215\r\n    796     96  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.543.870517215\r\n    797     97  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.542.870517215\r\n    798     98  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.541.870517215\r\n    799     99  AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.540.870517215\r\n    800     100 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.539.870517215\r\n    801     101 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.538.870517215\r\n    802     102 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.537.870517217\r\n    803     103 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.536.870517217\r\n    804     104 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.535.870517217\r\n    805     105 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.534.870517217\r\n    806     106 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.533.870517217\r\n    807     107 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.532.870517217\r\n    808     108 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.531.870517217\r\n    809     109 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.530.870517217\r\n    810     110 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.529.870517217\r\n    811     111 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.528.870517217\r\n    812     112 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.527.870517217\r\n    813     113 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.526.870517217\r\n    814     114 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.525.870517217\r\n    815     115 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.524.870517217\r\n    816     116 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.523.870517219\r\n    817     117 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.522.870517219\r\n    818     118 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.521.870517219\r\n    819     119 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.520.870517219\r\n    820     120 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.519.870517219\r\n    821     121 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.518.870517219\r\n    822     122 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.517.870517219\r\n    823     123 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.516.870517219\r\n    824     124 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.515.870517219\r\n    825     125 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.514.870517219\r\n    826     126 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.513.870517219\r\n    827     127 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.512.870517219\r\n    828     128 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.511.870517219\r\n    829     129 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.510.870517221\r\n    830     130 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.509.870517221\r\n    831     131 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.508.870517221\r\n    832     132 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.507.870517221\r\n    833     133 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.506.870517221\r\n    834     134 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.505.870517221\r\n    835     135 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.504.870517221\r\n    836     136 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.503.870517221\r\n    837     137 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.502.870517221\r\n    838     138 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.501.870517221\r\n    839     139 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.500.870517221\r\n    840     140 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.499.870517221\r\n    841     141 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.498.870517221\r\n    842     142 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.497.870517223\r\n    843     143 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.496.870517223\r\n    844     144 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.495.870517223\r\n    845     145 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.494.870517223\r\n    846     146 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.493.870517223\r\n    847     147 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.492.870517223\r\n    848     148 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.491.870517223\r\n    849     149 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.490.870517223\r\n    850     150 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.489.870517223\r\n    851     151 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.488.870517223\r\n    852     152 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.487.870517223\r\n    853     153 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.486.870517223\r\n    854     154 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.485.870517223\r\n    855     155 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.484.870517225\r\n    856     156 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.483.870517225\r\n    857     157 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.482.870517225\r\n    858     158 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.481.870517225\r\n    859     159 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.480.870517225\r\n    860     160 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.479.870517225\r\n    861     161 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.478.870517225\r\n    862     162 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.477.870517225\r\n    863     163 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.476.870517225\r\n    864     164 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.475.870517225\r\n    865     165 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.474.870517225\r\n    866     166 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.473.870517225\r\n    867     167 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.472.870517225\r\n    868     168 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.471.870517225\r\n    869     169 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.470.870517227\r\n    870     170 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.469.870517227\r\n    871     171 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.468.870517227\r\n    872     172 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.467.870517227\r\n    873     173 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.466.870517227\r\n    874     174 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.465.870517227\r\n    875     175 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.464.870517227\r\n    876     176 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.463.870517227\r\n    877     177 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.462.870517227\r\n    878     178 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.461.870517227\r\n    879     179 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.460.870517227\r\n    880     180 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.459.870517227\r\n    881     181 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.458.870517227\r\n    882     182 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.457.870517227\r\n    883     183 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.456.870517229\r\n    884     184 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.455.870517229\r\n    885     185 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.454.870517229\r\n    886     186 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.453.870517229\r\n    887     187 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.452.870517229\r\n    888     188 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.451.870517229\r\n    889     189 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.450.870517229\r\n    890     190 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.449.870517229\r\n    891     191 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.448.870517229\r\n    892     192 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.447.870517229\r\n    893     193 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.446.870517229\r\n    894     194 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.445.870517229\r\n    895     195 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.444.870517229\r\n    896     196 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.443.870517229\r\n    897     197 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.442.870517229\r\n    898     198 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.441.870517231\r\n    899     199 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.440.870517231\r\n    900     200 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.439.870517231\r\n    901     201 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.438.870517231\r\n    902     202 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.437.870517231\r\n    903     203 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.259.870517231\r\n    904     204 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.266.870517231\r\n    905     205 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.265.870517231\r\n    906     206 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.267.870517231\r\n    907     207 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.268.870517231\r\n    908     208 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.271.870517231\r\n    909     209 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.275.870517231\r\n    910     210 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.276.870517231\r\n    911     211 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.277.870517231\r\n    912     212 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.278.870517231\r\n    913     213 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.279.870517233\r\n    914     214 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.280.870517233\r\n    915     215 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.281.870517233\r\n    916     216 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.282.870517233\r\n    917     217 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.283.870517233\r\n    918     218 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.284.870517233\r\n    919     219 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.285.870517233\r\n    920     220 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.286.870517233\r\n    921     221 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.287.870517233\r\n    922     222 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.288.870517233\r\n    923     223 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.289.870517233\r\n    924     224 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.290.870517233\r\n    925     225 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.291.870517233\r\n    926     226 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.292.870517235\r\n    927     227 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.293.870517235\r\n    928     228 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.294.870517235\r\n    929     229 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.295.870517235\r\n    930     230 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.296.870517235\r\n    931     231 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.297.870517235\r\n    932     232 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.298.870517235\r\n    933     233 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.299.870517235\r\n    934     234 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.300.870517235\r\n    935     235 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.301.870517235\r\n    936     236 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.302.870517235\r\n    937     237 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.303.870517235\r\n    938     238 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.304.870517235\r\n    939     239 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.305.870517235\r\n    940     240 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.306.870517237\r\n    941     241 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.307.870517237\r\n    942     242 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.308.870517237\r\n    943     243 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.309.870517237\r\n    944     244 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.310.870517237\r\n    945     245 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.311.870517237\r\n    946     246 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.312.870517237\r\n    947     247 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.313.870517237\r\n    948     248 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.314.870517237\r\n    949     249 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.315.870517237\r\n    950     250 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.316.870517237\r\n    951     251 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.317.870517237\r\n    952     252 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.318.870517237\r\n    953     253 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.319.870517237\r\n    954     254 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.320.870517237\r\n    955     255 AVAILABLE   +ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t102000_0.321.870517239\r\n            256 DELETED\r\n\r\nRMAN&gt;<\/pre>\n<p>You cannot specify <strong>SECTION SIZE<\/strong> in conjunction with <strong>MAXPIECESIZE<\/strong>. Why?<\/p>\n<p>Because if you have a datafile like my SYSAUX of 1020M and defines SECTION SIZE of 100M with parallelism of 4, this means that each backup thread will read 100M \/ 1020M. So it\u00a0will be read 11 times in parallel by those 4 threads. Each thread will generate <strong>one backup piece<\/strong>.<\/p>\n<p>The idea of MAXPIECESIZE is to limit a backup piece to a size. This error would appear if I mix the 2 commands (note that MAXPIECESIZE\u00a0is still in the default configuration):<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">RMAN&gt; backup tablespace sysaux section size 50M;\r\n\r\nStarting backup at 31-JAN-15\r\nusing channel ORA_DISK_1\r\nusing channel ORA_DISK_2\r\nusing channel ORA_DISK_3\r\nusing channel ORA_DISK_4\r\nRMAN-00571: ===========================================================\r\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\r\nRMAN-00571: ===========================================================\r\nRMAN-03002: failure of backup command at 01\/31\/2015 19:40:01\r\nRMAN-06808: SECTION SIZE cannot be used when piece limit is in effect\r\n\r\nRMAN&gt;<\/pre>\n<p>When you use SECTION SIZE and run any kind of backup, each generated\u00a0backup set will have <strong>only\u00a0one<\/strong> database file.<\/p>\n<h4><span style=\"color: #000080;\"><strong>MAXOPENFILES<\/strong><\/span><\/h4>\n<p>This defines the number of files that can be read simultaneously by each channel. The MAXOPENFILES default is 8.<\/p>\n<p>If you set it to 1 or 8 and backup your database with a single channel, you will still have, as the first example,\u00a0one backup set with all the datafiles, stored in a single backup piece, and another backup set with the spfile and control file in another single backup piece.<\/p>\n<p>What will change is the distribution inside the backup set. With 1, as it will read one datafile at a time, it will write the backup data into the backup piece sequentially. With 8, the backup piece will have data from all the 8 datafiles mixed.<\/p>\n<p>Let&#8217;s test it. I will run with MAXOPENFILES to 1 and RATE to 50 MB so the backup does not finish so fast.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">RMAN&gt; CONFIGURE CHANNEL DEVICE TYPE DISK MAXOPENFILES 1 rate 50M;\r\n\r\nnew RMAN configuration parameters:\r\nCONFIGURE CHANNEL DEVICE TYPE DISK MAXOPENFILES 1 RATE 50 M;\r\nnew RMAN configuration parameters are successfully stored\r\n\r\nRMAN&gt; backup database;\r\n\r\nStarting backup at 01-FEB-15\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=503 device type=DISK\r\nchannel ORA_DISK_1: starting full datafile backup set\r\nchannel ORA_DISK_1: specifying datafile(s) in backup set\r\ninput datafile file number=00002 name=+DATA\/dwqual01\/datafile\/sysaux.265.870358459\r\ninput datafile file number=00001 name=+DATA\/dwqual01\/datafile\/system.266.870358459\r\ninput datafile file number=00003 name=+DATA\/dwqual01\/datafile\/undotbs1.267.870358459\r\ninput datafile file number=00005 name=+DATA\/dwqual01\/datafile\/audtbs.268.870358459\r\ninput datafile file number=00006 name=+DATA\/dwqual01\/datafile\/dvtbs.269.870358459\r\ninput datafile file number=00004 name=+DATA\/dwqual01\/datafile\/users.270.870358459\r\nchannel ORA_DISK_1: starting piece 1 at 01-FEB-15\r\nchannel ORA_DISK_1: finished piece 1 at 01-FEB-15\r\npiece handle=+ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t113026_0.621.870521427 tag=TAG20150201T113026 comment=NONE\r\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:01:05\r\nchannel ORA_DISK_1: throttle time: 0:00:49\r\nchannel ORA_DISK_1: starting full datafile backup set\r\nchannel ORA_DISK_1: specifying datafile(s) in backup set\r\nincluding current control file in backup set\r\nincluding current SPFILE in backup set\r\nchannel ORA_DISK_1: starting piece 1 at 01-FEB-15\r\nchannel ORA_DISK_1: finished piece 1 at 01-FEB-15\r\npiece handle=+ARCHIVE\/dwqual01\/backupset\/2015_02_01\/ncsnf0_tag20150201t113026_0.624.870521493 tag=TAG20150201T113026 comment=NONE\r\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\r\nFinished backup at 01-FEB-15\r\n\r\nRMAN&gt;<\/pre>\n<p>While it is running, in another sqlplus screen I run:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">SQL&gt; col filename for a25 word_wrapped\r\nSQL&gt; select type, status, filename, buffer_size, buffer_count\r\n  2  from v$backup_async_io\r\n  3  where type &lt;&gt; 'AGGREGATE'\r\n  4  and status = 'IN PROGRESS';\r\n\r\n\r\nTYPE      STATUS      FILENAME                  BUFFER_SIZE BUFFER_COUNT\r\n--------- ----------- ------------------------- ----------- ------------\r\nINPUT     IN PROGRESS +DATA\/dwqual01\/datafile\/s     1048576           16\r\n                      ysaux.265.870358459\r\n\r\nOUTPUT    IN PROGRESS +ARCHIVE\/dwqual01\/backups     4194304            4\r\n                      et\/2015_02_01\/nnndf0_tag2\r\n                      0150201t113026_0.621.8705\r\n                      21427\r\n\r\n\r\nSQL&gt; \/\r\n\r\nTYPE      STATUS      FILENAME                  BUFFER_SIZE BUFFER_COUNT\r\n--------- ----------- ------------------------- ----------- ------------\r\nINPUT     IN PROGRESS +DATA\/dwqual01\/datafile\/s     1048576           16\r\n                      ystem.266.870358459\r\n\r\nOUTPUT    IN PROGRESS +ARCHIVE\/dwqual01\/backups     4194304            4\r\n                      et\/2015_02_01\/nnndf0_tag2\r\n                      0150201t113026_0.621.8705\r\n                      21427\r\n\r\n\r\nSQL&gt; \/\r\n\r\nTYPE      STATUS      FILENAME                  BUFFER_SIZE BUFFER_COUNT\r\n--------- ----------- ------------------------- ----------- ------------\r\nINPUT     IN PROGRESS +DATA\/dwqual01\/datafile\/u     1048576           16\r\n                      ndotbs1.267.870358459\r\n\r\nOUTPUT    IN PROGRESS +ARCHIVE\/dwqual01\/backups     4194304            4\r\n                      et\/2015_02_01\/nnndf0_tag2\r\n                      0150201t113026_0.621.8705\r\n                      21427<\/pre>\n<p>As we can see it reads each datafile at a time.<\/p>\n<p>Now with MAXOPENFILES\u00a0set to 2:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">RMAN&gt; CONFIGURE CHANNEL DEVICE TYPE DISK MAXOPENFILES 2 rate 50M;\r\n\r\nnew RMAN configuration parameters:\r\nCONFIGURE CHANNEL DEVICE TYPE DISK MAXOPENFILES 2 RATE 50 M;\r\nnew RMAN configuration parameters are successfully stored\r\n\r\nRMAN&gt; backup database;\r\n\r\nStarting backup at 01-FEB-15\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=503 device type=DISK\r\nchannel ORA_DISK_1: starting full datafile backup set\r\nchannel ORA_DISK_1: specifying datafile(s) in backup set\r\ninput datafile file number=00002 name=+DATA\/dwqual01\/datafile\/sysaux.265.870358459\r\ninput datafile file number=00001 name=+DATA\/dwqual01\/datafile\/system.266.870358459\r\ninput datafile file number=00003 name=+DATA\/dwqual01\/datafile\/undotbs1.267.870358459\r\ninput datafile file number=00005 name=+DATA\/dwqual01\/datafile\/audtbs.268.870358459\r\ninput datafile file number=00006 name=+DATA\/dwqual01\/datafile\/dvtbs.269.870358459\r\ninput datafile file number=00004 name=+DATA\/dwqual01\/datafile\/users.270.870358459\r\nchannel ORA_DISK_1: starting piece 1 at 01-FEB-15\r\nchannel ORA_DISK_1: finished piece 1 at 01-FEB-15\r\npiece handle=+ARCHIVE\/dwqual01\/backupset\/2015_02_01\/nnndf0_tag20150201t120227_0.611.870523349 tag=TAG20150201T120227 comment=NONE\r\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:15\r\nchannel ORA_DISK_1: starting full datafile backup set\r\nchannel ORA_DISK_1: specifying datafile(s) in backup set\r\nincluding current control file in backup set\r\nincluding current SPFILE in backup set\r\nchannel ORA_DISK_1: starting piece 1 at 01-FEB-15\r\nchannel ORA_DISK_1: finished piece 1 at 01-FEB-15\r\npiece handle=+ARCHIVE\/dwqual01\/backupset\/2015_02_01\/ncsnf0_tag20150201t120227_0.618.870523365 tag=TAG20150201T120227 comment=NONE\r\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\r\nFinished backup at 01-FEB-15\r\n\r\nRMAN&gt;<\/pre>\n<p>Checking with\u00a0sqlplus:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">SQL&gt; \/\r\n\r\nTYPE      STATUS      FILENAME                  BUFFER_SIZE BUFFER_COUNT\r\n--------- ----------- ------------------------- ----------- ------------\r\nINPUT     IN PROGRESS +DATA\/dwqual01\/datafile\/s     1048576            8\r\n                      ysaux.265.870358459\r\n\r\nINPUT     IN PROGRESS +DATA\/dwqual01\/datafile\/s     1048576            8\r\n                      ystem.266.870358459\r\n\r\nOUTPUT    IN PROGRESS +ARCHIVE\/dwqual01\/backups     4194304            4\r\n                      et\/2015_02_01\/nnndf0_tag2\r\n                      0150201t120227_0.611.8705\r\n                      23349\r\n\r\n\r\nSQL&gt;<\/pre>\n<p>As we can see, now my rman channel is reading from 2 datafiles simultaneously. Thus, my level of multiplexing here is 2.<\/p>\n<p>Remeber, in case files being backed up are ASM files, level of multiplexing may be reduced as ASM\u00a0automatically takes care of the contention by striping the data. So a MAXOPENFILES of 5 does not necessarily means that you will have a\u00a0multiplexing level of 5 when you backup to ASM.<\/p>\n<hr \/>\n<p>External pages that helped in this article:<\/p>\n<ul>\n<li>http:\/\/oracleinaction.com\/tune-rman-i\/<\/li>\n<li>http:\/\/docs.oracle.com\/cd\/E11882_01\/backup.112\/e10642\/glossary.htm#CHDHHBFC<\/li>\n<\/ul>\n<b>Have you enjoyed? Please leave a comment or give a \ud83d\udc4d!<\/b>\n<div class='watch-action'><div class='watch-position align-left'><div class='action-like'><a class='lbg-style2 like-1322 jlk' href='javascript:void(0)' data-task='like' data-post_id='1322' data-nonce='de4404f630' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.dbarj.com.br\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-1322 lc'>+78<\/span><\/a><\/div><\/div> <div class='status-1322 status align-left'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Many people still don&#8217;t get the difference between all that configuration parameters that can be set up during a backup. In this article, I will explain how to use each of them, their differences and the theory behind. First the theory: &nbsp; Backup Set Logical structure where the backup is stored. It is a logical &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/www.dbarj.com.br\/en\/2015\/02\/rman-real-usage-maxsetsize-maxpiecesize-filesperset-section-size-maxopenfiles\/\">Continue reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26],"tags":[],"class_list":["post-1322","post","type-post","status-publish","format-standard","hentry","category-rman-en","item-wrap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>RMAN real usage of MAXSETSIZE, MAXPIECESIZE, FILESPERSET, SECTION SIZE, MAXOPENFILES - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/title>\n<meta name=\"description\" content=\"RMAN real usage of MAXSETSIZE, MAXPIECESIZE, FILESPERSET, SECTION SIZE, MAXOPENFILES\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbarj.com.br\/en\/2015\/02\/rman-real-usage-maxsetsize-maxpiecesize-filesperset-section-size-maxopenfiles\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DBA RJ\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"25 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/02\\\/rman-real-usage-maxsetsize-maxpiecesize-filesperset-section-size-maxopenfiles\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/02\\\/rman-real-usage-maxsetsize-maxpiecesize-filesperset-section-size-maxopenfiles\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"RMAN real usage of MAXSETSIZE, MAXPIECESIZE, FILESPERSET, SECTION SIZE, MAXOPENFILES\",\"datePublished\":\"2015-02-01T14:26:53+00:00\",\"dateModified\":\"2015-02-01T14:42:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/02\\\/rman-real-usage-maxsetsize-maxpiecesize-filesperset-section-size-maxopenfiles\\\/\"},\"wordCount\":1250,\"commentCount\":29,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"articleSection\":[\"Recovery Manager (RMAN)\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/02\\\/rman-real-usage-maxsetsize-maxpiecesize-filesperset-section-size-maxopenfiles\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/02\\\/rman-real-usage-maxsetsize-maxpiecesize-filesperset-section-size-maxopenfiles\\\/\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/02\\\/rman-real-usage-maxsetsize-maxpiecesize-filesperset-section-size-maxopenfiles\\\/\",\"name\":\"RMAN real usage of MAXSETSIZE, MAXPIECESIZE, FILESPERSET, SECTION SIZE, MAXOPENFILES - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\"},\"datePublished\":\"2015-02-01T14:26:53+00:00\",\"dateModified\":\"2015-02-01T14:42:58+00:00\",\"description\":\"RMAN real usage of MAXSETSIZE, MAXPIECESIZE, FILESPERSET, SECTION SIZE, MAXOPENFILES\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/02\\\/rman-real-usage-maxsetsize-maxpiecesize-filesperset-section-size-maxopenfiles\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/02\\\/rman-real-usage-maxsetsize-maxpiecesize-filesperset-section-size-maxopenfiles\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/02\\\/rman-real-usage-maxsetsize-maxpiecesize-filesperset-section-size-maxopenfiles\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"RMAN real usage of MAXSETSIZE, MAXPIECESIZE, FILESPERSET, SECTION SIZE, MAXOPENFILES\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\",\"name\":\"DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"description\":\"Blog about Databases, Security and High Availability\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\",\"name\":\"DBA RJ\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"contentUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"width\":712,\"height\":712,\"caption\":\"DBA RJ\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"RMAN real usage of MAXSETSIZE, MAXPIECESIZE, FILESPERSET, SECTION SIZE, MAXOPENFILES - DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"RMAN real usage of MAXSETSIZE, MAXPIECESIZE, FILESPERSET, SECTION SIZE, MAXOPENFILES","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbarj.com.br\/en\/2015\/02\/rman-real-usage-maxsetsize-maxpiecesize-filesperset-section-size-maxopenfiles\/","twitter_misc":{"Written by":"DBA RJ","Est. reading time":"25 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbarj.com.br\/en\/2015\/02\/rman-real-usage-maxsetsize-maxpiecesize-filesperset-section-size-maxopenfiles\/#article","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/2015\/02\/rman-real-usage-maxsetsize-maxpiecesize-filesperset-section-size-maxopenfiles\/"},"author":{"name":"DBA RJ","@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"RMAN real usage of MAXSETSIZE, MAXPIECESIZE, FILESPERSET, SECTION SIZE, MAXOPENFILES","datePublished":"2015-02-01T14:26:53+00:00","dateModified":"2015-02-01T14:42:58+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbarj.com.br\/en\/2015\/02\/rman-real-usage-maxsetsize-maxpiecesize-filesperset-section-size-maxopenfiles\/"},"wordCount":1250,"commentCount":29,"publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"articleSection":["Recovery Manager (RMAN)"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbarj.com.br\/en\/2015\/02\/rman-real-usage-maxsetsize-maxpiecesize-filesperset-section-size-maxopenfiles\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbarj.com.br\/en\/2015\/02\/rman-real-usage-maxsetsize-maxpiecesize-filesperset-section-size-maxopenfiles\/","url":"https:\/\/www.dbarj.com.br\/en\/2015\/02\/rman-real-usage-maxsetsize-maxpiecesize-filesperset-section-size-maxopenfiles\/","name":"RMAN real usage of MAXSETSIZE, MAXPIECESIZE, FILESPERSET, SECTION SIZE, MAXOPENFILES - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/#website"},"datePublished":"2015-02-01T14:26:53+00:00","dateModified":"2015-02-01T14:42:58+00:00","description":"RMAN real usage of MAXSETSIZE, MAXPIECESIZE, FILESPERSET, SECTION SIZE, MAXOPENFILES","breadcrumb":{"@id":"https:\/\/www.dbarj.com.br\/en\/2015\/02\/rman-real-usage-maxsetsize-maxpiecesize-filesperset-section-size-maxopenfiles\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbarj.com.br\/en\/2015\/02\/rman-real-usage-maxsetsize-maxpiecesize-filesperset-section-size-maxopenfiles\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbarj.com.br\/en\/2015\/02\/rman-real-usage-maxsetsize-maxpiecesize-filesperset-section-size-maxopenfiles\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbarj.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"RMAN real usage of MAXSETSIZE, MAXPIECESIZE, FILESPERSET, SECTION SIZE, MAXOPENFILES"}]},{"@type":"WebSite","@id":"https:\/\/www.dbarj.com.br\/en\/#website","url":"https:\/\/www.dbarj.com.br\/en\/","name":"DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Blog about Databases, Security and High Availability","publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbarj.com.br\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9","name":"DBA RJ","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","url":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","contentUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","width":712,"height":712,"caption":"DBA RJ"},"logo":{"@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png"}}]}},"_links":{"self":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/1322","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/comments?post=1322"}],"version-history":[{"count":0,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/1322\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/media?parent=1322"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/categories?post=1322"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/tags?post=1322"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}