Image Copy Incremental Updates (ICIU): concepts

Image Copy Incremental Updates (ICIU): concepts (I) limits the use of Redo to reduce the recovery time (ii) Principles of creating an Image Copy of a data file, and then using an Incremental backup set to update the Image Copy: merge a level 1 Incremental Backup set into an existing image copy. (3) test ① script [SQL] RMAN> run {2> recover copy of database with tag 'icu1 '; 3> backup 4> incremental level 1 tag 'iciu1' 5> for recover of copy with tag 'iciu1' 6> database plus archivelog delete input; 7 >}wherein, for recover of copy with tag, this tells RMAN that the created Incremental Backup set will be used to copy the image. ② note that this script can be run every day and run every day: i. recover copy command update the image copy of each data file with Level 1 Incremental backup of the previous day the backup command creates a level-1 Incremental backup set. However, if the copy of a level-0 image does not exist, the backup command first creates a level-0 image. Therefore, at any time, you have the following: (1) a maximum of 48 hours of image copying (2) a maximum of 24 hour Incremental Backup sets (3) online and archived logs support full recovery or time point-based recovery using this policy, to perform a full recovery you will not use the recover copy command of the archive log for more than 24 hours to copy all level 1 Incremental Backup sets to the image with the 'icu1' tag. Note that the tag in the two commands is required ③ run [Create 0-level image copy] For The First Time ICIU script: ● recover copy cannot find the updatable image copy. Therefore, RMAN returns "no copy of datafile 1 found to recover" ● the backup command realizes that there is no copy of level 0 image (see return message "no parent backup or copy of datafile 1 found ") therefore, RMAN creates a 0-level image copy for each data file [SQL] RMAN> run {2> recover copy of database with tag 'icu007 '; 3> backup 4> incremental level 1 tag 'iciu007 '5> for recover of copy with tag 'iciu007' 6> database plus archivelog delete input; 7 >}starting recover at 06-APR-13 using channel ORA_DISK_1 no copy of datafile 1 found to recover no copy of datafile 2 found to recover no copy of datafile 3 found to recover no copy of datafile 4 found to recover Finished recover at 06-APR-13 ............ N words are omitted here ...... starting backup at 06-APR-13 using channel ORA_DISK_1 no parent backup or copy of datafile 1 found no parent backup or copy of datafile 3 found no parent backup or copy of datafile 2 found no parent backup or copy datafile 4 found channel ORA_DISK_1: starting datafile copy input datafile fno = 00001 name =/u01/app/oracle/oradata/oracle10/system01.dbf output filename =/u01/app/oracle/flash_recovery_area/ORACLE10G/datafile/empty _. dbf tag = ICIU007 recid = 3 stamp = 812062572 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:46 channel ORA_DISK_1: starting datafile copy input datafile fno = 00003 name =/u01/app/oracle/oradata/oracle10/sysaux01.dbf output filename =/u01/app/oracle/flash_recovery_area/ORACLE10G/datafile/pai_area _. dbf tag = ICIU007 recid = 4 stamp = 812062601 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:27 channel ORA_DISK_1: starting datafile copy input datafile fno = 00002 name =/u01/app/oracle/oradata/oracle10/undotbs01.dbf output filename =/u01/app/oracle/flash_recovery_area/ORACLE10G/datafile/o1_mf_undotbs1_8p06wb6c _. dbf tag = ICIU007 recid = 5 stamp = 812062604 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03 channel ORA_DISK_1: starting datafile copy input datafile fno = 00004 name =/u01/app/oracle/oradata/oracle10/users01.dbf output filename =/u01/app/oracle/flash_recovery_area/ORACLE10G/datafile/pai_area _. dbf tag = ICIU007 recid = 6 stamp = 812062605 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting incremental level 1 datafile backupset channel ORA_DISK_1: specifying datafile (s) in backupset including current control file in backupset ............ ④ run [Create Level 1 Incremental Backup set] The second run ICIU script: ● backup command to create a level 1 Incremental backup ● The recover copy command still does not work because, although the level 0 image copy has been created during the first running, there is still no Level 1 Incremental backup. However ," no copy of datafile 1 found to recover "this message prompts somewhat misleading [SQL] RMAN> run {2> recover copy of database with tag 'icu007 '; 3> backup 4> incremental level 1 tag 'iciu007 '5> for recover of copy with tag 'iciu007' 6> database plus archivelog delete input; 7 >}starting recover at 07-APR-13 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid = 139 devtype = DISK no copy of datafile 1 found to recover no copy of datafile 2 found to recover no copy of datafile 3 found to recover no copy of datafile 4 found to recover Finished recover at 07-APR-13 Starting backup at 07-APR-13 current log archived using channel ORA_DISK_1 channel ORA_DISK_1: starting archive log backupset channel ORA_DISK_1: specifying archive log (s) in backup set input archive log thread = 1 sequence = 11 recid = 9 stamp = 812149977 channel ORA_DISK_1: starting piece 1 at 07-APR-13 channel ORA_DISK_1: finished piece 1 at 07-APR-13 piece handle =/u01/app/oracle/flash_recovery_area/ORACLE10G/backupset/2013_04_07/pai_07 _. bkp tag = ICIU007 comment = NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02 channel ORA_DISK_1: deleting archive log (s) archive log filename =/u01/app/oracle/flash_recovery_area/ORACLE10G/archivelog/2013_04_07/o1_mf_1_11_8p2w6sbt _. arc recid = 9 stamp = 812149977 Finished backup at 07-APR-13 Starting backup at 07-APR-13 using channel ORA_DISK_1 channel ORA_DISK_1: starting incremental level 1 datafile backupset channel ORA_DISK_1: specifying datafile (s) in backupset input datafile fno = 00001 name =/u01/app/oracle/oradata/oracle10/system01.dbf input datafile fno = 00003 name =/u01/app/oracle/oradata/oracle10/sysaux01.dbf input datafile fno = 00002 name =/u01/app/oracle/oradata/oracle10/undotbs01.dbf input datafile fno = 00004 name =/u01/app/oracle/oradata/oracle10/users01.dbf channel ORA_DISK_1: starting piece 1 at 07-APR-13 channel ORA_DISK_1: finished piece 1 at 07-APR-13 piece handle =/u01/app/oracle/flash_recovery_area/ORACLE10G/backupset/2013_04_07/pai_07 _. bkp tag = ICIU007 comment = NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07 channel ORA_DISK_1: starting incremental level 1 datafile backupset channel ORA_DISK_1: specifying datafile (s) in backupset including current control file in backupset ............ ⑤ run the ICIU script for the third time: ● The recover copy command uses the incremental 1 Set backup set created the previous day to copy the data file image ● the backup command creates a new 1 level Incremental backup set [SQL] RMAN> run {2> recover copy database with tag 'icu007 '; 3> backup 4> incremental level 1 tag 'iciu007 '5> for recover of copy with tag 'iciu007' 6> database plus archivelog delete input; 7 >}starting recover at your using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid = 139 devtype = DISK channel ORA_DISK_1: Starting incremental datafile backupset restore channel ORA_DISK_1: specifying datafile copies to recover recovering datafile copy fno = 00001 name =/u01/app/oracle/flash_recovery_area/ORACLE10G/datafile/o1_mf_system_8p06t0nt _. dbf recovering datafile copy fno = 00002 name =/u01/app/oracle/flash_recovery_area/ORACLE10G/datafile/o1_mf_undotbs1_8p06wb6c _. dbf recovering datafile copy fno = 00003 name =/u01/app/oracle/flash_recovery_area/ORACLE10G/datafile/o1_mf_sysaux_8p06vgsb _. dbf recovering datafile copy fno = 00004 name =/u01/app/oracle/flash_recovery_area/ORACLE10G/datafile/o1_mf_users_8p06wffr _. dbf channel ORA_DISK_1: reading from backup piece/u01/app/oracle/flash_recovery_area/ORACLE10G/backupset/2013_04_07/o1_mf_nnnd1_ICIU007_8p2w6y6y _. bkp channel ORA_DISK_1: restored backup piece 1 piece handle =/u01/app/oracle/flash_recovery_area/ORACLE10G/backupset/2013_04_07/partition _. bkp tag = ICIU007 channel ORA_DISK_1: restore complete, elapsed time: 00:00:03 Finished recover at startup Starting backup at present log archived using channel ORA_DISK_1 channel ORA_DISK_1: starting archive log backupset channel ORA_DISK_1: specifying archive log (s) in backup set input archive log thread = 1 sequence = 13 recid = 11 stamp = 812239310 channel ORA_DISK_1: starting piece 1 at 08-APR-13 channel ORA_DISK_1: finished piece 1 at 08-APR-13 piece handle =/u01/app/oracle/flash_recovery_area/ORACLE10G/backupset/2013_04_08/o1_mf_annnn_ICIU007_8p5mgj9t _. bkp tag = ICIU007 comment = NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02 channel ORA_DISK_1: deleting archive log (s) archive log filename =/u01/app/oracle/flash_recovery_area/ORACLE10G/archivelog/2013_04_08/o1_mf_1_13_8p5mggh0 _. arc recid = 11 stamp = 812239310 Finished backup at 08-APR-13 Starting backup at 08-APR-13 using channel ORA_DISK_1 channel ORA_DISK_1: starting incremental level 1 datafile backupset channel ORA_DISK_1: specifying datafile (s) in backupset input datafile fno = 00001 name =/u01/app/oracle/oradata/oracle10/system01.dbf input datafile fno = 00003 name =/u01/app/oracle/oradata/oracle10/sysaux01.dbf input datafile fno = 00002 name =/u01/app/oracle/oradata/oracle10/undotbs01.dbf input datafile fno = 00004 name =/u01/app/oracle/oradata/oracle10/users01.dbf channel ORA_DISK_1: starting piece 1 at 08-APR-13 channel ORA_DISK_1: finished piece 1 at 08-APR-13 piece handle =/u01/app/oracle/flash_recovery_area/ORACLE10G/backupset/2013_04_08/o1_mf_nnnd1_ICIU007_8p5mgofk _. bkp tag = ICIU007 comment = NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08 channel ORA_DISK_1: starting incremental level 1 datafile backupset channel ORA_DISK_1: specifying datafile (s) in backupset including current control file in backupset including current SPFILE in backupset channel ORA_DISK_1: starting piece 1 at 08-APR-13 channel ORA_DISK_1: finished piece 1 at 08-APR-13 piece handle =/u01/app/oracle/flash_recovery_area/ORACLE10G/backupset/2013_04_08/o1_mf_ncsn1_ICIU007_8p5mgskg _. bkp tag = ICIU007 comment = NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 08-APR-13 ..........