Saturday, September 27, 2014

1z0-060 Making Multisection Backups Using Image Copies

RMAN enables you to create multisection backups using image copies. Multisection backups provide better performance by using multiple channels to back up large files in parallel. Starting with Oracle Database 12c Release 1 (12.1), you can create multisection full backups that are stored as image copies. While the image copy is being created, multiple channels are used to write files sections. However, the output of this operation is one copy for each data file.

Use the SECTION SIZE clause to create multisection backups. If the section size that you specify is larger than the size of the file, then RMAN does not use multisection backups for that 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.

oracle@s11:~$ rman target /

Recovery Manager: Release 12.1.0.1.0 - Production on Sat Sep 27 23:22:49 2014

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1359083830)

RMAN>
RMAN> run{
2> allocate channel ch1 device type disk;
3> allocate channel ch2 device type disk;
4> allocate channel ch3 device type disk;
5> allocate channel ch4 device type disk;
6> backup as copy tablespace system section size 100M;
7> }

released channel: ORA_DISK_1
allocated channel: ch1
channel ch1: SID=77 device type=DISK

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

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

allocated channel: ch4
channel ch4: SID=68 device type=DISK

Starting backup at 27-SEP-14
channel ch1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
backing up blocks 1 through 12800
channel ch2: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
backing up blocks 12801 through 25600
channel ch3: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
backing up blocks 25601 through 38400
channel ch4: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
backing up blocks 38401 through 51200
output file name=/u01/app/oracle/fast_recovery_area/ORCL/datafile/o1_mf_system_b2fojz9l_.dbf tag=TAG20140927T232207
channel ch1: datafile copy complete, elapsed time: 00:00:13
channel ch1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
backing up blocks 51201 through 64000
output file name=/u01/app/oracle/fast_recovery_area/ORCL/datafile/o1_mf_system_b2fojz9l_.dbf tag=TAG20140927T232207
channel ch2: datafile copy complete, elapsed time: 00:00:14
channel ch2: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
backing up blocks 64001 through 76800
output file name=/u01/app/oracle/fast_recovery_area/ORCL/datafile/o1_mf_system_b2fojz9l_.dbf tag=TAG20140927T232207
channel ch3: datafile copy complete, elapsed time: 00:00:14
channel ch3: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
backing up blocks 76801 through 89600
output file name=/u01/app/oracle/fast_recovery_area/ORCL/datafile/o1_mf_system_b2fojz9l_.dbf tag=TAG20140927T232207
channel ch1: datafile copy complete, elapsed time: 00:00:12
channel ch1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
backing up blocks 89601 through 101120
output file name=/u01/app/oracle/fast_recovery_area/ORCL/datafile/o1_mf_system_b2fojz9l_.dbf tag=TAG20140927T232207
channel ch4: datafile copy complete, elapsed time: 00:00:20
output file name=/u01/app/oracle/fast_recovery_area/ORCL/datafile/o1_mf_system_b2fojz9l_.dbf tag=TAG20140927T232207
channel ch2: datafile copy complete, elapsed time: 00:00:15
output file name=/u01/app/oracle/fast_recovery_area/ORCL/datafile/o1_mf_system_b2fojz9l_.dbf tag=TAG20140927T232207
channel ch3: datafile copy complete, elapsed time: 00:00:10
output file name=/u01/app/oracle/fast_recovery_area/ORCL/datafile/o1_mf_system_b2fojz9l_.dbf tag=TAG20140927T232207
channel ch1: datafile copy complete, elapsed time: 00:00:08
Finished backup at 27-SEP-14

Starting Control File and SPFILE Autobackup at 27-SEP-14
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2014_09_27/o1_mf_s_859418562_b2fol2ko_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 27-SEP-14
released channel: ch1
released channel: ch2
released channel: ch3
released channel: ch4

RMAN> exit