Oracle 12c: RMAN Multisection Image Copies & Incremental Backups

June 27th, 2013 | Posted in 12c, Blog, RMAN | 4 Comments

Playing with the new Oracle 12c, discovering the new RMAN Multisection Image Copies $ Incremental Backups;

First let’s connect to the PLUGGABLE database ORAWISS12C.

First, let ‘s set PARALLELISM to 5;


RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 5;

old RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 5 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters are successfully stored

RMAN> show all;

RMAN configuration parameters for database with db_unique_name ORAWISS are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 5 BACKUP TYPE TO BACKUPSET;
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; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
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 '/opt/app/oracle/product/12.1/db_1/dbs/snapcf_orawiss.f'; # default

1-Output without Multisection Image Copies;

sandbox1(orawiss):/home/oracle/wissem>rman

Recovery Manager: Release 12.1.0.1.0 - Production on Thu Jun 27 04:45:43 2013

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

RMAN> CONNECT TARGET "sys AS SYSBACKUP";

target database Password:
connected to target database: ORAWISS (DBID=3257067578)

RMAN> backup as copy  datafile 13 format '/home/oracle/wissem/bckp_dfile_13_%U';

Starting backup at 06/27/2013 04:46:11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=274 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=23 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=267 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=34 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=276 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00013 name=+DATA/ORAWISS/E011004AA64F0CF9E0433514DA0A096B/DATAFILE/tbs_rec.287.819121381
output file name=/home/oracle/wissem/bckp_dfile_13_data_D-ORAWISS_I-3257067578_TS-TBS_REC_FNO-13_14od784m tag=TAG20130627T044614 RECID=4 STAMP=819175575
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 06/27/2013 04:46:15

Starting Control File and SPFILE Autobackup at 06/27/2013 04:46:15
piece handle=+DATA/ORAWISS/AUTOBACKUP/2013_06_27/s_819175575.316.819175575 comment=NONE
Finished Control File and SPFILE Autobackup at 06/27/2013 04:46:16

RMAN>

Note the use of only one channel to backup datafile 13.

2-Output with Multisection Image Copies;

Image copies can be taken with the SECTION SIZE option to divide data files into subsections that can be backed up in parallel across multiple channels. This feature reduces image copy creation time for large data files …


sandbox1(orawiss):/home/oracle/wissem>rman

Recovery Manager: Release 12.1.0.1.0 - Production on Thu Jun 27 04:43:37 2013

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

RMAN> CONNECT TARGET "sys AS SYSBACKUP";

target database Password:
connected to target database: ORAWISS (DBID=3257067578)

RMAN> backup as copy section size 20M datafile 13 format '/home/oracle/wissem/backup_dfile_13_%U';

Starting backup at 06/27/2013 04:43:49
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=274 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=45 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=267 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=23 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=275 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00013 name=+DATA/ORAWISS/E011004AA64F0CF9E0433514DA0A096B/DATAFILE/tbs_rec.287.819121381
backing up blocks 1 through 2560
channel ORA_DISK_2: starting datafile copy
input datafile file number=00013 name=+DATA/ORAWISS/E011004AA64F0CF9E0433514DA0A096B/DATAFILE/tbs_rec.287.819121381
backing up blocks 2561 through 5120
channel ORA_DISK_3: starting datafile copy
input datafile file number=00013 name=+DATA/ORAWISS/E011004AA64F0CF9E0433514DA0A096B/DATAFILE/tbs_rec.287.819121381
backing up blocks 5121 through 7680
channel ORA_DISK_4: starting datafile copy
input datafile file number=00013 name=+DATA/ORAWISS/E011004AA64F0CF9E0433514DA0A096B/DATAFILE/tbs_rec.287.819121381
backing up blocks 7681 through 10240
channel ORA_DISK_5: starting datafile copy
input datafile file number=00013 name=+DATA/ORAWISS/E011004AA64F0CF9E0433514DA0A096B/DATAFILE/tbs_rec.287.819121381
backing up blocks 10241 through 12800
output file name=/home/oracle/wissem/backup_dfile_13_data_D-ORAWISS_I-3257067578_TS-TBS_REC_FNO-13_0uod7808 tag=TAG20130627T044352
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
output file name=/home/oracle/wissem/backup_dfile_13_data_D-ORAWISS_I-3257067578_TS-TBS_REC_FNO-13_0uod7808 tag=TAG20130627T044352
channel ORA_DISK_2: datafile copy complete, elapsed time: 00:00:02
output file name=/home/oracle/wissem/backup_dfile_13_data_D-ORAWISS_I-3257067578_TS-TBS_REC_FNO-13_0uod7808 tag=TAG20130627T044352
channel ORA_DISK_3: datafile copy complete, elapsed time: 00:00:02
output file name=/home/oracle/wissem/backup_dfile_13_data_D-ORAWISS_I-3257067578_TS-TBS_REC_FNO-13_0uod7808 tag=TAG20130627T044352
channel ORA_DISK_4: datafile copy complete, elapsed time: 00:00:01
output file name=/home/oracle/wissem/backup_dfile_13_data_D-ORAWISS_I-3257067578_TS-TBS_REC_FNO-13_0uod7808 tag=TAG20130627T044352
channel ORA_DISK_5: datafile copy complete, elapsed time: 00:00:01
Finished backup at 06/27/2013 04:43:54

Starting Control File and SPFILE Autobackup at 06/27/2013 04:43:54
piece handle=+DATA/ORAWISS/AUTOBACKUP/2013_06_27/s_819175434.315.819175435 comment=NONE
Finished Control File and SPFILE Autobackup at 06/27/2013 04:43:55

RMAN> exit


Recovery Manager complete.

3- Multisection Incremental backups;


sandbox1(orawiss):/home/oracle>rman

Recovery Manager: Release 12.1.0.1.0 - Production on Thu Jun 27 04:41:47 2013

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

RMAN> CONNECT TARGET "sys AS SYSBACKUP";

target database Password:
connected to target database: ORAWISS (DBID=3257067578)

RMAN>  backup incremental level 1 section size 20M datafile 13 format '/home/oracle/wissem/backup_datafile_13_%U';

Starting backup at 06/27/2013 04:42:04
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=275 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=40 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=274 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=23 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=267 device type=DISK
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00013 name=+DATA/ORAWISS/E011004AA64F0CF9E0433514DA0A096B/DATAFILE/tbs_rec.287.819121381
backing up blocks 1 through 2560
channel ORA_DISK_1: starting piece 1 at 06/27/2013 04:42:06
channel ORA_DISK_2: starting incremental level 1 datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
input datafile file number=00013 name=+DATA/ORAWISS/E011004AA64F0CF9E0433514DA0A096B/DATAFILE/tbs_rec.287.819121381
backing up blocks 2561 through 5120
channel ORA_DISK_2: starting piece 2 at 06/27/2013 04:42:07
channel ORA_DISK_3: starting incremental level 1 datafile backup set
channel ORA_DISK_3: specifying datafile(s) in backup set
input datafile file number=00013 name=+DATA/ORAWISS/E011004AA64F0CF9E0433514DA0A096B/DATAFILE/tbs_rec.287.819121381
backing up blocks 5121 through 7680
channel ORA_DISK_3: starting piece 3 at 06/27/2013 04:42:07
channel ORA_DISK_4: starting incremental level 1 datafile backup set
channel ORA_DISK_4: specifying datafile(s) in backup set
input datafile file number=00013 name=+DATA/ORAWISS/E011004AA64F0CF9E0433514DA0A096B/DATAFILE/tbs_rec.287.819121381
backing up blocks 7681 through 10240
channel ORA_DISK_4: starting piece 4 at 06/27/2013 04:42:07
channel ORA_DISK_5: starting incremental level 1 datafile backup set
channel ORA_DISK_5: specifying datafile(s) in backup set
input datafile file number=00013 name=+DATA/ORAWISS/E011004AA64F0CF9E0433514DA0A096B/DATAFILE/tbs_rec.287.819121381
backing up blocks 10241 through 12800
channel ORA_DISK_5: starting piece 5 at 06/27/2013 04:42:07
channel ORA_DISK_1: finished piece 1 at 06/27/2013 04:42:07
piece handle=/home/oracle/wissem/backup_datafile_13_0ood77su_1_1 tag=TAG20130627T044206 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_2: finished piece 2 at 06/27/2013 04:42:07
piece handle=/home/oracle/wissem/backup_datafile_13_0ood77su_2_1 tag=TAG20130627T044206 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:00
channel ORA_DISK_3: finished piece 3 at 06/27/2013 04:42:07
piece handle=/home/oracle/wissem/backup_datafile_13_0ood77su_3_1 tag=TAG20130627T044206 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:00
channel ORA_DISK_4: finished piece 4 at 06/27/2013 04:42:08
piece handle=/home/oracle/wissem/backup_datafile_13_0ood77su_4_1 tag=TAG20130627T044206 comment=NONE
channel ORA_DISK_4: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_5: finished piece 5 at 06/27/2013 04:42:08
piece handle=/home/oracle/wissem/backup_datafile_13_0ood77su_5_1 tag=TAG20130627T044206 comment=NONE
channel ORA_DISK_5: backup set complete, elapsed time: 00:00:01
Finished backup at 06/27/2013 04:42:08

Starting Control File and SPFILE Autobackup at 06/27/2013 04:42:08
piece handle=+DATA/ORAWISS/AUTOBACKUP/2013_06_27/s_819175328.314.819175329 comment=NONE
Finished Control File and SPFILE Autobackup at 06/27/2013 04:42:09

RMAN> exit


Recovery Manager complete.
sandbox1(orawiss):/home/oracle>cd wissem
sandbox1(orawiss):/home/oracle/wissem>ls -rtl
total 1312
-rw-r----- 1 oracle asmadmin 1146880 Jun 27 04:42 backup_datafile_13_0ood77su_1_1
-rw-r----- 1 oracle asmadmin   49152 Jun 27 04:42 backup_datafile_13_0ood77su_2_1
-rw-r----- 1 oracle asmadmin   49152 Jun 27 04:42 backup_datafile_13_0ood77su_3_1
-rw-r----- 1 oracle asmadmin   49152 Jun 27 04:42 backup_datafile_13_0ood77su_4_1
-rw-r----- 1 oracle asmadmin   49152 Jun 27 04:42 backup_datafile_13_0ood77su_5_1

sandbox1(orawiss):/home/oracle/wissem>

4-Output from 11g;

sandbox1(orawiss):/home/oracle>rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jun 27 04:49:34 2013

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

connected to target database: DEV11G (DBID=4095415307)

RMAN> backup as copy section size 20M datafile 1 format '/home/oracle/wissem/backup_dfile_1_%U';

Starting backup at 27-JUN-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=83 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 06/27/2013 04:49:56
RMAN-06580: the SECBYTES option cannot be used with AS COPY

RMAN>

Cheers,
Wissem

References: Doc 12cR1



4 Comments to “Oracle 12c: RMAN Multisection Image Copies & Incremental Backups”

  1. This one is perfect , lot of features added to rman


Leave a Comment





Polls

which oracle topic interests you most?

View Results

Loading ... Loading ...


Oracle Class Tweets


Recent Posts


Recent Comments

  • Adrian Iriarte: Saludos, Que buen articulo, casi siempre al momento de querer implementar soluciones para el...
  • Patricia: Hi Wissem, is there a workaround for this? I mean I want to use the sqlnet.authentication_services =none,...
  • Brian: I created the cdb manually using the instruction, but then I tried to create pdb within in, it failed. have...
  • Farmer Johnson: Hi Wissem. How did you avoid the error you had previsouly encountered: “sudo opatch auto...
  • Héctor Moro: Querido Nelson; Después de entrevistar a mas de 50 profesionales de primer nivel en Uruguay, al fin te...
  • What is NO2 Maximus: I genuinely apрreciated your site! You shoulԁ update it wiϳth new info!
  • Nav: Indeed helpful, to the point article..
  • Koti: Can you please explain all the sections of AWR report in RAC. I mean to ask output produced by awrgrpt.sql...
  • Himanshu: Nice post.can you please comment on this Why RMAN restored the DATA_REORTING datafie to +DATA diskgroup?
  • Enrique: Great post.
  • gabriel: what version of sqldeveloper support plugable database?
  • Kal: Quality – thanks…
  • wissem: Well , like I mentioned in the post, delete service and add service using IP.
  • Kelly: were you able to solve this? Thanks!
  • wissem: Hello, You can buy the book from PakT: http://www.packtpub.com/oracle -data-guard-11gr2-administr...
  • goutham: hi i want to buy this book.could you please let me know how can i buy this book. i am in Malaysia. thanks...
  • cesar Lopez: Hola me gustaria saber tu punto de vista de MYSQl vs ORACLE para una sistema de Nomina de unos 1500...
  • wissem: Check my previous article in English; Oracle 12c: RMAN recover Table http://www.oracle-class.com/?p =2866
  • NILESH: Sir, English please
  • Ramakrishna: I want step by step installation of Hyper-table in windows and also usage of Hyper-table like data...