One of the Rman multisection backup tests

Multisection Backup is a new feature of oracle11g (to be exact, starting with 11.1.0.6), see MOS article

multisection Backups (document ID 406295.1)

Let's do the experiment below:

[[email protected] ~]$ rman target/recovery manager:release 11.2.0.4.0-production on Thu Feb 01:07:28 2015Copy  Right (c) 1982, and Oracle and/or its affiliates. All rights reserved.connected to target Database:test (dbid=2106028980) rman> report schema;using target database Contr OL file instead of recovery Catalogreport of the database schema for database with Db_unique_name testlist of Permanent Datafi Les===========================file Size (MB) tablespace RB segs datafile Name--------------------------------- ------------------------------1 SYSTEM * * */U01/APP/ORACLE/ORADATA/TEST/SYSTEM01.DBF2 33 Sysaux * * */U01/APP/ORACLE/ORADATA/TEST/SYSAUX01.DBF3 UNDOTBS1 * */U 01/APP/ORACLE/ORADATA/TEST/UNDOTBS01.DBF4 7 USERS * * */u01/app/oracle/oradata/test/users01.db     F5 Tentbs * * */u01/app/oracle/oradata/test/ten01.dbf6 5   Tb_test * * */U01/APP/ORACLE/ORADATA/TEST/TB_TEST_01.DBF7 TS1 * * */u01       /app/oracle/oradata/test/ts1.dbf8 TS2 * * */U01/APP/ORACLE/ORADATA/TEST/TS2.DBF9 50 TEST * * */U01/APP/ORACLE/ORADATA/TEST/TEST01.DBF10 test_uni_sz_2m * * */u01/app /ORACLE/ORADATA/TEST/TEST_UNI_SZ_2M_01.DBF11 test_uni_sz_1m * * */u01/app/oracle/oradata/test/test_uni _sz_1m_01.dbflist of temporary files=======================file Size (MB) tablespace Maxsize (MB) tempfile Name--- ------------------------------------------------------------1 157 TEMP 32767/u01/app/or Acle/oradata/test/temp01.dbfrman> Show All; RMAN configuration parameters for database with Db_unique_name TEST are:configure RETENTION POLICY to redundancy 1; # defaultconfigure BACKUP optimization OFF; # defaultconfigure DEFAULT DEVICE TYPE to DISK; # DEFAULTCONFIGure Controlfile autobackup OFF; # defaultconfigure Controlfile autobackup FORMAT for DEVICE TYPE DISK to '%F '; # defaultconfigure DEVICE type DISK PARALLELISM 1 BACKUP type to BACKUPSET; # defaultconfigure datafile BACKUP COPIES for DEVICE TYPE DISK to 1; # defaultconfigure ARCHIVELOG BACKUP COPIES for DEVICE TYPE DISK to 1; # defaultconfigure maxsetsize to UNLIMITED; # defaultconfigure encryption for DATABASE OFF; # defaultconfigure encryption algorithm ' AES128 '; # defaultconfigure COMPRESSION algorithm ' BASIC ' as of RELEASE ' DEFAULT ' OPTIMIZE for LOAD TRUE; # defaultconfigure ARCHIVELOG deletion POLICY to NONE; # defaultconfigure SNAPSHOT controlfile NAME to '/u02/app/oracle/product/11.2.0.4/db_1/dbs/snapcf_test.f '; # defaultrman> Backup section size 300m datafile 1 format '/u02/%u '; Starting backup at 19-feb-15allocated channel:ora_disk_1channel ora_disk_1:sid=133 device Type=diskchannel ORA_DISK_1: Starting full datafile backup Setchannel ora_disk_1:specifying datafile (s) in Backup setinput datafile file number=00001 name=/u01/app/oracle/oradata/test/system01.dbf----> System01.dbfbacking up blocks 1 through 38400---------------------------------------------------> Note here Channel Ora_ Disk_1:starting piece 1 at 19-feb-15channel ora_disk_1:finished piece 1 at 19-feb-15piece handle=/u02/06pvkh2l_1_1 Tag=T ag20150219t011148 Comment=none------------------> generated backuppiecechannel ora_disk_1:backup set complete, elapsed Time:00:00:28channel ora_disk_1:starting full datafile backup Setchannel ora_disk_1:specifying datafile (s) in Backup SE Tinput datafile file number=00001 name=/u01/app/oracle/oradata/test/system01.dbf---->system01.dbfbacking up Blocks 38401 through 76800-----------------------------------------------> Note here Channel ora_disk_1:starting piece 2 At 19-feb-15channel ora_disk_1:finished piece 2 at 19-feb-15piece handle=/u02/06pvkh2l_2_1 tag=tag20150219t011148 Comment=none------------------> Generated Backuppiecechannel ora_disk_1:backup set CoMplete, elapsed Time:00:00:16channel ora_disk_1:starting full datafile backup Setchannel ora_disk_1:specifying datafile (s) in Backup setinput datafile file number=00001 name=/u01/app/oracle/oradata/test/system01.dbf----> System01.dbfbacking up blocks 76801 through 102400----------------------------------------------> Note here Channel Ora_ Disk_1:starting piece 3 at 19-feb-15channel ora_disk_1:finished piece 3 at 19-feb-15piece handle=/u02/06pvkh2l_3_1 Tag=T ag20150219t011148 Comment=non------------------> generated backuppiecechannel ora_disk_1:backup set complete, elapsed Time:00:00:16channel ora_disk_1:starting full datafile backup Setchannel ora_disk_1:specifying datafile (s) in Backup SE  Tincluding current control file in Backup setincluding current SPFILE in Backup Setchannel ora_disk_1:starting piece 1 at 19-feb-15channel ora_disk_1:finished piece 1 at 19-feb-15piece handle=/u02/09pvkh4o_1_1 tag=tag20150219t011148 Comment =none---> This backuppiece is an automatic backup of the control file because the Datafile1 backup automatically triggers the controlBackup of the system files.  Channel Ora_disk_1:backup set complete, elapsed time:00:00:01finished backup at 19-feb-15rman>

A datafile, using the Backup section size method to do backups, divided into 3 backuppiece, because the above experiment is done in a channel, not to show the advantages of multiple channel simultaneous work, therefore, The datafile will be allocated 2 channel in a separate article to back up the.

One of the Rman multisection backup tests