RMAN real usage of MAXSETSIZE, MAXPIECESIZE, FILESPERSET, SECTION SIZE, MAXOPENFILES

Many people still don'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:

 

Backup Set

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. Do not think physically. 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.

Backup Piece

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.

Multiplexed Backup Set

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.

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 impossible. If your TABLESPACE have more than one datafile, than you can have each datafile in a different backup set.
Also, 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).

Level of Multiplexing

This is the number of input files simultaneously 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 level is directly interfered by some configuration 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.

File Section

A contiguous range of blocks in a datafile. One datafile is made by multiple sections.

Multisection Backup

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.

Now to practice:

 

Let's use the concepts and play with MAXSETSIZE, MAXPIECESIZE, FILESPERSET, SECTION SIZE, MAXOPENFILES.

For the examples, I will use the following database:

RMAN> report schema;

Report of database schema for database with db_unique_name DWQUAL01

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    840      SYSTEM               ***     +DATA/dwqual01/datafile/system.266.870358459
2    1020     SYSAUX               ***     +DATA/dwqual01/datafile/sysaux.265.870358459
3    610      UNDOTBS1             ***     +DATA/dwqual01/datafile/undotbs1.267.870358459
4    5        USERS                ***     +DATA/dwqual01/datafile/users.270.870358459
5    256      AUDTBS               ***     +DATA/dwqual01/datafile/audtbs.268.870358459
6    15       DVTBS                ***     +DATA/dwqual01/datafile/dvtbs.269.870358459

MAXSETSIZE

Defines the maximum size of a backup set. The default MAXSETSIZE for a database is unlimited.

For the example above, if I put the MAXSETSIZE to 1019M, the backup fails:

RMAN> CONFIGURE MAXSETSIZE TO 1019M;

new RMAN configuration parameters:
CONFIGURE MAXSETSIZE TO 1019 M;
new RMAN configuration parameters are successfully stored

RMAN> backup database;

Starting backup at 31-JAN-15
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 01/31/2015 19:16:31
RMAN-06183: datafile or datafile copy +DATA/dwqual01/datafile/sysaux.265.870358459 (file number 2) larger than MAXSETSIZE

But if I change the MAXSETSIZE to 1020M, the backup will run:

RMAN> CONFIGURE MAXSETSIZE TO 1020M;

old RMAN configuration parameters:
CONFIGURE MAXSETSIZE TO 1019 M;
new RMAN configuration parameters:
CONFIGURE MAXSETSIZE TO 1020 M;
new RMAN configuration parameters are successfully stored

RMAN> backup database;

Starting backup at 31-JAN-15
using channel ORA_DISK_1
...

Why? Because one datafile cannot never be placed in more than one backup set (I've already told that in the theory section).
If I limit the size of a backup set to a value lower than my biggest datafile, it won't fit there.
So, remember, that MAXSETSIZE should be at least as large as the largest datafile.

MAXPIECESIZE

Defines the maximum size of a backup piece. The default MAXPIECESIZE is unlimited.

When it is set to default, your backup set is usually stored in 1 backup piece (if to disk, this means one file per set).

Let's run a simple backup and check:

RMAN> backup database;

Starting backup at 31-JAN-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=227 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=00002 name=+DATA/dwqual01/datafile/sysaux.265.870358459
input datafile file number=00001 name=+DATA/dwqual01/datafile/system.266.870358459
input datafile file number=00003 name=+DATA/dwqual01/datafile/undotbs1.267.870358459
input datafile file number=00005 name=+DATA/dwqual01/datafile/audtbs.268.870358459
input datafile file number=00006 name=+DATA/dwqual01/datafile/dvtbs.269.870358459
input datafile file number=00004 name=+DATA/dwqual01/datafile/users.270.870358459
channel ORA_DISK_1: starting piece 1 at 31-JAN-15
channel ORA_DISK_1: finished piece 1 at 31-JAN-15
piece handle=+ARCHIVE/dwqual01/backupset/2015_01_31/nnndf0_tag20150131t232750_0.628.870478071 tag=TAG20150131T232750 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
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 31-JAN-15
channel ORA_DISK_1: finished piece 1 at 31-JAN-15
piece handle=+ARCHIVE/dwqual01/backupset/2015_01_31/ncsnf0_tag20150131t232750_0.627.870478087 tag=TAG20150131T232750 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 31-JAN-15

RMAN> list backup;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
60      Full    1.44G      DISK        00:00:08     31-JAN-15
        BP Key: 600   Status: AVAILABLE  Compressed: NO  Tag: TAG20150131T232750
        Piece Name: +ARCHIVE/dwqual01/backupset/2015_01_31/nnndf0_tag20150131t232750_0.628.870478071
  List of Datafiles in backup set 60
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1011911    31-JAN-15 +DATA/dwqual01/datafile/system.266.870358459
  2       Full 1011911    31-JAN-15 +DATA/dwqual01/datafile/sysaux.265.870358459
  3       Full 1011911    31-JAN-15 +DATA/dwqual01/datafile/undotbs1.267.870358459
  4       Full 1011911    31-JAN-15 +DATA/dwqual01/datafile/users.270.870358459
  5       Full 1011911    31-JAN-15 +DATA/dwqual01/datafile/audtbs.268.870358459
  6       Full 1011911    31-JAN-15 +DATA/dwqual01/datafile/dvtbs.269.870358459

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
61      Full    13.73M     DISK        00:00:01     31-JAN-15
        BP Key: 601   Status: AVAILABLE  Compressed: NO  Tag: TAG20150131T232750
        Piece Name: +ARCHIVE/dwqual01/backupset/2015_01_31/ncsnf0_tag20150131t232750_0.627.870478087
  SPFILE Included: Modification time: 30-JAN-15
  SPFILE db_unique_name: DWQUAL01
  Control File Included: Ckp SCN: 1011921      Ckp time: 31-JAN-15

RMAN>

As you can check above, simply running "backup database" 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.

Now let's change the MAXPIECESIZE to 50M and simulate the backup of one tablespace:

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

RMAN> backup tablespace sysaux;

Starting backup at 31-JAN-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=152 device type=DISK
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/dwqual01/datafile/sysaux.265.870358459
channel ORA_DISK_1: starting piece 1 at 31-JAN-15
channel ORA_DISK_1: finished piece 1 at 31-JAN-15
piece handle=+ARCHIVE/dwqual01/backupset/2015_01_31/nnndf0_tag20150131t192933_0.633.870463773 tag=TAG20150131T192933 comment=NONE
channel ORA_DISK_1: starting piece 2 at 31-JAN-15
channel ORA_DISK_1: finished piece 2 at 31-JAN-15
piece handle=+ARCHIVE/dwqual01/backupset/2015_01_31/nnndf0_tag20150131t192933_0.632.870463777 tag=TAG20150131T192933 comment=NONE
channel ORA_DISK_1: starting piece 3 at 31-JAN-15
channel ORA_DISK_1: finished piece 3 at 31-JAN-15
piece handle=+ARCHIVE/dwqual01/backupset/2015_01_31/nnndf0_tag20150131t192933_0.631.870463777 tag=TAG20150131T192933 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:05
Finished backup at 31-JAN-15

RMAN> list backup;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
56      Full    91.97M     DISK        00:00:04     31-JAN-15
  List of Datafiles in backup set 56
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2       Full 1000573    31-JAN-15 +DATA/dwqual01/datafile/sysaux.265.870358459

  Backup Set Copy #1 of backup set 56
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:04     31-JAN-15       YES        TAG20150131T192933

    List of Backup Pieces for backup set 56 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    562     1   AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_01_31/nnndf0_tag20150131t192933_0.633.870463773
    563     2   AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_01_31/nnndf0_tag20150131t192933_0.632.870463777
    564     3   AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_01_31/nnndf0_tag20150131t192933_0.631.870463777

RMAN>

So here we have one backup set composed of 3 backup pieces (files). Why would you ever do this?
This 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 imposed by your media manager software.

FILESPERSET

Specify the maximum number of files in each backup set. The FILESPERSET default is 64.

The real number of files in each backup set is the minimum of the FILESPERSET setting and the number of files read by each channel.

So if you are backing up only 2 datafiles, and filesperset is 3, you will have only 2 datafiles in your backup set. Otherwise you are a wizard.

Let's change the filesperset to 2 and test:

RMAN> backup database filesperset 2;

Starting backup at 31-JAN-15
using channel ORA_DISK_1
...
Finished backup at 31-JAN-15

RMAN> list backup;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
63      Full    87.97M     DISK        00:00:03     31-JAN-15
        BP Key: 605   Status: AVAILABLE  Compressed: YES  Tag: TAG20150131T234910
        Piece Name: +ARCHIVE/dwqual01/backupset/2015_01_31/nnndf0_tag20150131t234910_0.626.870479351
  List of Datafiles in backup set 63
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2       Full 1012713    31-JAN-15 +DATA/dwqual01/datafile/sysaux.265.870358459
  4       Full 1012713    31-JAN-15 +DATA/dwqual01/datafile/users.270.870358459

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
64      Full    5.34M      DISK        00:00:01     31-JAN-15
        BP Key: 606   Status: AVAILABLE  Compressed: YES  Tag: TAG20150131T234910
        Piece Name: +ARCHIVE/dwqual01/backupset/2015_01_31/nnndf0_tag20150131t234910_0.628.870479357
  List of Datafiles in backup set 64
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 1012716    31-JAN-15 +DATA/dwqual01/datafile/undotbs1.267.870358459
  5       Full 1012716    31-JAN-15 +DATA/dwqual01/datafile/audtbs.268.870358459

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
65      Full    157.69M    DISK        00:00:04     31-JAN-15
        BP Key: 607   Status: AVAILABLE  Compressed: YES  Tag: TAG20150131T234910
        Piece Name: +ARCHIVE/dwqual01/backupset/2015_01_31/nnndf0_tag20150131t234910_0.627.870479361
  List of Datafiles in backup set 65
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1012718    31-JAN-15 +DATA/dwqual01/datafile/system.266.870358459
  6       Full 1012718    31-JAN-15 +DATA/dwqual01/datafile/dvtbs.269.870358459

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
66      Full    4.09M      DISK        00:00:01     31-JAN-15
        BP Key: 608   Status: AVAILABLE  Compressed: YES  Tag: TAG20150131T234910
        Piece Name: +ARCHIVE/dwqual01/backupset/2015_01_31/ncsnf0_tag20150131t234910_0.625.870479369
  SPFILE Included: Modification time: 30-JAN-15
  SPFILE db_unique_name: DWQUAL01
  Control File Included: Ckp SCN: 1012721      Ckp time: 31-JAN-15

RMAN>

As you can see above, each backup set has now only 2 datafiles.

SECTION SIZE

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.

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.

RMAN> backup tablespace sysaux section size 1M;

Starting backup at 01-FEB-15
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
...
Finished backup at 01-FEB-15

RMAN> list backup;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
100     Full    767.13M    DISK        00:00:38     01-FEB-15
  List of Datafiles in backup set 100
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2       Full 1042081    01-FEB-15 +DATA/dwqual01/datafile/sysaux.265.870358459

  Backup Set Copy #1 of backup set 100
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:38     01-FEB-15       YES        TAG20150201T102000

    List of Backup Pieces for backup set 100 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    701     1   AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.618.870517201
    702     2   AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.611.870517201
    703     3   AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.619.870517201
    704     4   AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.620.870517201
    705     5   AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.624.870517201
    706     6   AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.621.870517201
    707     7   AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.622.870517201
    708     8   AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.623.870517203
    709     9   AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.625.870517203
    710     10  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.627.870517203
    711     11  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.606.870517203
    712     12  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.610.870517203
    713     13  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.628.870517203
    714     14  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.626.870517203
    715     15  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.605.870517203
    716     16  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.629.870517203
    717     17  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.630.870517203
    718     18  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.638.870517203
    719     19  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.637.870517203
    720     20  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.633.870517203
    721     21  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.632.870517203
    722     22  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.631.870517205
    723     23  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.607.870517205
    724     24  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.634.870517205
    725     25  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.635.870517205
    726     26  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.636.870517205
    727     27  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.617.870517205
    728     28  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.616.870517205
    729     29  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.615.870517205
    730     30  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.614.870517205
    731     31  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.613.870517205
    732     32  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.612.870517205
    733     33  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.608.870517205
    734     34  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.609.870517205
    735     35  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.604.870517207
    736     36  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.603.870517207
    737     37  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.602.870517207
    738     38  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.601.870517207
    739     39  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.600.870517207
    740     40  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.599.870517207
    741     41  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.598.870517207
    742     42  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.597.870517207
    743     43  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.596.870517207
    744     44  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.595.870517207
    745     45  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.594.870517207
    746     46  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.593.870517207
    747     47  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.592.870517207
    748     48  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.591.870517207
    749     49  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.590.870517209
    750     50  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.589.870517209
    751     51  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.588.870517209
    752     52  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.587.870517209
    753     53  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.586.870517209
    754     54  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.585.870517209
    755     55  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.584.870517209
    756     56  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.583.870517209
    757     57  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.582.870517209
    758     58  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.581.870517209
    759     59  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.580.870517209
    760     60  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.579.870517209
    761     61  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.578.870517209
    762     62  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.577.870517211
    763     63  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.576.870517211
    764     64  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.575.870517211
    765     65  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.574.870517211
    766     66  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.573.870517211
    767     67  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.572.870517211
    768     68  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.571.870517211
    769     69  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.570.870517211
    770     70  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.569.870517211
    771     71  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.568.870517211
    772     72  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.567.870517211
    773     73  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.566.870517211
    774     74  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.565.870517211
    775     75  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.564.870517213
    776     76  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.563.870517213
    777     77  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.562.870517213
    778     78  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.561.870517213
    779     79  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.560.870517213
    780     80  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.559.870517213
    781     81  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.558.870517213
    782     82  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.557.870517213
    783     83  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.556.870517213
    784     84  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.555.870517213
    785     85  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.554.870517213
    788     86  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.553.870517213
    786     87  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.552.870517213
    787     88  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.551.870517213
    789     89  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.550.870517215
    790     90  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.549.870517215
    791     91  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.548.870517215
    792     92  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.547.870517215
    793     93  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.546.870517215
    794     94  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.545.870517215
    795     95  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.544.870517215
    796     96  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.543.870517215
    797     97  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.542.870517215
    798     98  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.541.870517215
    799     99  AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.540.870517215
    800     100 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.539.870517215
    801     101 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.538.870517215
    802     102 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.537.870517217
    803     103 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.536.870517217
    804     104 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.535.870517217
    805     105 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.534.870517217
    806     106 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.533.870517217
    807     107 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.532.870517217
    808     108 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.531.870517217
    809     109 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.530.870517217
    810     110 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.529.870517217
    811     111 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.528.870517217
    812     112 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.527.870517217
    813     113 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.526.870517217
    814     114 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.525.870517217
    815     115 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.524.870517217
    816     116 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.523.870517219
    817     117 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.522.870517219
    818     118 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.521.870517219
    819     119 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.520.870517219
    820     120 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.519.870517219
    821     121 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.518.870517219
    822     122 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.517.870517219
    823     123 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.516.870517219
    824     124 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.515.870517219
    825     125 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.514.870517219
    826     126 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.513.870517219
    827     127 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.512.870517219
    828     128 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.511.870517219
    829     129 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.510.870517221
    830     130 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.509.870517221
    831     131 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.508.870517221
    832     132 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.507.870517221
    833     133 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.506.870517221
    834     134 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.505.870517221
    835     135 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.504.870517221
    836     136 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.503.870517221
    837     137 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.502.870517221
    838     138 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.501.870517221
    839     139 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.500.870517221
    840     140 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.499.870517221
    841     141 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.498.870517221
    842     142 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.497.870517223
    843     143 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.496.870517223
    844     144 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.495.870517223
    845     145 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.494.870517223
    846     146 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.493.870517223
    847     147 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.492.870517223
    848     148 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.491.870517223
    849     149 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.490.870517223
    850     150 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.489.870517223
    851     151 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.488.870517223
    852     152 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.487.870517223
    853     153 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.486.870517223
    854     154 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.485.870517223
    855     155 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.484.870517225
    856     156 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.483.870517225
    857     157 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.482.870517225
    858     158 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.481.870517225
    859     159 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.480.870517225
    860     160 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.479.870517225
    861     161 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.478.870517225
    862     162 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.477.870517225
    863     163 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.476.870517225
    864     164 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.475.870517225
    865     165 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.474.870517225
    866     166 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.473.870517225
    867     167 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.472.870517225
    868     168 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.471.870517225
    869     169 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.470.870517227
    870     170 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.469.870517227
    871     171 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.468.870517227
    872     172 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.467.870517227
    873     173 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.466.870517227
    874     174 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.465.870517227
    875     175 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.464.870517227
    876     176 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.463.870517227
    877     177 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.462.870517227
    878     178 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.461.870517227
    879     179 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.460.870517227
    880     180 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.459.870517227
    881     181 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.458.870517227
    882     182 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.457.870517227
    883     183 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.456.870517229
    884     184 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.455.870517229
    885     185 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.454.870517229
    886     186 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.453.870517229
    887     187 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.452.870517229
    888     188 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.451.870517229
    889     189 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.450.870517229
    890     190 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.449.870517229
    891     191 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.448.870517229
    892     192 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.447.870517229
    893     193 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.446.870517229
    894     194 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.445.870517229
    895     195 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.444.870517229
    896     196 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.443.870517229
    897     197 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.442.870517229
    898     198 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.441.870517231
    899     199 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.440.870517231
    900     200 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.439.870517231
    901     201 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.438.870517231
    902     202 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.437.870517231
    903     203 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.259.870517231
    904     204 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.266.870517231
    905     205 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.265.870517231
    906     206 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.267.870517231
    907     207 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.268.870517231
    908     208 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.271.870517231
    909     209 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.275.870517231
    910     210 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.276.870517231
    911     211 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.277.870517231
    912     212 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.278.870517231
    913     213 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.279.870517233
    914     214 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.280.870517233
    915     215 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.281.870517233
    916     216 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.282.870517233
    917     217 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.283.870517233
    918     218 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.284.870517233
    919     219 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.285.870517233
    920     220 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.286.870517233
    921     221 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.287.870517233
    922     222 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.288.870517233
    923     223 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.289.870517233
    924     224 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.290.870517233
    925     225 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.291.870517233
    926     226 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.292.870517235
    927     227 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.293.870517235
    928     228 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.294.870517235
    929     229 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.295.870517235
    930     230 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.296.870517235
    931     231 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.297.870517235
    932     232 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.298.870517235
    933     233 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.299.870517235
    934     234 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.300.870517235
    935     235 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.301.870517235
    936     236 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.302.870517235
    937     237 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.303.870517235
    938     238 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.304.870517235
    939     239 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.305.870517235
    940     240 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.306.870517237
    941     241 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.307.870517237
    942     242 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.308.870517237
    943     243 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.309.870517237
    944     244 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.310.870517237
    945     245 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.311.870517237
    946     246 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.312.870517237
    947     247 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.313.870517237
    948     248 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.314.870517237
    949     249 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.315.870517237
    950     250 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.316.870517237
    951     251 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.317.870517237
    952     252 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.318.870517237
    953     253 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.319.870517237
    954     254 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.320.870517237
    955     255 AVAILABLE   +ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t102000_0.321.870517239
            256 DELETED

RMAN>

You cannot specify SECTION SIZE in conjunction with MAXPIECESIZE. Why?

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 will be read 11 times in parallel by those 4 threads. Each thread will generate one backup piece.

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 is still in the default configuration):

RMAN> backup tablespace sysaux section size 50M;

Starting backup at 31-JAN-15
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 01/31/2015 19:40:01
RMAN-06808: SECTION SIZE cannot be used when piece limit is in effect

RMAN>

When you use SECTION SIZE and run any kind of backup, each generated backup set will have only one database file.

MAXOPENFILES

This defines the number of files that can be read simultaneously by each channel. The MAXOPENFILES default is 8.

If you set it to 1 or 8 and backup your database with a single channel, you will still have, as the first example, 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.

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.

Let's test it. I will run with MAXOPENFILES to 1 and RATE to 50 MB so the backup does not finish so fast.

RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK MAXOPENFILES 1 rate 50M;

new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK MAXOPENFILES 1 RATE 50 M;
new RMAN configuration parameters are successfully stored

RMAN> backup database;

Starting backup at 01-FEB-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=503 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=00002 name=+DATA/dwqual01/datafile/sysaux.265.870358459
input datafile file number=00001 name=+DATA/dwqual01/datafile/system.266.870358459
input datafile file number=00003 name=+DATA/dwqual01/datafile/undotbs1.267.870358459
input datafile file number=00005 name=+DATA/dwqual01/datafile/audtbs.268.870358459
input datafile file number=00006 name=+DATA/dwqual01/datafile/dvtbs.269.870358459
input datafile file number=00004 name=+DATA/dwqual01/datafile/users.270.870358459
channel ORA_DISK_1: starting piece 1 at 01-FEB-15
channel ORA_DISK_1: finished piece 1 at 01-FEB-15
piece handle=+ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t113026_0.621.870521427 tag=TAG20150201T113026 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:05
channel ORA_DISK_1: throttle time: 0:00:49
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 01-FEB-15
channel ORA_DISK_1: finished piece 1 at 01-FEB-15
piece handle=+ARCHIVE/dwqual01/backupset/2015_02_01/ncsnf0_tag20150201t113026_0.624.870521493 tag=TAG20150201T113026 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 01-FEB-15

RMAN>

While it is running, in another sqlplus screen I run:

SQL> col filename for a25 word_wrapped
SQL> select type, status, filename, buffer_size, buffer_count
  2  from v$backup_async_io
  3  where type <> 'AGGREGATE'
  4  and status = 'IN PROGRESS';


TYPE      STATUS      FILENAME                  BUFFER_SIZE BUFFER_COUNT
--------- ----------- ------------------------- ----------- ------------
INPUT     IN PROGRESS +DATA/dwqual01/datafile/s     1048576           16
                      ysaux.265.870358459

OUTPUT    IN PROGRESS +ARCHIVE/dwqual01/backups     4194304            4
                      et/2015_02_01/nnndf0_tag2
                      0150201t113026_0.621.8705
                      21427


SQL> /

TYPE      STATUS      FILENAME                  BUFFER_SIZE BUFFER_COUNT
--------- ----------- ------------------------- ----------- ------------
INPUT     IN PROGRESS +DATA/dwqual01/datafile/s     1048576           16
                      ystem.266.870358459

OUTPUT    IN PROGRESS +ARCHIVE/dwqual01/backups     4194304            4
                      et/2015_02_01/nnndf0_tag2
                      0150201t113026_0.621.8705
                      21427


SQL> /

TYPE      STATUS      FILENAME                  BUFFER_SIZE BUFFER_COUNT
--------- ----------- ------------------------- ----------- ------------
INPUT     IN PROGRESS +DATA/dwqual01/datafile/u     1048576           16
                      ndotbs1.267.870358459

OUTPUT    IN PROGRESS +ARCHIVE/dwqual01/backups     4194304            4
                      et/2015_02_01/nnndf0_tag2
                      0150201t113026_0.621.8705
                      21427

As we can see it reads each datafile at a time.

Now with MAXOPENFILES set to 2:

RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK MAXOPENFILES 2 rate 50M;

new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK MAXOPENFILES 2 RATE 50 M;
new RMAN configuration parameters are successfully stored

RMAN> backup database;

Starting backup at 01-FEB-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=503 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=00002 name=+DATA/dwqual01/datafile/sysaux.265.870358459
input datafile file number=00001 name=+DATA/dwqual01/datafile/system.266.870358459
input datafile file number=00003 name=+DATA/dwqual01/datafile/undotbs1.267.870358459
input datafile file number=00005 name=+DATA/dwqual01/datafile/audtbs.268.870358459
input datafile file number=00006 name=+DATA/dwqual01/datafile/dvtbs.269.870358459
input datafile file number=00004 name=+DATA/dwqual01/datafile/users.270.870358459
channel ORA_DISK_1: starting piece 1 at 01-FEB-15
channel ORA_DISK_1: finished piece 1 at 01-FEB-15
piece handle=+ARCHIVE/dwqual01/backupset/2015_02_01/nnndf0_tag20150201t120227_0.611.870523349 tag=TAG20150201T120227 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
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 01-FEB-15
channel ORA_DISK_1: finished piece 1 at 01-FEB-15
piece handle=+ARCHIVE/dwqual01/backupset/2015_02_01/ncsnf0_tag20150201t120227_0.618.870523365 tag=TAG20150201T120227 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 01-FEB-15

RMAN>

Checking with sqlplus:

SQL> /

TYPE      STATUS      FILENAME                  BUFFER_SIZE BUFFER_COUNT
--------- ----------- ------------------------- ----------- ------------
INPUT     IN PROGRESS +DATA/dwqual01/datafile/s     1048576            8
                      ysaux.265.870358459

INPUT     IN PROGRESS +DATA/dwqual01/datafile/s     1048576            8
                      ystem.266.870358459

OUTPUT    IN PROGRESS +ARCHIVE/dwqual01/backups     4194304            4
                      et/2015_02_01/nnndf0_tag2
                      0150201t120227_0.611.8705
                      23349


SQL>

As we can see, now my rman channel is reading from 2 datafiles simultaneously. Thus, my level of multiplexing here is 2.

Remeber, in case files being backed up are ASM files, level of multiplexing may be reduced as ASM automatically takes care of the contention by striping the data. So a MAXOPENFILES of 5 does not necessarily means that you will have a multiplexing level of 5 when you backup to ASM.


External pages that helped in this article:

  • http://oracleinaction.com/tune-rman-i/
  • http://docs.oracle.com/cd/E11882_01/backup.112/e10642/glossary.htm#CHDHHBFC
Have you enjoyed? Please leave a comment or give a 👍!

29 comments

Skip to comment form

    • Jeff on October 30, 2015 at 12:08
    • Reply

    Thanks for your sharing.

  1. thanks, very helpful article. cheers, Ergem.

    • Jeroen on May 10, 2016 at 07:44
    • Reply

    Perfect! Very useful to get these concepts correct in my mind.
    Thank you

    • Jamel on August 11, 2016 at 07:43
    • Reply

    always good to know. Thanks for your post.

    • Shahin on September 9, 2016 at 10:57
    • Reply

    Thank you ) It helped me really so much !

    • Nagaraju on September 16, 2016 at 03:06
    • Reply

    This article is really helpful and understandable.

    • Anurag on December 7, 2016 at 13:57
    • Reply

    Thanks a lot for this detailed and explanatory article. Much appreciated!!!

    • Andrew on February 23, 2017 at 16:44
    • Reply

    Great article!

    • mazen on April 6, 2017 at 11:11
    • Reply

    CONFIGURE MAXSETSIZE TO integer
    CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE integer
    why in the second i have to put channel device type disk , in the first i don't?

    1. Backup Set Size is a global attribute, you can't have different values for the max set size depending on the location (specially because it's a logical container).
      However, you can have different piece sizes depending on the location (as this defines the physical file size limit).
      Imagine a scenario where your local disk mount point is actually to a cloud storage that does not support files bigger than 4GB. However, your tape support files up to 32GB. You could set different max pieces depending on the target type.

      Regards,
      RJ

        • mazen on April 8, 2017 at 02:39
        • Reply

        thanks,
        appreciated.

    • Thachton on May 4, 2017 at 15:50
    • Reply

    You just helped one more person: myself. Thank you so much. You are awesome kind with your instructions.

  2. Thank you..!! It was helpful..!!

    • sundar kannan on November 23, 2017 at 09:51
    • Reply

    Can you clarify my doubt?

    When there are no controlfiles and the DB instance is not yet started, how come rman command "show all" shows all the rman configurations ?

    from where it reads from ??
    I wonder there's no catalog db, db instance is not yet started, but still I see show all command works .

    1. So, all the configuration attributes of RMAN are kept inside the controlfile. If we start the database in nomount and run SHOW ALL, it will show you all values as "#default", not the ones you configured. To understand why, we can start rman in debug mode (rman target / debug=ALL log=/tmp/a.log) and run a SHOW ALL, we see sections inside the log like:

      DBGSQL: TARGET> select algorithm_id, algorithm_name, length(algorithm_name) into :algorithm_id, :algorithm_name, :algorithm_namelen from v$rman_encryption_algorithms where lower(is_default) = 'yes'
      DBGSQL: sqlcode = 0
      DBGSQL: D :algorithm_id = 1
      DBGSQL: D :algorithm_name = AES128
      DBGSQL: D :algorithm_namelen = 6
      RMAN-01005: CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

      v$rman_encryption_algorithms is a example of a static internal view available even in nomount mode. But again, the returned values are the defaults, not the ones configured in your DB controlfile.

    • Bala on March 23, 2018 at 19:39
    • Reply

    Can i specify a sector size with backup database?

    • Bala on March 23, 2018 at 19:41
    • Reply

    Sorry section size. Can I specify it just for some files during a full database backup? Thanks.

    • Ziad Fawzi on December 19, 2018 at 06:54
    • Reply

    Thanks a lot. Very useful article.

    • Yassine on January 7, 2019 at 19:49
    • Reply

    Very helpful and well explained

    Thanks a lot

    • Houssein on January 10, 2019 at 14:44
    • Reply

    Nice explanation

    • Alex on September 17, 2019 at 11:10
    • Reply

    Commenting on: MAXSETSIZE should be at least as large as the largest datafile.
    Having your failing example, where MAXSETSIZE is 1019M, and sysaux.dbf file is more than this value. What if your system.dbf had the same size as sysaux.dbf. Would MAXSETSIZE set to 1020M go ok with RMAN? Reading your post it looks like MAXSETSIZE is limiting the whole set, hence all datafiles sizes would count and RMAN would fail again. Am I wrong?

    1. "What if your system.dbf had the same size as sysaux.dbf. Would MAXSETSIZE set to 1020M go ok with RMAN?"
      Yes, it would work. RMAN would put sysaux.dbf in one backupset and system.dbf in another one. MAXSETSIZE limits the maximum size that a single backupset can have.

    • SALOMON LONDONO on April 15, 2020 at 19:39
    • Reply

    Wow! it is nice!!! Tks

    • Vlad on January 8, 2021 at 11:46
    • Reply

    Hello and Happy New Year!
    Massive thank you for the info posted and really appreciated! I am a big fan! 🙂

    But I have a question for which I would like to ask for your help!
    I cannot seem to be able to use the MAXPIECESIZE option in my Oracle 12.1 DB.
    And I get the output that you presented for MAXPIECESIZE only when using SECTIONSIZE.

    Please see below:

    -- MAXPIECESIZE: (it does not create bkp pieces of max 50 MB):
    --==============
    show all;

    RMAN configuration parameters for database with db_unique_name ORCL are:
    CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
    CONFIGURE BACKUP OPTIMIZATION ON;
    CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
    CONFIGURE CONTROLFILE AUTOBACKUP OFF;
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/my_dir/ctrl_%F.bkp';
    CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
    CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    CONFIGURE MAXSETSIZE TO UNLIMITED;
    CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
    CONFIGURE ENCRYPTION ALGORITHM 'AES192';
    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 '/home/oracle/app/product/12.1.0/dbhome_1/dbs/snapcf_orcl.f'; # default

    run
    {
    allocate channel ch1 device type disk format '/home/oracle/my_dir/sysaux_ch1_bkp_%d_%U.bkp';
    allocate channel ch2 device type disk format '/home/oracle/my_dir/sysaux_ch2_bkp_%d_%U.bkp';
    allocate channel ch3 device type disk format '/home/oracle/my_dir/sysaux_ch3_bkp_%d_%U.bkp';
    configure channel device type disk maxpiecesize 50M;
    backup tablespace sysaux;
    }

    allocated channel: ch1
    channel ch1: SID=37 device type=DISK

    allocated channel: ch2
    channel ch2: SID=51 device type=DISK

    allocated channel: ch3
    channel ch3: SID=1 device type=DISK

    new RMAN configuration parameters:
    CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 50 M;
    new RMAN configuration parameters are successfully stored
    starting full resync of recovery catalog
    --full resync complete

    Starting backup at 08-JAN-21
    channel ch1: starting full datafile backup set
    channel ch1: specifying datafile(s) in backup set
    input datafile file number=00003 name=/home/oracle/app/oradata/orcl/sysaux01.dbf
    channel ch1: starting piece 1 at 08-JAN-21
    channel ch1: finished piece 1 at 08-JAN-21
    piece handle=/home/oracle/my_dir/sysaux_ch1_bkp_ORCL_2hvk4k5h_1_1.bkp tag=TAG20210108T163041 comment=NONE
    channel ch1: backup set complete, elapsed time: 00:00:03
    --Finished backup at 08-JAN-21
    released channel: ch1
    released channel: ch2
    released channel: ch3

    list backup of tablespace sysaux;

    List of Backup Sets
    ===================

    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    2539 Full 478.42M DISK 00:00:02 08-JAN-21
    BP Key: 2542 Status: AVAILABLE Compressed: NO Tag: TAG20210108T163041
    Piece Name: /home/oracle/my_dir/sysaux_ch1_bkp_ORCL_2hvk4k5h_1_1.bkp
    List of Datafiles in backup set 2539
    File LV Type Ckp SCN Ckp Time Name
    ---- -- ---- ---------- --------- ----
    3 Full 1838348 08-JAN-21 /home/oracle/app/oradata/orcl/sysaux01.dbf

    -- SECTIONSIZE: (using section size I am able to get bkp pieces of max 50 MB):
    --==============

    RMAN> show all;

    RMAN configuration parameters for database with db_unique_name ORCL are:
    CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
    CONFIGURE BACKUP OPTIMIZATION ON;
    CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
    CONFIGURE CONTROLFILE AUTOBACKUP OFF;
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/my_dir/ctrl_%F.bkp';
    CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
    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 MAXPIECESIZE 50 M;
    CONFIGURE MAXSETSIZE TO UNLIMITED;
    CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
    CONFIGURE ENCRYPTION ALGORITHM 'AES192';
    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 '/home/oracle/app/product/12.1.0/dbhome_1/dbs/snapcf_orcl.f'; # default

    run
    {
    allocate channel ch1 device type disk format '/home/oracle/my_dir/sysaux_ch1_bkp_%d_%U.bkp';
    allocate channel ch2 device type disk format '/home/oracle/my_dir/sysaux_ch2_bkp_%d_%U.bkp';
    allocate channel ch3 device type disk format '/home/oracle/my_dir/sysaux_ch3_bkp_%d_%U.bkp';
    backup tablespace sysaux section size 50M;
    }

    allocated channel: ch1
    channel ch1: SID=37 device type=DISK

    allocated channel: ch2
    channel ch2: SID=51 device type=DISK

    allocated channel: ch3
    channel ch3: SID=1 device type=DISK

    Starting backup at 08-JAN-21
    channel ch1: starting full datafile backup set
    channel ch1: specifying datafile(s) in backup set
    input datafile file number=00003 name=/home/oracle/app/oradata/orcl/sysaux01.dbf
    backing up blocks 1 through 6400
    .
    .
    .
    channel ch3: backup set complete, elapsed time: 00:00:01
    channel ch2: finished piece 13 at 08-JAN-21
    piece handle=/home/oracle/my_dir/sysaux_ch2_bkp_ORCL_2ivk4kf1_13_1.bkp tag=TAG20210108T163545 comment=NONE
    channel ch2: backup set complete, elapsed time: 00:00:01
    --Finished backup at 08-JAN-21
    released channel: ch1
    released channel: ch2
    released channel: ch3

    list backup of tablespace sysaux;

    List of Backup Sets
    ===================

    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    2539 Full 478.42M DISK 00:00:02 08-JAN-21
    BP Key: 2542 Status: AVAILABLE Compressed: NO Tag: TAG20210108T163041
    Piece Name: /home/oracle/my_dir/sysaux_ch1_bkp_ORCL_2hvk4k5h_1_1.bkp
    List of Datafiles in backup set 2539
    File LV Type Ckp SCN Ckp Time Name
    ---- -- ---- ---------- --------- ----
    3 Full 1838348 08-JAN-21 /home/oracle/app/oradata/orcl/sysaux01.dbf

    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    2626 Full 478.80M DISK 00:00:05 08-JAN-21
    List of Datafiles in backup set 2626
    File LV Type Ckp SCN Ckp Time Name
    ---- -- ---- ---------- --------- ----
    3 Full 1838564 08-JAN-21 /home/oracle/app/oradata/orcl/sysaux01.dbf

    Backup Set Copy #1 of backup set 2626
    Device Type Elapsed Time Completion Time Compressed Tag
    ----------- ------------ --------------- ---------- ---
    DISK 00:00:05 08-JAN-21 NO TAG20210108T163545

    List of Backup Pieces for backup set 2626 Copy #1
    BP Key Pc# Status Piece Name
    ------- --- ----------- ----------
    2628 1 AVAILABLE /home/oracle/my_dir/sysaux_ch1_bkp_ORCL_2ivk4kf1_1_1.bkp
    2630 2 AVAILABLE /home/oracle/my_dir/sysaux_ch2_bkp_ORCL_2ivk4kf1_2_1.bkp
    2629 3 AVAILABLE /home/oracle/my_dir/sysaux_ch3_bkp_ORCL_2ivk4kf1_3_1.bkp
    2631 4 AVAILABLE /home/oracle/my_dir/sysaux_ch1_bkp_ORCL_2ivk4kf1_4_1.bkp
    2632 5 AVAILABLE /home/oracle/my_dir/sysaux_ch1_bkp_ORCL_2ivk4kf1_5_1.bkp
    2633 6 AVAILABLE /home/oracle/my_dir/sysaux_ch2_bkp_ORCL_2ivk4kf1_6_1.bkp
    2634 7 AVAILABLE /home/oracle/my_dir/sysaux_ch3_bkp_ORCL_2ivk4kf1_7_1.bkp
    2635 8 AVAILABLE /home/oracle/my_dir/sysaux_ch1_bkp_ORCL_2ivk4kf1_8_1.bkp
    2636 9 AVAILABLE /home/oracle/my_dir/sysaux_ch2_bkp_ORCL_2ivk4kf1_9_1.bkp
    2637 10 AVAILABLE /home/oracle/my_dir/sysaux_ch1_bkp_ORCL_2ivk4kf1_10_1.bkp
    2638 11 AVAILABLE /home/oracle/my_dir/sysaux_ch3_bkp_ORCL_2ivk4kf1_11_1.bkp
    2639 12 AVAILABLE /home/oracle/my_dir/sysaux_ch1_bkp_ORCL_2ivk4kf1_12_1.bkp
    2640 13 AVAILABLE /home/oracle/my_dir/sysaux_ch2_bkp_ORCL_2ivk4kf1_13_1.bkp

    [oracle@ocm12c my_dir]$ ls -larth
    total 3.3G
    -rw-r-----. 1 oracle oinstall 479M Jan 8 16:30 sysaux_ch1_bkp_ORCL_2hvk4k5h_1_1.bkp
    -rw-r-----. 1 oracle oinstall 34M Jan 8 16:35 sysaux_ch1_bkp_ORCL_2ivk4kf1_1_1.bkp
    -rw-r-----. 1 oracle oinstall 36M Jan 8 16:35 sysaux_ch2_bkp_ORCL_2ivk4kf1_2_1.bkp
    -rw-r-----. 1 oracle oinstall 40M Jan 8 16:35 sysaux_ch3_bkp_ORCL_2ivk4kf1_3_1.bkp
    -rw-r-----. 1 oracle oinstall 36M Jan 8 16:35 sysaux_ch1_bkp_ORCL_2ivk4kf1_4_1.bkp
    -rw-r-----. 1 oracle oinstall 40M Jan 8 16:35 sysaux_ch1_bkp_ORCL_2ivk4kf1_5_1.bkp
    -rw-r-----. 1 oracle oinstall 46M Jan 8 16:35 sysaux_ch2_bkp_ORCL_2ivk4kf1_6_1.bkp
    -rw-r-----. 1 oracle oinstall 38M Jan 8 16:35 sysaux_ch3_bkp_ORCL_2ivk4kf1_7_1.bkp
    -rw-r-----. 1 oracle oinstall 39M Jan 8 16:35 sysaux_ch1_bkp_ORCL_2ivk4kf1_8_1.bkp
    -rw-r-----. 1 oracle oinstall 48M Jan 8 16:35 sysaux_ch2_bkp_ORCL_2ivk4kf1_9_1.bkp
    -rw-r-----. 1 oracle oinstall 47M Jan 8 16:35 sysaux_ch1_bkp_ORCL_2ivk4kf1_10_1.bkp
    -rw-r-----. 1 oracle oinstall 40M Jan 8 16:35 sysaux_ch3_bkp_ORCL_2ivk4kf1_11_1.bkp
    -rw-r-----. 1 oracle oinstall 41M Jan 8 16:35 sysaux_ch1_bkp_ORCL_2ivk4kf1_12_1.bkp
    drwxr-xr-x. 5 oracle oinstall 4.0K Jan 8 16:35 .
    -rw-r-----. 1 oracle oinstall 56K Jan 8 16:35 sysaux_ch2_bkp_ORCL_2ivk4kf1_13_1.bkp

    -- MAXPIECESIZE & SECTIONSIZE - do not return any error when used together:
    --=========================

    RMAN> configure maxsetsize to 50M;

    old RMAN configuration parameters:
    CONFIGURE MAXSETSIZE TO UNLIMITED;
    new RMAN configuration parameters:
    CONFIGURE MAXSETSIZE TO 50 M;
    new RMAN configuration parameters are successfully stored
    starting full resync of recovery catalog
    full resync complete

    RMAN> show all;

    RMAN configuration parameters for database with db_unique_name ORCL are:
    CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
    CONFIGURE BACKUP OPTIMIZATION ON;
    CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
    CONFIGURE CONTROLFILE AUTOBACKUP OFF;
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/my_dir/ctrl_%F.bkp';
    CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
    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 MAXPIECESIZE 50 M;
    CONFIGURE MAXSETSIZE TO 50 M;
    CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
    CONFIGURE ENCRYPTION ALGORITHM 'AES192';
    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 '/home/oracle/app/product/12.1.0/dbhome_1/dbs/snapcf_orcl.f'; # default

    RMAN> run
    2> {
    3> allocate channel ch1 device type disk format '/home/oracle/my_dir/sysaux_ch1_bkp_%d_%U.bkp';
    4> allocate channel ch2 device type disk format '/home/oracle/my_dir/sysaux_ch2_bkp_%d_%U.bkp';
    5> allocate channel ch3 device type disk format '/home/oracle/my_dir/sysaux_ch3_bkp_%d_%U.bkp';
    6> backup tablespace sysaux section size 50M;
    7> }

    allocated channel: ch1
    channel ch1: SID=37 device type=DISK

    allocated channel: ch2
    channel ch2: SID=51 device type=DISK

    allocated channel: ch3
    channel ch3: SID=1 device type=DISK

    Starting backup at 08-JAN-21
    channel ch1: starting full datafile backup set
    channel ch1: specifying datafile(s) in backup set
    input datafile file number=00003 name=/home/oracle/app/oradata/orcl/sysaux01.dbf
    backing up blocks 1 through 6400
    channel ch1: starting piece 1 at 08-JAN-21
    .
    .
    .
    channel ch2: finished piece 13 at 08-JAN-21
    piece handle=/home/oracle/my_dir/sysaux_ch2_bkp_ORCL_2vvk4knt_13_1.bkp tag=TAG20210108T164028 comment=NONE
    channel ch2: backup set complete, elapsed time: 00:00:01
    Finished backup at 08-JAN-21
    released channel: ch1
    released channel: ch2
    released channel: ch3

    RMAN> list backup of tablespace sysaux;

    List of Backup Sets
    ===================

    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    2539 Full 478.42M DISK 00:00:02 08-JAN-21
    BP Key: 2542 Status: AVAILABLE Compressed: NO Tag: TAG20210108T163041
    Piece Name: /home/oracle/my_dir/sysaux_ch1_bkp_ORCL_2hvk4k5h_1_1.bkp
    List of Datafiles in backup set 2539
    File LV Type Ckp SCN Ckp Time Name
    ---- -- ---- ---------- --------- ----
    3 Full 1838348 08-JAN-21 /home/oracle/app/oradata/orcl/sysaux01.dbf

    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    2626 Full 478.80M DISK 00:00:05 08-JAN-21
    List of Datafiles in backup set 2626
    File LV Type Ckp SCN Ckp Time Name
    ---- -- ---- ---------- --------- ----
    3 Full 1838564 08-JAN-21 /home/oracle/app/oradata/orcl/sysaux01.dbf

    Backup Set Copy #1 of backup set 2626
    Device Type Elapsed Time Completion Time Compressed Tag
    ----------- ------------ --------------- ---------- ---
    DISK 00:00:05 08-JAN-21 NO TAG20210108T163545

    List of Backup Pieces for backup set 2626 Copy #1
    BP Key Pc# Status Piece Name
    ------- --- ----------- ----------
    2628 1 AVAILABLE /home/oracle/my_dir/sysaux_ch1_bkp_ORCL_2ivk4kf1_1_1.bkp
    2630 2 AVAILABLE /home/oracle/my_dir/sysaux_ch2_bkp_ORCL_2ivk4kf1_2_1.bkp
    2629 3 AVAILABLE /home/oracle/my_dir/sysaux_ch3_bkp_ORCL_2ivk4kf1_3_1.bkp
    2631 4 AVAILABLE /home/oracle/my_dir/sysaux_ch1_bkp_ORCL_2ivk4kf1_4_1.bkp
    2632 5 AVAILABLE /home/oracle/my_dir/sysaux_ch1_bkp_ORCL_2ivk4kf1_5_1.bkp
    2633 6 AVAILABLE /home/oracle/my_dir/sysaux_ch2_bkp_ORCL_2ivk4kf1_6_1.bkp
    2634 7 AVAILABLE /home/oracle/my_dir/sysaux_ch3_bkp_ORCL_2ivk4kf1_7_1.bkp
    2635 8 AVAILABLE /home/oracle/my_dir/sysaux_ch1_bkp_ORCL_2ivk4kf1_8_1.bkp
    2636 9 AVAILABLE /home/oracle/my_dir/sysaux_ch2_bkp_ORCL_2ivk4kf1_9_1.bkp
    2637 10 AVAILABLE /home/oracle/my_dir/sysaux_ch1_bkp_ORCL_2ivk4kf1_10_1.bkp
    2638 11 AVAILABLE /home/oracle/my_dir/sysaux_ch3_bkp_ORCL_2ivk4kf1_11_1.bkp
    2639 12 AVAILABLE /home/oracle/my_dir/sysaux_ch1_bkp_ORCL_2ivk4kf1_12_1.bkp
    2640 13 AVAILABLE /home/oracle/my_dir/sysaux_ch2_bkp_ORCL_2ivk4kf1_13_1.bkp

    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    2798 Full 478.80M DISK 00:00:04 08-JAN-21
    List of Datafiles in backup set 2798
    File LV Type Ckp SCN Ckp Time Name
    ---- -- ---- ---------- --------- ----
    3 Full 1838845 08-JAN-21 /home/oracle/app/oradata/orcl/sysaux01.dbf

    Backup Set Copy #1 of backup set 2798
    Device Type Elapsed Time Completion Time Compressed Tag
    ----------- ------------ --------------- ---------- ---
    DISK 00:00:04 08-JAN-21 NO TAG20210108T164028

    List of Backup Pieces for backup set 2798 Copy #1
    BP Key Pc# Status Piece Name
    ------- --- ----------- ----------
    2800 1 AVAILABLE /home/oracle/my_dir/sysaux_ch1_bkp_ORCL_2vvk4knt_1_1.bkp
    2801 2 AVAILABLE /home/oracle/my_dir/sysaux_ch2_bkp_ORCL_2vvk4knt_2_1.bkp
    2802 3 AVAILABLE /home/oracle/my_dir/sysaux_ch3_bkp_ORCL_2vvk4knt_3_1.bkp
    2803 4 AVAILABLE /home/oracle/my_dir/sysaux_ch1_bkp_ORCL_2vvk4knt_4_1.bkp
    2804 5 AVAILABLE /home/oracle/my_dir/sysaux_ch1_bkp_ORCL_2vvk4knt_5_1.bkp
    2805 6 AVAILABLE /home/oracle/my_dir/sysaux_ch2_bkp_ORCL_2vvk4knt_6_1.bkp
    2806 7 AVAILABLE /home/oracle/my_dir/sysaux_ch3_bkp_ORCL_2vvk4knt_7_1.bkp
    2807 8 AVAILABLE /home/oracle/my_dir/sysaux_ch1_bkp_ORCL_2vvk4knt_8_1.bkp
    2808 9 AVAILABLE /home/oracle/my_dir/sysaux_ch2_bkp_ORCL_2vvk4knt_9_1.bkp
    2809 10 AVAILABLE /home/oracle/my_dir/sysaux_ch1_bkp_ORCL_2vvk4knt_10_1.bkp
    2810 11 AVAILABLE /home/oracle/my_dir/sysaux_ch3_bkp_ORCL_2vvk4knt_11_1.bkp
    2811 12 AVAILABLE /home/oracle/my_dir/sysaux_ch1_bkp_ORCL_2vvk4knt_12_1.bkp
    2812 13 AVAILABLE /home/oracle/my_dir/sysaux_ch2_bkp_ORCL_2vvk4knt_13_1.bkp

    RMAN> show all;

    RMAN configuration parameters for database with db_unique_name ORCL are:
    CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
    CONFIGURE BACKUP OPTIMIZATION ON;
    CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
    CONFIGURE CONTROLFILE AUTOBACKUP OFF;
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/my_dir/ctrl_%F.bkp';
    CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
    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 MAXPIECESIZE 50 M;
    CONFIGURE MAXSETSIZE TO 50 M;
    CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
    CONFIGURE ENCRYPTION ALGORITHM 'AES192';
    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 '/home/oracle/app/product/12.1.0/dbhome_1/dbs/snapcf_orcl.f'; # default

    Thank you for your time and help!
    Your feedback is really appreciated!

    Kind regards,
    Vlad.

    1. Hi Vlad, thanks for your message and feedback.

      I believe all the issues above is because you are changing the DEFAULT CHANNEL (using CONFIGURE command) but allocating your own custom channels:

      run
      {
      allocate channel ch1 device type disk format '/home/oracle/my_dir/sysaux_ch1_bkp_%d_%U.bkp';
      allocate channel ch2 device type disk format '/home/oracle/my_dir/sysaux_ch2_bkp_%d_%U.bkp';
      allocate channel ch3 device type disk format '/home/oracle/my_dir/sysaux_ch3_bkp_%d_%U.bkp';
      configure channel device type disk maxpiecesize 50M; >>> THIS WILL NOT change c1, c2 and c3. <<< backup tablespace sysaux; } You should run: run { allocate channel ch1 device type disk maxpiecesize 50M format '/home/oracle/my_dir/sysaux_ch1_bkp_%d_%U.bkp'; allocate channel ch2 device type disk maxpiecesize 50M format '/home/oracle/my_dir/sysaux_ch2_bkp_%d_%U.bkp'; allocate channel ch3 device type disk maxpiecesize 50M format '/home/oracle/my_dir/sysaux_ch3_bkp_%d_%U.bkp'; backup tablespace sysaux; } Regards, RJ

    • Ravin Bharath Maharaj on July 23, 2021 at 08:58
    • Reply

    I have noticed that using a section size for bigfile tablespaces improves the backup speed. However, you can only do this on a primary db environment in case you are using dataguard. You will have to first exclude all your non-bigfile tablespaces, specify a section size for each bigfile tablespace prior to the backup; and then include all you non-bigfile tablespaces without a section size for the backup to complete. Unfortunately you can exclude tablespaces in a dataguard environment

    • Ravin Bharath Maharaj on August 1, 2021 at 13:50
    • Reply

    I have noticed that using a section size for bigfile tablespaces improves the backup speed. However, you can only do this on a primary db environment in case you are using dataguard. You will have to first exclude all your non-bigfile tablespaces, specify a section size for each bigfile tablespace prior to the backup; and then include all you non-bigfile tablespaces without a section size for the backup to complete. Unfortunately you CANNOT exclude tablespaces in a dataguard environment

    • Mari on April 15, 2022 at 07:55
    • Reply

    "Otherwise you are a wizard." 😃

    • Akhlaq on August 20, 2024 at 10:47
    • Reply

    Hi,
    I am facing the the following issue during my rman backup :

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03009: failure of backup command on ch6 channel at 08/17/2024 22:38:58
    ORA-19510: failed to set size of 45950961 blocks for file "/DATASTORE30/rman/arch_20240817_73561" (block size=512)
    ORA-27059: could not reduce file size
    SVR4 Error: 5: I/O error
    Additional information: 2

Leave a Reply

Your email address will not be published.