Subscribe to Posts by Email

Subscriber Count

    696

Disclaimer

All information is offered in good faith and in the hope that it may be of use for educational purpose and for Database community purpose, but is not guaranteed to be correct, up to date or suitable for any particular purpose. db.geeksinsight.com accepts no liability in respect of this information or its use. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content and if notify any such I am happy to remove. Product and company names mentioned in this website may be the trademarks of their respective owners and published here for informational purpose only. This is my personal blog. The views expressed on these pages are mine and learnt from other blogs and bloggers and to enhance and support the DBA community and this web blog does not represent the thoughts, intentions, plans or strategies of my current employer nor the Oracle and its affiliates or any other companies. And this website does not offer or take profit for providing these content and this is purely non-profit and for educational purpose only. If you see any issues with Content and copy write issues, I am happy to remove if you notify me. Contact Geek DBA Team, via geeksinsights@gmail.com

Pages

12c Database : RMAN Enhancements : Multisection backups for image copy backup

	[oracle@Geek DBA12c admin]$ rman target /

	Recovery Manager: Release 12.1.0.1.0 - Production on Fri Sep 13 21:15:43 2013

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

	connected to target database: DB12C (DBID=1279089071)

	RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 5;

	using target database control file instead of recovery catalog
	new RMAN configuration parameters:
	CONFIGURE DEVICE TYPE DISK PARALLELISM 5 BACKUP TYPE TO BACKUPSET;
	new RMAN configuration parameters are successfully stored

	RMAN> backup as copy  section size 100M datafile 3 format '/home/oracle/backup_copy_sysaux_%U';

	Starting backup at 13-SEP-13
	using channel ORA_DISK_1
	using channel ORA_DISK_2
	using channel ORA_DISK_3
	using channel ORA_DISK_4
	using channel ORA_DISK_5
	channel ORA_DISK_1: starting datafile copy
	input datafile file number=00003 name=/u01/app/oracle/oradata/DB12c/sysaux01.dbf
	backing up blocks 1 through 12800
	channel ORA_DISK_2: starting datafile copy
	input datafile file number=00003 name=/u01/app/oracle/oradata/DB12c/sysaux01.dbf
	backing up blocks 12801 through 25600
	channel ORA_DISK_3: starting datafile copy
	input datafile file number=00003 name=/u01/app/oracle/oradata/DB12c/sysaux01.dbf
	backing up blocks 25601 through 38400
	channel ORA_DISK_4: starting datafile copy
	input datafile file number=00003 name=/u01/app/oracle/oradata/DB12c/sysaux01.dbf
	backing up blocks 38401 through 51200
	channel ORA_DISK_5: starting datafile copy
	input datafile file number=00003 name=/u01/app/oracle/oradata/DB12c/sysaux01.dbf
	backing up blocks 51201 through 64000
	output file name=/home/oracle/backup_copy_sysaux_data_D-DB12C_I-1279089071_TS-SYSAUX_FNO-3_0iojpc1d tag=TAG20130913T212045
	channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:26
	channel ORA_DISK_1: starting datafile copy
	input datafile file number=00003 name=/u01/app/oracle/oradata/DB12c/sysaux01.dbf
	backing up blocks 64001 through 76800
	output file name=/home/oracle/backup_copy_sysaux_data_D-DB12C_I-1279089071_TS-SYSAUX_FNO-3_0iojpc1d tag=TAG20130913T212045
	channel ORA_DISK_2: datafile copy complete, elapsed time: 00:00:26
	channel ORA_DISK_2: starting datafile copy
	input datafile file number=00003 name=/u01/app/oracle/oradata/DB12c/sysaux01.dbf
	backing up blocks 76801 through 89600
	output file name=/home/oracle/backup_copy_sysaux_data_D-DB12C_I-1279089071_TS-SYSAUX_FNO-3_0iojpc1d tag=TAG20130913T212045
	channel ORA_DISK_3: datafile copy complete, elapsed time: 00:00:26
	channel ORA_DISK_3: starting datafile copy
	input datafile file number=00003 name=/u01/app/oracle/oradata/DB12c/sysaux01.dbf
	backing up blocks 89601 through 90880
	output file name=/home/oracle/backup_copy_sysaux_data_D-DB12C_I-1279089071_TS-SYSAUX_FNO-3_0iojpc1d tag=TAG20130913T212045
	channel ORA_DISK_4: datafile copy complete, elapsed time: 00:00:26
	output file name=/home/oracle/backup_copy_sysaux_data_D-DB12C_I-1279089071_TS-SYSAUX_FNO-3_0iojpc1d tag=TAG20130913T212045
	channel ORA_DISK_5: datafile copy complete, elapsed time: 00:00:26
	output file name=/home/oracle/backup_copy_sysaux_data_D-DB12C_I-1279089071_TS-SYSAUX_FNO-3_0iojpc1d tag=TAG20130913T212045
	channel ORA_DISK_3: datafile copy complete, elapsed time: 00:00:03

	output file name=/home/oracle/backup_copy_sysaux_data_D-DB12C_I-1279089071_TS-SYSAUX_FNO-3_0iojpc1d tag=TAG20130913T212045
	channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:16
	output file name=/home/oracle/backup_copy_sysaux_data_D-DB12C_I-1279089071_TS-SYSAUX_FNO-3_0iojpc1d tag=TAG20130913T212045
	channel ORA_DISK_2: datafile copy complete, elapsed time: 00:00:16
	Finished backup at 13-SEP-13

	Starting Control File and SPFILE Autobackup at 13-SEP-13
	piece handle=/u01/app/oracle/fast_recovery_area/DB12C/autobackup/2013_09_13/o1_mf_s_826060887_936f3zh5_.bkp comment=NONE
	Finished Control File and SPFILE Autobackup at 13-SEP-13

At OS or in DISK the file is only one,

	[oracle@Geek DBA12c ~]$ ls -ltr
	-rw-r-----. 1 oracle oinstall 744497152 Sep 13 21:21 backup_copy_sysaux_data_D-DB12C_I-1279089071_TS-SYSAUX_FNO-3_0iojpc1d
	[oracle@Geek DBA12c ~]$
-Thanks
Geek DBA	

With multisection copies the backup will be faster than earlier

Prior to 12c, If you are taking a backup of database or datafile for image copy, the file will be copied as is, and backup cannot split into multiple pieces.

According to documentation, you can now create the image copy backup of database or datafile into multiple sections backups. This will provide us the benefit to scatter the backup across and also leverage the parallelism option to backup the database/datafile faster.

Let’s see how this works,

Comments are closed.