{"id":290,"date":"2018-04-06T14:25:25","date_gmt":"2018-04-06T04:25:25","guid":{"rendered":"http:\/\/www.mrmarkyoung.com\/oracle\/?p=290"},"modified":"2018-06-05T17:08:27","modified_gmt":"2018-06-05T07:08:27","slug":"rman-proxy-backups-and-recovery-using-incremental","status":"publish","type":"post","link":"http:\/\/www.mrmarkyoung.com\/oracle\/2018\/04\/06\/rman-proxy-backups-and-recovery-using-incremental\/","title":{"rendered":"Rman Proxy Backups and Recovery using Incremental"},"content":{"rendered":"

I was asked to check that we have a backup of database prior to decommissioning it and found the following which was interesting.<\/p>\n

As we have implemented a backup strategy at the company I work, I was a little confused since we just introduced a new backup method with Netbackup that now uses an intelligent policy.<\/p>\n

I connected to our recovery catalog and issued the SQL syntax to check the last level 0 which was back in :<\/p>\n

select backup_type, incremental_level, device_type, handle, media, tag, completion_time from rc_backup_piece where db_id=2001628421 and incremental_level=0 and start_time=(select max(start_time) from rc_backup_piece where db_id=2001628421 and incremental_level=0);\r\n\r\nD\t0\tSBT_TAPE\tbk_un3s8a6oj_s31459_p1_t948247315\tD13641\tTAG20170702T020154\t2\/07\/2017 2:06:41 AM\r\n<\/pre>\n
I then found an old server and attempted to restore the database to see if there were any issues. This was the output from the restore:<\/p>\n
Rman target \/ catalog\r\nSet dbid=2001628421;\r\n\r\nRun {\r\nAllocate channel s1 device type sbt\r\nrestore database;\r\nrecover database \u201cto_date(\u201829\/03\/2018\u2019,\u2019HH24:mi:ss\u2019)\u201d;\r\nclose channel s1\r\n}\r\n\r\n\r\nchannel s1: starting proxy restore\r\nchannel s1: specifying datafile(s) for proxy restore\r\nrestoring datafile 00001 to \/databases\/GENCPRD\/GENCPRD\/system01.dbf\r\nproxy file handle=bk_dGENCPRD_ugosui9d8_s44568_p5_t971580840\r\nrestoring datafile 00002 to \/databases\/GENCPRD\/GENCPRD\/undotbs01.dbf\r\nproxy file handle=bk_dGENCPRD_ugosui9d8_s44568_p2_t971580840\r\nrestoring datafile 00003 to \/databases\/GENCPRD\/GENCPRD\/sysaux01.dbf\r\nproxy file handle=bk_dGENCPRD_ugosui9d8_s44568_p4_t971580840\r\nrestoring datafile 00004 to \/databases\/GENCPRD\/GENCPRD\/users01.dbf\r\nproxy file handle=bk_dGENCPRD_ugosui9d8_s44568_p12_t971580840\r\nrestoring datafile 00005 to \/databases\/GENCPRD\/GENCPRD\/tools01.dbf\r\nproxy file handle=bk_dGENCPRD_ugosui9d8_s44568_p6_t971580840\r\nrestoring datafile 00006 to \/databases\/GENCPRD\/GENCPRD\/genuser01.dbf\r\nproxy file handle=bk_dGENCPRD_ugosui9d8_s44568_p7_t971580840\r\nrestoring datafile 00007 to \/databases\/GENCPRD\/GENCPRD\/genesys_data01.dbf\r\nproxy file handle=bk_dGENCPRD_ugosui9d8_s44568_p1_t971580840\r\nrestoring datafile 00008 to \/databases\/GENCPRD\/GENCPRD\/genesys_index01.dbf\r\nproxy file handle=bk_dGENCPRD_ugosui9d8_s44568_p8_t971580840\r\nrestoring datafile 00009 to \/databases\/GENCPRD\/GENCPRD\/genesys_index02.dbf\r\nproxy file handle=bk_dGENCPRD_ugosui9d8_s44568_p9_t971580840\r\nrestoring datafile 00010 to \/databases\/GENCPRD\/GENCPRD\/genesys_data02.dbf\r\nproxy file handle=bk_dGENCPRD_ugosui9d8_s44568_p3_t971580840\r\nrestoring datafile 00011 to \/databases\/GENCPRD\/GENCPRD\/genesys_data03.dbf\r\nproxy file handle=bk_dGENCPRD_ugosui9d8_s44568_p10_t971580840\r\nrestoring datafile 00012 to \/databases\/GENCPRD\/GENCPRD\/genesys_index03.dbf\r\nproxy file handle=bk_dGENCPRD_ugosui9d8_s44568_p11_t971580840\r\nchannel s1: proxy copy complete, elapsed time: 00:05:52\r\nFinished restore at 04-APR-18\r\n\r\nStarting recover at 04-APR-18\r\nchannel s3: starting incremental datafile backupset restore\r\nchannel s3: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00002: \/databases\/GENCPRD\/GENCPRD\/undotbs01.dbf\r\ndestination for restore of datafile 00009: \/databases\/GENCPRD\/GENCPRD\/genesys_index02.dbf\r\ndestination for restore of datafile 00011: \/databases\/GENCPRD\/GENCPRD\/genesys_data03.dbf\r\nchannel s3: reading from backup piece bk_dGENCPRD_uhfsuktvd_s44591_p1_t971667437\r\nchannel s1: starting incremental datafile backupset restore\r\nchannel s1: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00006: \/databases\/GENCPRD\/GENCPRD\/genuser01.dbf\r\ndestination for restore of datafile 00008: \/databases\/GENCPRD\/GENCPRD\/genesys_index01.dbf\r\ndestination for restore of datafile 00010: \/databases\/GENCPRD\/GENCPRD\/genesys_data02.dbf\r\nchannel s1: reading from backup piece bk_dGENCPRD_uhgsuktvd_s44592_p1_t971667437\r\nchannel s2: starting incremental datafile backupset restore\r\nchannel s2: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00004: \/databases\/GENCPRD\/GENCPRD\/users01.dbf\r\ndestination for restore of datafile 00007: \/databases\/GENCPRD\/GENCPRD\/genesys_data01.dbf\r\ndestination for restore of datafile 00012: \/databases\/GENCPRD\/GENCPRD\/genesys_index03.dbf\r\nchannel s2: reading from backup piece bk_dGENCPRD_uhesuktvd_s44590_p1_t971667437\r\nchannel s1: restored backup piece 1\r\npiece handle=bk_dGENCPRD_uhgsuktvd_s44592_p1_t971667437 tag=TAG20180325T033715\r\nchannel s1: restore complete, elapsed time: 00:00:35\r\nchannel s1: starting incremental datafile backupset restore\r\nchannel s1: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00001: \/databases\/GENCPRD\/GENCPRD\/system01.dbf\r\ndestination for restore of datafile 00003: \/databases\/GENCPRD\/GENCPRD\/sysaux01.dbf\r\ndestination for restore of datafile 00005: \/databases\/GENCPRD\/GENCPRD\/tools01.dbf\r\nchannel s1: reading from backup piece bk_dGENCPRD_uhhsuktvd_s44593_p1_t971667437\r\nchannel s3: restored backup piece 1\r\npiece handle=bk_dGENCPRD_uhfsuktvd_s44591_p1_t971667437 tag=TAG20180325T033715\r\nchannel s3: restore complete, elapsed time: 00:00:36\r\nchannel s3: starting incremental datafile backupset restore\r\nchannel s3: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00006: \/databases\/GENCPRD\/GENCPRD\/genuser01.dbf\r\ndestination for restore of datafile 00008: \/databases\/GENCPRD\/GENCPRD\/genesys_index01.dbf\r\ndestination for restore of datafile 00010: \/databases\/GENCPRD\/GENCPRD\/genesys_data02.dbf\r\nchannel s3: reading from backup piece bk_dGENCPRD_uj9suni44_s44649_p1_t971753604\r\nchannel s2: restored backup piece 1\r\npiece handle=bk_dGENCPRD_uhesuktvd_s44590_p1_t971667437 tag=TAG20180325T033715\r\nchannel s2: restore complete, elapsed time: 00:00:38\r\nchannel s2: starting incremental datafile backupset restore\r\nchannel s2: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00002: \/databases\/GENCPRD\/GENCPRD\/undotbs01.dbf\r\ndestination for restore of datafile 00009: \/databases\/GENCPRD\/GENCPRD\/genesys_index02.dbf\r\ndestination for restore of datafile 00011: \/databases\/GENCPRD\/GENCPRD\/genesys_data03.dbf\r\nchannel s2: reading from backup piece bk_dGENCPRD_uj8suni44_s44648_p1_t971753604\r\nchannel s1: restored backup piece 1\r\npiece handle=bk_dGENCPRD_uhhsuktvd_s44593_p1_t971667437 tag=TAG20180325T033715\r\nchannel s1: restore complete, elapsed time: 00:00:38\r\nchannel s2: restored backup piece 1\r\npiece handle=bk_dGENCPRD_uj8suni44_s44648_p1_t971753604 tag=TAG20180326T032906\r\nchannel s2: restore complete, elapsed time: 00:00:35\r\nchannel s3: restored backup piece 1\r\npiece handle=bk_dGENCPRD_uj9suni44_s44649_p1_t971753604 tag=TAG20180326T032906\r\nchannel s3: restore complete, elapsed time: 00:00:36\r\nchannel s3: starting incremental datafile backupset restore\r\nchannel s3: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00002: \/databases\/GENCPRD\/GENCPRD\/undotbs01.dbf\r\ndestination for restore of datafile 00009: \/databases\/GENCPRD\/GENCPRD\/genesys_index02.dbf\r\ndestination for restore of datafile 00011: \/databases\/GENCPRD\/GENCPRD\/genesys_data03.dbf\r\nchannel s3: reading from backup piece bk_dGENCPRD_ul1suq69m_s44705_p1_t971839798\r\nchannel s1: starting incremental datafile backupset restore\r\nchannel s1: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00004: \/databases\/GENCPRD\/GENCPRD\/users01.dbf\r\ndestination for restore of datafile 00007: \/databases\/GENCPRD\/GENCPRD\/genesys_data01.dbf\r\ndestination for restore of datafile 00012: \/databases\/GENCPRD\/GENCPRD\/genesys_index03.dbf\r\nchannel s1: reading from backup piece bk_dGENCPRD_uj7suni44_s44647_p1_t971753604\r\nchannel s2: starting incremental datafile backupset restore\r\nchannel s2: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00001: \/databases\/GENCPRD\/GENCPRD\/system01.dbf\r\ndestination for restore of datafile 00003: \/databases\/GENCPRD\/GENCPRD\/sysaux01.dbf\r\ndestination for restore of datafile 00005: \/databases\/GENCPRD\/GENCPRD\/tools01.dbf\r\nchannel s2: reading from backup piece bk_dGENCPRD_ujasuni45_s44650_p1_t971753605\r\nchannel s1: restored backup piece 1\r\npiece handle=bk_dGENCPRD_uj7suni44_s44647_p1_t971753604 tag=TAG20180326T032906\r\nchannel s1: restore complete, elapsed time: 00:00:45\r\nchannel s2: restored backup piece 1\r\npiece handle=bk_dGENCPRD_ujasuni45_s44650_p1_t971753605 tag=TAG20180326T032906\r\nchannel s2: restore complete, elapsed time: 00:00:46\r\nchannel s3: restored backup piece 1\r\npiece handle=bk_dGENCPRD_ul1suq69m_s44705_p1_t971839798 tag=TAG20180327T032949\r\nchannel s3: restore complete, elapsed time: 00:00:46\r\nchannel s3: starting incremental datafile backupset restore\r\nchannel s3: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00001: \/databases\/GENCPRD\/GENCPRD\/system01.dbf\r\ndestination for restore of datafile 00003: \/databases\/GENCPRD\/GENCPRD\/sysaux01.dbf\r\ndestination for restore of datafile 00005: \/databases\/GENCPRD\/GENCPRD\/tools01.dbf\r\nchannel s3: reading from backup piece bk_dGENCPRD_ul3suq69m_s44707_p1_t971839798\r\nchannel s1: starting incremental datafile backupset restore\r\nchannel s1: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00004: \/databases\/GENCPRD\/GENCPRD\/users01.dbf\r\ndestination for restore of datafile 00007: \/databases\/GENCPRD\/GENCPRD\/genesys_data01.dbf\r\ndestination for restore of datafile 00012: \/databases\/GENCPRD\/GENCPRD\/genesys_index03.dbf\r\nchannel s1: reading from backup piece bk_dGENCPRD_ul0suq69m_s44704_p1_t971839798\r\nchannel s2: starting incremental datafile backupset restore\r\nchannel s2: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00006: \/databases\/GENCPRD\/GENCPRD\/genuser01.dbf\r\ndestination for restore of datafile 00008: \/databases\/GENCPRD\/GENCPRD\/genesys_index01.dbf\r\ndestination for restore of datafile 00010: \/databases\/GENCPRD\/GENCPRD\/genesys_data02.dbf\r\nchannel s2: reading from backup piece bk_dGENCPRD_ul2suq69m_s44706_p1_t971839798\r\nchannel s2: restored backup piece 1\r\npiece handle=bk_dGENCPRD_ul2suq69m_s44706_p1_t971839798 tag=TAG20180327T032949\r\nchannel s2: restore complete, elapsed time: 00:00:35\r\nchannel s2: starting incremental datafile backupset restore\r\nchannel s2: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00006: \/databases\/GENCPRD\/GENCPRD\/genuser01.dbf\r\ndestination for restore of datafile 00008: \/databases\/GENCPRD\/GENCPRD\/genesys_index01.dbf\r\ndestination for restore of datafile 00010: \/databases\/GENCPRD\/GENCPRD\/genesys_data02.dbf\r\nchannel s2: reading from backup piece bk_dGENCPRD_umrsusqfq_s44763_p1_t971926010\r\nchannel s3: restored backup piece 1\r\npiece handle=bk_dGENCPRD_ul3suq69m_s44707_p1_t971839798 tag=TAG20180327T032949\r\nchannel s3: restore complete, elapsed time: 00:00:36\r\nchannel s3: starting incremental datafile backupset restore\r\nchannel s3: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00001: \/databases\/GENCPRD\/GENCPRD\/system01.dbf\r\ndestination for restore of datafile 00003: \/databases\/GENCPRD\/GENCPRD\/sysaux01.dbf\r\ndestination for restore of datafile 00005: \/databases\/GENCPRD\/GENCPRD\/tools01.dbf\r\nchannel s3: reading from backup piece bk_dGENCPRD_umssusqfq_s44764_p1_t971926010\r\nchannel s1: restored backup piece 1\r\npiece handle=bk_dGENCPRD_ul0suq69m_s44704_p1_t971839798 tag=TAG20180327T032949\r\nchannel s1: restore complete, elapsed time: 00:00:37\r\nchannel s1: starting incremental datafile backupset restore\r\nchannel s1: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00004: \/databases\/GENCPRD\/GENCPRD\/users01.dbf\r\ndestination for restore of datafile 00007: \/databases\/GENCPRD\/GENCPRD\/genesys_data01.dbf\r\ndestination for restore of datafile 00012: \/databases\/GENCPRD\/GENCPRD\/genesys_index03.dbf\r\nchannel s1: reading from backup piece bk_dGENCPRD_umpsusqfp_s44761_p1_t971926009\r\nchannel s2: restored backup piece 1\r\npiece handle=bk_dGENCPRD_umrsusqfq_s44763_p1_t971926010 tag=TAG20180328T032253\r\nchannel s2: restore complete, elapsed time: 00:00:38\r\nchannel s2: starting incremental datafile backupset restore\r\nchannel s2: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00002: \/databases\/GENCPRD\/GENCPRD\/undotbs01.dbf\r\ndestination for restore of datafile 00009: \/databases\/GENCPRD\/GENCPRD\/genesys_index02.dbf\r\ndestination for restore of datafile 00011: \/databases\/GENCPRD\/GENCPRD\/genesys_data03.dbf\r\nchannel s2: reading from backup piece bk_dGENCPRD_umqsusqfp_s44762_p1_t971926009\r\nchannel s3: restored backup piece 1\r\npiece handle=bk_dGENCPRD_umssusqfq_s44764_p1_t971926010 tag=TAG20180328T032253\r\nchannel s3: restore complete, elapsed time: 00:00:38\r\nchannel s3: starting incremental datafile backupset restore\r\nchannel s3: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00001: \/databases\/GENCPRD\/GENCPRD\/system01.dbf\r\ndestination for restore of datafile 00003: \/databases\/GENCPRD\/GENCPRD\/sysaux01.dbf\r\ndestination for restore of datafile 00005: \/databases\/GENCPRD\/GENCPRD\/tools01.dbf\r\nchannel s3: reading from backup piece bk_dGENCPRD_uolsuvfa1_s44821_p1_t972012865\r\nchannel s1: restored backup piece 1\r\npiece handle=bk_dGENCPRD_umpsusqfp_s44761_p1_t971926009 tag=TAG20180328T032253\r\nchannel s1: restore complete, elapsed time: 00:00:44\r\nchannel s1: starting incremental datafile backupset restore\r\nchannel s1: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00004: \/databases\/GENCPRD\/GENCPRD\/users01.dbf\r\ndestination for restore of datafile 00007: \/databases\/GENCPRD\/GENCPRD\/genesys_data01.dbf\r\ndestination for restore of datafile 00012: \/databases\/GENCPRD\/GENCPRD\/genesys_index03.dbf\r\nchannel s1: reading from backup piece bk_dGENCPRD_uoisuvfa1_s44818_p1_t972012865\r\nchannel s2: restored backup piece 1\r\npiece handle=bk_dGENCPRD_umqsusqfp_s44762_p1_t971926009 tag=TAG20180328T032253\r\nchannel s2: restore complete, elapsed time: 00:00:42\r\nchannel s3: restored backup piece 1\r\npiece handle=bk_dGENCPRD_uolsuvfa1_s44821_p1_t972012865 tag=TAG20180329T033400\r\nchannel s3: restore complete, elapsed time: 00:00:42\r\nchannel s3: starting incremental datafile backupset restore\r\nchannel s3: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00002: \/databases\/GENCPRD\/GENCPRD\/undotbs01.dbf\r\ndestination for restore of datafile 00009: \/databases\/GENCPRD\/GENCPRD\/genesys_index02.dbf\r\ndestination for restore of datafile 00011: \/databases\/GENCPRD\/GENCPRD\/genesys_data03.dbf\r\nchannel s3: reading from backup piece bk_dGENCPRD_uojsuvfa1_s44819_p1_t972012865\r\nchannel s2: starting incremental datafile backupset restore\r\nchannel s2: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00006: \/databases\/GENCPRD\/GENCPRD\/genuser01.dbf\r\ndestination for restore of datafile 00008: \/databases\/GENCPRD\/GENCPRD\/genesys_index01.dbf\r\ndestination for restore of datafile 00010: \/databases\/GENCPRD\/GENCPRD\/genesys_data02.dbf\r\nchannel s2: reading from backup piece bk_dGENCPRD_uoksuvfa1_s44820_p1_t972012865\r\nchannel s1: restored backup piece 1\r\npiece handle=bk_dGENCPRD_uoisuvfa1_s44818_p1_t972012865 tag=TAG20180329T033400\r\nchannel s1: restore complete, elapsed time: 00:00:36\r\nchannel s1: starting incremental datafile backupset restore\r\nchannel s1: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00001: \/databases\/GENCPRD\/GENCPRD\/system01.dbf\r\ndestination for restore of datafile 00003: \/databases\/GENCPRD\/GENCPRD\/sysaux01.dbf\r\ndestination for restore of datafile 00005: \/databases\/GENCPRD\/GENCPRD\/tools01.dbf\r\nchannel s1: reading from backup piece bk_dGENCPRD_uqesv24he_s44878_p1_t972100142\r\nchannel s3: restored backup piece 1\r\npiece handle=bk_dGENCPRD_uojsuvfa1_s44819_p1_t972012865 tag=TAG20180329T033400\r\nchannel s3: restore complete, elapsed time: 00:00:37\r\nchannel s3: starting incremental datafile backupset restore\r\nchannel s3: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00004: \/databases\/GENCPRD\/GENCPRD\/users01.dbf\r\ndestination for restore of datafile 00007: \/databases\/GENCPRD\/GENCPRD\/genesys_data01.dbf\r\ndestination for restore of datafile 00012: \/databases\/GENCPRD\/GENCPRD\/genesys_index03.dbf\r\nchannel s3: reading from backup piece bk_dGENCPRD_uqbsv24he_s44875_p1_t972100142\r\nchannel s2: restored backup piece 1\r\npiece handle=bk_dGENCPRD_uoksuvfa1_s44820_p1_t972012865 tag=TAG20180329T033400\r\nchannel s2: restore complete, elapsed time: 00:00:38\r\nchannel s2: starting incremental datafile backupset restore\r\nchannel s2: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00006: \/databases\/GENCPRD\/GENCPRD\/genuser01.dbf\r\ndestination for restore of datafile 00008: \/databases\/GENCPRD\/GENCPRD\/genesys_index01.dbf\r\ndestination for restore of datafile 00010: \/databases\/GENCPRD\/GENCPRD\/genesys_data02.dbf\r\nchannel s2: reading from backup piece bk_dGENCPRD_uqdsv24he_s44877_p1_t972100142\r\nchannel s1: restored backup piece 1\r\npiece handle=bk_dGENCPRD_uqesv24he_s44878_p1_t972100142 tag=TAG20180330T034853\r\nchannel s1: restore complete, elapsed time: 00:00:39\r\nchannel s1: starting incremental datafile backupset restore\r\nchannel s1: specifying datafile(s) to restore from backup set\r\ndestination for restore of datafile 00002: \/databases\/GENCPRD\/GENCPRD\/undotbs01.dbf\r\ndestination for restore of datafile 00009: \/databases\/GENCPRD\/GENCPRD\/genesys_index02.dbf\r\ndestination for restore of datafile 00011: \/databases\/GENCPRD\/GENCPRD\/genesys_data03.dbf\r\nchannel s1: reading from backup piece bk_dGENCPRD_uqcsv24he_s44876_p1_t972100142\r\nchannel s1: restored backup piece 1\r\npiece handle=bk_dGENCPRD_uqcsv24he_s44876_p1_t972100142 tag=TAG20180330T034853\r\nchannel s1: restore complete, elapsed time: 00:00:36\r\nchannel s2: restored backup piece 1\r\npiece handle=bk_dGENCPRD_uqdsv24he_s44877_p1_t972100142 tag=TAG20180330T034853\r\nchannel s2: restore complete, elapsed time: 00:00:39\r\nchannel s3: restored backup piece 1\r\npiece handle=bk_dGENCPRD_uqbsv24he_s44875_p1_t972100142 tag=TAG20180330T034853\r\nchannel s3: restore complete, elapsed time: 00:00:40\r\n\r\nstarting media recovery\r\n\r\nchannel s3: starting archive log restore to default destination\r\nchannel s1: starting archive log restore to default destination\r\nchannel s2: starting archive log restore to default destination\r\nchannel s3: restoring archive log\r\narchive log thread=1 sequence=75301\r\nchannel s1: restoring archive log\r\narchive log thread=1 sequence=75297\r\nchannel s1: restoring archive log\r\narchive log thread=1 sequence=75298\r\nchannel s1: reading from backup piece arch_dGENCPRD_uqgsv25dj_s44880_p1_t972101043\r\nchannel s2: restoring archive log\r\narchive log thread=1 sequence=75299\r\nchannel s2: restoring archive log\r\narchive log thread=1 sequence=75300\r\nchannel s2: reading from backup piece arch_dGENCPRD_uqksv27om_s44884_p1_t972103446\r\nchannel s3: restoring archive log\r\narchive log thread=1 sequence=75302\r\nchannel s3: reading from backup piece arch_dGENCPRD_uqosv2eqc_s44888_p1_t972110668\r\nchannel s1: restored backup piece 1\r\npiece handle=arch_dGENCPRD_uqgsv25dj_s44880_p1_t972101043 tag=TAG20180330T040403\r\nchannel s1: restore complete, elapsed time: 00:01:15\r\narchive log filename=\/archive\/GENCPRD\/1_75297_688390917.dbf thread=1 sequence=75297\r\narchive log filename=\/archive\/GENCPRD\/1_75298_688390917.dbf thread=1 sequence=75298\r\nchannel s1: starting archive log restore to default destination\r\nchannel s2: restored backup piece 1\r\npiece handle=arch_dGENCPRD_uqksv27om_s44884_p1_t972103446 tag=TAG20180330T044405\r\nchannel s2: restore complete, elapsed time: 00:01:17\r\narchive log filename=\/archive\/GENCPRD\/1_75299_688390917.dbf thread=1 sequence=75299\r\narchive log filename=\/archive\/GENCPRD\/1_75300_688390917.dbf thread=1 sequence=75300\r\nchannel s3: restored backup piece 1\r\npiece handle=arch_dGENCPRD_uqosv2eqc_s44888_p1_t972110668 tag=TAG20180330T064427\r\nchannel s3: restore complete, elapsed time: 00:01:18\r\narchive log filename=\/archive\/GENCPRD\/1_75301_688390917.dbf thread=1 sequence=75301\r\narchive log filename=\/archive\/GENCPRD\/1_75302_688390917.dbf thread=1 sequence=75302\r\nchannel s1: restoring archive log\r\narchive log thread=1 sequence=75303\r\nchannel s1: restoring archive log\r\narchive log thread=1 sequence=75304\r\nchannel s1: reading from backup piece arch_dGENCPRD_uqssv2lrh_s44892_p1_t972117873\r\nchannel s2: starting archive log restore to default destination\r\nchannel s3: starting archive log restore to default destination\r\nchannel s2: restoring archive log\r\narchive log thread=1 sequence=75305\r\nchannel s3: restoring archive log\r\narchive log thread=1 sequence=75307\r\nchannel s3: reading from backup piece arch_dGENCPRD_ur4sv33uc_s44900_p1_t972132300\r\nchannel s2: restoring archive log\r\narchive log thread=1 sequence=75306\r\nchannel s2: reading from backup piece arch_dGENCPRD_ur0sv2st4_s44896_p1_t972125092\r\nchannel s1: restored backup piece 1\r\npiece handle=arch_dGENCPRD_uqssv2lrh_s44892_p1_t972117873 tag=TAG20180330T084432\r\nchannel s1: restore complete, elapsed time: 00:00:39\r\narchive log filename=\/archive\/GENCPRD\/1_75303_688390917.dbf thread=1 sequence=75303\r\narchive log filename=\/archive\/GENCPRD\/1_75304_688390917.dbf thread=1 sequence=75304\r\nchannel s2: restored backup piece 1\r\npiece handle=arch_dGENCPRD_ur0sv2st4_s44896_p1_t972125092 tag=TAG20180330T104451\r\nchannel s2: restore complete, elapsed time: 00:00:37\r\narchive log filename=\/archive\/GENCPRD\/1_75305_688390917.dbf thread=1 sequence=75305\r\narchive log filename=\/archive\/GENCPRD\/1_75306_688390917.dbf thread=1 sequence=75306\r\nchannel s3: restored backup piece 1\r\npiece handle=arch_dGENCPRD_ur4sv33uc_s44900_p1_t972132300 tag=TAG20180330T124500\r\nchannel s3: restore complete, elapsed time: 00:00:38\r\narchive log filename=\/archive\/GENCPRD\/1_75307_688390917.dbf thread=1 sequence=75307\r\nmedia recovery complete, elapsed time: 00:00:01\r\nFinished recover at 04-APR-18\r\nreleased channel: s1\r\nreleased channel: s2\r\nreleased channel: s3\r\n\r\nSQL&gt;Alter database open resetlogs;\r\n<\/pre>\n
Ok, media recovery complete and open the database successfully.<\/p>\n
Trying to check what backup this was coming from I queried the following:<\/p>\n
select * from rc_backup_piece where handle ='bk_dGENCPRD_ugosui9d8_s44568_p5_t971580840';\r\n0 rows returned\r\n<\/pre>\n
What, how is this possible? Looking further I noticed the key here is \u201cProxy Copy\u201d. So further research I check the table in the target database:
\nThe reason there is no record for the handle as it\u2019s stored in a different table in the target database called V$PROXY_DATAFILE so I queried this table<\/p>\n
select * from V$PROXY_DATAFILE where handle='bk_dGENCPRD_ugosui9d8_s44568_p5_t971580840';<\/pre>\n
However I could not find if this was a full copy, incremental 1 or an incremental 0 (by Oracle law, this should be a level 0 since it\u2019s applying subsequent level 1s). The view does not report on this, however after looking at the view itself, I noticed there is a column which wasn\u2019t included for my 10.2.0.4 version:<\/p>\n
select incremental_level FROM GV$PROXY_DATAFILE where handle='bk_dGENCPRD_ugosui9d8_s44568_p5_t971580840';\r\n0<\/pre>\n
This has been resolved in 11g.<\/p>\n","protected":false},"excerpt":{"rendered":"
I was asked to check that we have a backup of database prior to decommissioning it and found the following which was interesting. As we have implemented a backup strategy at the company I work, I was a little confused since we just introduced a new backup method with Netbackup that now uses an intelligent … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[9],"class_list":["post-290","post","type-post","status-publish","format-standard","hentry","category-oracle-database","tag-rman"],"_links":{"self":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/290","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/comments?post=290"}],"version-history":[{"count":1,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/290\/revisions"}],"predecessor-version":[{"id":291,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/290\/revisions\/291"}],"wp:attachment":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/media?parent=290"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/categories?post=290"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/tags?post=290"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}