We talked about it last time. Rman provides backup of full-database backups, table space backups, data file backups, archive log backups, control files, and parameter files. The files that Rman backs up are called backup sets, and Rman backs up only the data blocks that have been used in the process. Rman packages multiple data files together to generate a backup set. The data file and the backup set file are no longer one by one-corresponding relationships. The concept of backup sets is described in more detail in the next section. Ben will tell us another way to back up Rman--mirror copy.
Mirror copy is a clone of a single data file, control file, archive log. The backed up backup file corresponds to the database file one by one. Describes the difference between a backup set and a mirrored copy
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/70/92/wKiom1W5ucCjfybaAAKWm9l0lRQ706.jpg "title=" Backup set and mirror copy. PNG "alt=" Wkiom1w5uccjfybaaakwm9l0lrq706.jpg "/>
Mirror copy can be generated using Rman's backup as Copy command, or it can be generated using operating system commands.
When backing up with the backup as Copy command, the Oracle server session validates the data block in the data file and logs the backup operation to the control file. We know that if you use the operating system command for hot standby, first to execute the Begin backup command in the database, after executing the command, the data file's head will be frozen, during the backup, in order to ensure the validity of the data block, once the data block is modified, then the log file will record the original image of the data block. You do not need to perform a begin backup if you are backing up using Rman's backup as Copy command. Because Rman checks the data block consistency during the backup process, it is not copied to the backup file until the data block is consistent.
Mirror copy has the following characteristics:
Mirror copy can only be written to disk and will take a long time to back up when large files are backed up. However, the time to restore data will be greatly reduced. Because the data file is already on disk, you do not need to restore the data files from other media.
Mirror copy contains all the blocks in the data file, regardless of whether the block is used or not.
Performing a mirrored copy
rman> backup as copy database; starting backup at 2015/07/08 11:53:55using target database control File instead of recovery catalogallocated channel: ora_disk_1channel ora_ disk_1: sid=39 device type=diskchannel ora_disk_1: starting datafile Copyinput datafile file number=00001 name=/u01/app/oracle/oradata/devdb/system01.dbfoutput file name=/u01/app/oracle/fast_recovery_area/devdb/datafile/o1_mf_system_bss7pnh2_.dbf tag= tag20150708t115355 recid=9 stamp=884519670channel ora_disk_1: datafile copy complete, elapsed time: 00:00:35channel ora_disk_1: starting datafile Copyinput datafile file number=00002 name=/u01/app/oracle/oradata/devdb/sysaux01.dbfoutput file name=/u01/app/oracle/fast_recovery_area/devdb/datafile/o1_mf_sysaux_bss7qQqg_.dbf tag=tag20150708t115355 recid=10 stamp=884519692channel ora_disk_1: datafile copy complete, elapsed time: 00:00:25channel ORA_DISK_1: starting datafile copyinput datafile file number=00005 name=/u01/app/oracle/oradata/devdb/ Example01.dbfoutput file name=/u01/app/oracle/fast_recovery_area/devdb/datafile/o1_mf_example_ bss7rk3f_.dbf tag=tag20150708t115355 recid=11 stamp=884519708channel ora_disk_1: Datafile copy complete, elapsed time: 00:00:15channel ora_disk_1: starting datafile copyinput datafile file number=00003 name=/u01/app/oracle/oradata/ Devdb/undotbs01.dbfoutput file name=/u01/app/oracle/fast_recovery_area/devdb/datafile/o1_mf_undotbs1 _bss7s07q_.dbf tag=tag20150708t115355 recid=12 stamp=884519715channel ora_disk_1: Datafile copy complete, elapsed time: 00:00:07channel ora_disk_1: starting datafile copyinput datafile file number=00006 name=/u01/app/oracle/oradata/devdb/idx01.dbfoutput file name=/u01/app/oracle/fast_recovery_area/devdb/datafile/o1_mf_idx_bss7s7gp_.dbf tag=tag20150708t115355 RECID=13 STAMP=884519720channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01channel ora_disk_1: starting datafile copyinput datafile file number=00004 name=/u01/app/oracle/oradata/devdb/users01.dbfoutput file name=/u01/app/oracle/fast_recovery_area/devdb/datafile/o1_mf_users_bss7s8mb_.dbf tag=tag20150708t115355 RECID=14 STAMP=884519720channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01finished backup at 2015/07/08 11:55:21starting control file and spfile autobackup at 2015/07/08 11:55:21piece handle=/u01/app/oracle/fast_recovery_area/devdb/ autobackup/2015_07_08/o1_mf_s_884519721_bss7sbdk_.bkp comment=nonefinished control file And spfile autobackup at 2015/07/08 11:55:22
Backed up all data files in the database (including undo, in fact, Undo is also a data file). However, backup database as copy does not back up the control files and SPFile. The last backup of the control file and the parameter file is because we have configured the control file automatic backup function.
rman> backup as copy tablespace example; starting backup at 2015/07/08 12:26:58using target database control File instead of recovery catalogallocated channel: ora_disk_1channel ora_ disk_1: sid=1 device type=diskchannel ora_disk_1: starting datafile copyinput datafile file number=00005 name=/u01/app/oracle/oradata/devdb/ Example01.dbfoutput file name=/u01/app/oracle/fast_recovery_area/devdb/datafile/o1_mf_example_ bss9nmnv_.dbf tag=tag20150708t122659 recid=15 stamp=884521632channel ora_disk_1: datafile copy complete, elapsed time: 00:00:15finished backup at 2015/ 07/08 12:27:14starting control file and spfile autobackup at 2015/07/ 08 12:27:14piece handle=/u01/app/oracle/fast_recovery_area/devdb/autobackup/2015_07_08/o1_mf_s_884521634_bss9o37t_.bkp comment=nonefinished control file and spfile autobackup at 2015/07/08 12:27:15
rman> backup as copy datafile '/u01/app/oracle/oradata/devdb/example01.dbf '; Starting backup at 2015/07/08 12:28:59using channel ora_disk_1channel ora_ disk_1: starting datafile copyinput datafile file number=00005 name=/u01/ app/oracle/oradata/devdb/example01.dbfoutput file name=/u01/app/oracle/fast_recovery_area/devdb/ Datafile/o1_mf_example_bss9rcv9_.dbf tag=tag20150708t122859 recid=16 stamp=884521750channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15Finished backup at 2015/07/08 12:29:14starting control file and spfile autobackup at 2015/07/08 12:29:15piece handle=/u01/app/oracle/fast_recovery_area/devdb/ autobackup/2015_07_08/o1_mf_s_884521755_bss9rv8v_.bkp comment=nonefinished control file And spfile autobackup at&nbSp;2015/07/08 12:29:16
rman> backup as copy current controlfile; Starting backup at 2015/07/08 12:33:34using channel ora_disk_1channel ora_ disk_1: starting datafile copycopying current control fileoutput file name=/u01/app/oracle/fast_recovery_area/devdb/controlfile/o1_mf_tag20150708t123334_bssb0yj4_.ctl tag= tag20150708t123334 recid=17 stamp=884522014channel ora_disk_1: datafile copy complete, elapsed time: 00:00:01finished backup at 2015/07/08 12:33:35starting control file and spfile autobackup at 2015/07/08 12:33:35piece handle=/u01/app/oracle/fast_recovery_area/devdb/autobackup/2015_07_08/o1_mf_s_884522015_ Bssb0zrf_.bkp comment=nonefinished control file and spfile autobackup at 2015/07/08 12:33:36
rman> backup as copy archivelog all; Starting backup at 2015/07/08 12:34:54current log archivedusing channel ora_disk_1channel ora_disk_1: starting archived log copyinput archived log thread=1 sequence=16 recid=7 stamp=884486041output file name=/u01/app/ oracle/fast_recovery_area/devdb/archivelog/2015_07_08/o1_mf_1_16_bssb3h9w_.arc recid=15 stamp= 884522095channel ora_disk_1: archived log copy complete, elapsed time: 00:00:01channel ORA_DISK_1: starting archived log copyinput archived Log thread=1 sequence=17 recid=8 stamp=884486144output file name=/u01/app/oracle /fast_recovery_area/devdb/archivelog/2015_07_08/o1_mf_1_17_bssb3jdy_.arc recid=16 stamp= 884522096channel ora_disk_1: archived log copy complete, Elapsed time: 00:00:01channel ora_disk_1: starting archived log copyinput archived log thread=1 sequence=18 RECID=9 STAMP=884486148output file Name=/u01/app/oracle/fast_recovery_area/devdb/archivelog/2015_07_08/o1_mf_1_18_bssb3khz_.arc recid=17 stamp=884522097channel ora_disk_1: archived log copy complete, elapsed time: 00:00:01channel ORA_DISK_1: starting archived log copyinput Archived log thread=1 sequence=19 recid=10 stamp=884486151output file name= /u01/app/oracle/fast_recovery_area/devdb/archivelog/2015_07_08/o1_mf_1_19_bssb3ll4_.arc recid=18 Stamp=884522098channel ora_disk_1: archived log copy complete, elapsed time : 00:00:01channel ora_disk_1: starting archived log copyinput archived log thread=1 sequence=20 recid=11 stamp=884486169output file name=/u01/app/oracle/fast_recovery_area/ Devdb/archivelog/2015_07_08/o1_mf_1_20_bssb3mnx_.arc recid=19 stamp=884522099channel ora_disk_1 : archived log copy complete, elapsed time: 00:00:01channel ora_disk_1 : starting archived log copyinput archived log thread=1 sequence=21 recid=12 stamp=884486468output file name=/u01/app/oracle/fast_recovery_area/devdb/ Archivelog/2015_07_08/o1_mf_1_21_bssb3nqm_.arc recid=20 stamp=884522100channel ora_disk_1: archived log copy complete, elapsed time: 00:00:01channel ora_disk_1: starting archived log copyinput archived log thread=1 sequence=22 recid=13 stamp=884486525output file name=/u01/app/oracle/fast_recovery_area/devdb/ Archivelog/2015_07_08/o1_mf_1_22_bssb3otp_.arc recid=21 stamp=884522101channel ora_disk_1: archived log copy Complete, elapsed time: 00:00:01channel ora_disk_1: starting archived log copyinput archived log thread=1 sequence=23 recid=14 stamp=884522094output file name=/u01/app/oracle/fast_recovery_area/devdb/archivelog/2015_07_08/o1_mf_1_23_bssb3py8_.arc recid=22 stamp=884522103channel ora_disk_1: archived log copy complete, elapsed time: 00:00:01Finished backup at 2015/07/08 12:35:03Starting control file and spfile autobackup at 2015/07/08 12:35:04piece handle= /u01/app/oracle/fast_recovery_area/devdb/autobackup/2015_07_08/o1_mf_s_884522104_bssb3r69_.bkp comment= Nonefinished control file and spfile autobackup at 2015/07/08 12:35:05
This article is from the "Ding Dong" blog, please be sure to keep this source http://lqding.blog.51cto.com/9123978/1680129
Oracle Learning Rman (v) Mirror copy