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
29 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." 😃
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