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
28 comments
Skip to comment form
Thanks for your sharing.
thanks, very helpful article. cheers, Ergem.
Perfect! Very useful to get these concepts correct in my mind.
Thank you
always good to know. Thanks for your post.
Thank you ) It helped me really so much !
This article is really helpful and understandable.
Thanks a lot for this detailed and explanatory article. Much appreciated!!!
Great article!
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?
Author
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
thanks,
appreciated.
You just helped one more person: myself. Thank you so much. You are awesome kind with your instructions.
Thank you..!! It was helpful..!!
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 .
Author
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.
Can i specify a sector size with backup database?
Sorry section size. Can I specify it just for some files during a full database backup? Thanks.
Thanks a lot. Very useful article.
Very helpful and well explained
Thanks a lot
Nice explanation
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?
Author
"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.
Wow! it is nice!!! Tks
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.
Author
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
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
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
"Otherwise you are a wizard." 😃