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 policy.
I connected to our recovery catalog and issued the SQL syntax to check the last level 0 which was back in :
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); D 0 SBT_TAPE bk_un3s8a6oj_s31459_p1_t948247315 D13641 TAG20170702T020154 2/07/2017 2:06:41 AM
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:
Rman target / catalog
Set dbid=2001628421;
Run {
Allocate channel s1 device type sbt
restore database;
recover database “to_date(‘29/03/2018’,’HH24:mi:ss’)”;
close channel s1
}
channel s1: starting proxy restore
channel s1: specifying datafile(s) for proxy restore
restoring datafile 00001 to /databases/GENCPRD/GENCPRD/system01.dbf
proxy file handle=bk_dGENCPRD_ugosui9d8_s44568_p5_t971580840
restoring datafile 00002 to /databases/GENCPRD/GENCPRD/undotbs01.dbf
proxy file handle=bk_dGENCPRD_ugosui9d8_s44568_p2_t971580840
restoring datafile 00003 to /databases/GENCPRD/GENCPRD/sysaux01.dbf
proxy file handle=bk_dGENCPRD_ugosui9d8_s44568_p4_t971580840
restoring datafile 00004 to /databases/GENCPRD/GENCPRD/users01.dbf
proxy file handle=bk_dGENCPRD_ugosui9d8_s44568_p12_t971580840
restoring datafile 00005 to /databases/GENCPRD/GENCPRD/tools01.dbf
proxy file handle=bk_dGENCPRD_ugosui9d8_s44568_p6_t971580840
restoring datafile 00006 to /databases/GENCPRD/GENCPRD/genuser01.dbf
proxy file handle=bk_dGENCPRD_ugosui9d8_s44568_p7_t971580840
restoring datafile 00007 to /databases/GENCPRD/GENCPRD/genesys_data01.dbf
proxy file handle=bk_dGENCPRD_ugosui9d8_s44568_p1_t971580840
restoring datafile 00008 to /databases/GENCPRD/GENCPRD/genesys_index01.dbf
proxy file handle=bk_dGENCPRD_ugosui9d8_s44568_p8_t971580840
restoring datafile 00009 to /databases/GENCPRD/GENCPRD/genesys_index02.dbf
proxy file handle=bk_dGENCPRD_ugosui9d8_s44568_p9_t971580840
restoring datafile 00010 to /databases/GENCPRD/GENCPRD/genesys_data02.dbf
proxy file handle=bk_dGENCPRD_ugosui9d8_s44568_p3_t971580840
restoring datafile 00011 to /databases/GENCPRD/GENCPRD/genesys_data03.dbf
proxy file handle=bk_dGENCPRD_ugosui9d8_s44568_p10_t971580840
restoring datafile 00012 to /databases/GENCPRD/GENCPRD/genesys_index03.dbf
proxy file handle=bk_dGENCPRD_ugosui9d8_s44568_p11_t971580840
channel s1: proxy copy complete, elapsed time: 00:05:52
Finished restore at 04-APR-18
Starting recover at 04-APR-18
channel s3: starting incremental datafile backupset restore
channel s3: specifying datafile(s) to restore from backup set
destination for restore of datafile 00002: /databases/GENCPRD/GENCPRD/undotbs01.dbf
destination for restore of datafile 00009: /databases/GENCPRD/GENCPRD/genesys_index02.dbf
destination for restore of datafile 00011: /databases/GENCPRD/GENCPRD/genesys_data03.dbf
channel s3: reading from backup piece bk_dGENCPRD_uhfsuktvd_s44591_p1_t971667437
channel s1: starting incremental datafile backupset restore
channel s1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00006: /databases/GENCPRD/GENCPRD/genuser01.dbf
destination for restore of datafile 00008: /databases/GENCPRD/GENCPRD/genesys_index01.dbf
destination for restore of datafile 00010: /databases/GENCPRD/GENCPRD/genesys_data02.dbf
channel s1: reading from backup piece bk_dGENCPRD_uhgsuktvd_s44592_p1_t971667437
channel s2: starting incremental datafile backupset restore
channel s2: specifying datafile(s) to restore from backup set
destination for restore of datafile 00004: /databases/GENCPRD/GENCPRD/users01.dbf
destination for restore of datafile 00007: /databases/GENCPRD/GENCPRD/genesys_data01.dbf
destination for restore of datafile 00012: /databases/GENCPRD/GENCPRD/genesys_index03.dbf
channel s2: reading from backup piece bk_dGENCPRD_uhesuktvd_s44590_p1_t971667437
channel s1: restored backup piece 1
piece handle=bk_dGENCPRD_uhgsuktvd_s44592_p1_t971667437 tag=TAG20180325T033715
channel s1: restore complete, elapsed time: 00:00:35
channel s1: starting incremental datafile backupset restore
channel s1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /databases/GENCPRD/GENCPRD/system01.dbf
destination for restore of datafile 00003: /databases/GENCPRD/GENCPRD/sysaux01.dbf
destination for restore of datafile 00005: /databases/GENCPRD/GENCPRD/tools01.dbf
channel s1: reading from backup piece bk_dGENCPRD_uhhsuktvd_s44593_p1_t971667437
channel s3: restored backup piece 1
piece handle=bk_dGENCPRD_uhfsuktvd_s44591_p1_t971667437 tag=TAG20180325T033715
channel s3: restore complete, elapsed time: 00:00:36
channel s3: starting incremental datafile backupset restore
channel s3: specifying datafile(s) to restore from backup set
destination for restore of datafile 00006: /databases/GENCPRD/GENCPRD/genuser01.dbf
destination for restore of datafile 00008: /databases/GENCPRD/GENCPRD/genesys_index01.dbf
destination for restore of datafile 00010: /databases/GENCPRD/GENCPRD/genesys_data02.dbf
channel s3: reading from backup piece bk_dGENCPRD_uj9suni44_s44649_p1_t971753604
channel s2: restored backup piece 1
piece handle=bk_dGENCPRD_uhesuktvd_s44590_p1_t971667437 tag=TAG20180325T033715
channel s2: restore complete, elapsed time: 00:00:38
channel s2: starting incremental datafile backupset restore
channel s2: specifying datafile(s) to restore from backup set
destination for restore of datafile 00002: /databases/GENCPRD/GENCPRD/undotbs01.dbf
destination for restore of datafile 00009: /databases/GENCPRD/GENCPRD/genesys_index02.dbf
destination for restore of datafile 00011: /databases/GENCPRD/GENCPRD/genesys_data03.dbf
channel s2: reading from backup piece bk_dGENCPRD_uj8suni44_s44648_p1_t971753604
channel s1: restored backup piece 1
piece handle=bk_dGENCPRD_uhhsuktvd_s44593_p1_t971667437 tag=TAG20180325T033715
channel s1: restore complete, elapsed time: 00:00:38
channel s2: restored backup piece 1
piece handle=bk_dGENCPRD_uj8suni44_s44648_p1_t971753604 tag=TAG20180326T032906
channel s2: restore complete, elapsed time: 00:00:35
channel s3: restored backup piece 1
piece handle=bk_dGENCPRD_uj9suni44_s44649_p1_t971753604 tag=TAG20180326T032906
channel s3: restore complete, elapsed time: 00:00:36
channel s3: starting incremental datafile backupset restore
channel s3: specifying datafile(s) to restore from backup set
destination for restore of datafile 00002: /databases/GENCPRD/GENCPRD/undotbs01.dbf
destination for restore of datafile 00009: /databases/GENCPRD/GENCPRD/genesys_index02.dbf
destination for restore of datafile 00011: /databases/GENCPRD/GENCPRD/genesys_data03.dbf
channel s3: reading from backup piece bk_dGENCPRD_ul1suq69m_s44705_p1_t971839798
channel s1: starting incremental datafile backupset restore
channel s1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00004: /databases/GENCPRD/GENCPRD/users01.dbf
destination for restore of datafile 00007: /databases/GENCPRD/GENCPRD/genesys_data01.dbf
destination for restore of datafile 00012: /databases/GENCPRD/GENCPRD/genesys_index03.dbf
channel s1: reading from backup piece bk_dGENCPRD_uj7suni44_s44647_p1_t971753604
channel s2: starting incremental datafile backupset restore
channel s2: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /databases/GENCPRD/GENCPRD/system01.dbf
destination for restore of datafile 00003: /databases/GENCPRD/GENCPRD/sysaux01.dbf
destination for restore of datafile 00005: /databases/GENCPRD/GENCPRD/tools01.dbf
channel s2: reading from backup piece bk_dGENCPRD_ujasuni45_s44650_p1_t971753605
channel s1: restored backup piece 1
piece handle=bk_dGENCPRD_uj7suni44_s44647_p1_t971753604 tag=TAG20180326T032906
channel s1: restore complete, elapsed time: 00:00:45
channel s2: restored backup piece 1
piece handle=bk_dGENCPRD_ujasuni45_s44650_p1_t971753605 tag=TAG20180326T032906
channel s2: restore complete, elapsed time: 00:00:46
channel s3: restored backup piece 1
piece handle=bk_dGENCPRD_ul1suq69m_s44705_p1_t971839798 tag=TAG20180327T032949
channel s3: restore complete, elapsed time: 00:00:46
channel s3: starting incremental datafile backupset restore
channel s3: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /databases/GENCPRD/GENCPRD/system01.dbf
destination for restore of datafile 00003: /databases/GENCPRD/GENCPRD/sysaux01.dbf
destination for restore of datafile 00005: /databases/GENCPRD/GENCPRD/tools01.dbf
channel s3: reading from backup piece bk_dGENCPRD_ul3suq69m_s44707_p1_t971839798
channel s1: starting incremental datafile backupset restore
channel s1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00004: /databases/GENCPRD/GENCPRD/users01.dbf
destination for restore of datafile 00007: /databases/GENCPRD/GENCPRD/genesys_data01.dbf
destination for restore of datafile 00012: /databases/GENCPRD/GENCPRD/genesys_index03.dbf
channel s1: reading from backup piece bk_dGENCPRD_ul0suq69m_s44704_p1_t971839798
channel s2: starting incremental datafile backupset restore
channel s2: specifying datafile(s) to restore from backup set
destination for restore of datafile 00006: /databases/GENCPRD/GENCPRD/genuser01.dbf
destination for restore of datafile 00008: /databases/GENCPRD/GENCPRD/genesys_index01.dbf
destination for restore of datafile 00010: /databases/GENCPRD/GENCPRD/genesys_data02.dbf
channel s2: reading from backup piece bk_dGENCPRD_ul2suq69m_s44706_p1_t971839798
channel s2: restored backup piece 1
piece handle=bk_dGENCPRD_ul2suq69m_s44706_p1_t971839798 tag=TAG20180327T032949
channel s2: restore complete, elapsed time: 00:00:35
channel s2: starting incremental datafile backupset restore
channel s2: specifying datafile(s) to restore from backup set
destination for restore of datafile 00006: /databases/GENCPRD/GENCPRD/genuser01.dbf
destination for restore of datafile 00008: /databases/GENCPRD/GENCPRD/genesys_index01.dbf
destination for restore of datafile 00010: /databases/GENCPRD/GENCPRD/genesys_data02.dbf
channel s2: reading from backup piece bk_dGENCPRD_umrsusqfq_s44763_p1_t971926010
channel s3: restored backup piece 1
piece handle=bk_dGENCPRD_ul3suq69m_s44707_p1_t971839798 tag=TAG20180327T032949
channel s3: restore complete, elapsed time: 00:00:36
channel s3: starting incremental datafile backupset restore
channel s3: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /databases/GENCPRD/GENCPRD/system01.dbf
destination for restore of datafile 00003: /databases/GENCPRD/GENCPRD/sysaux01.dbf
destination for restore of datafile 00005: /databases/GENCPRD/GENCPRD/tools01.dbf
channel s3: reading from backup piece bk_dGENCPRD_umssusqfq_s44764_p1_t971926010
channel s1: restored backup piece 1
piece handle=bk_dGENCPRD_ul0suq69m_s44704_p1_t971839798 tag=TAG20180327T032949
channel s1: restore complete, elapsed time: 00:00:37
channel s1: starting incremental datafile backupset restore
channel s1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00004: /databases/GENCPRD/GENCPRD/users01.dbf
destination for restore of datafile 00007: /databases/GENCPRD/GENCPRD/genesys_data01.dbf
destination for restore of datafile 00012: /databases/GENCPRD/GENCPRD/genesys_index03.dbf
channel s1: reading from backup piece bk_dGENCPRD_umpsusqfp_s44761_p1_t971926009
channel s2: restored backup piece 1
piece handle=bk_dGENCPRD_umrsusqfq_s44763_p1_t971926010 tag=TAG20180328T032253
channel s2: restore complete, elapsed time: 00:00:38
channel s2: starting incremental datafile backupset restore
channel s2: specifying datafile(s) to restore from backup set
destination for restore of datafile 00002: /databases/GENCPRD/GENCPRD/undotbs01.dbf
destination for restore of datafile 00009: /databases/GENCPRD/GENCPRD/genesys_index02.dbf
destination for restore of datafile 00011: /databases/GENCPRD/GENCPRD/genesys_data03.dbf
channel s2: reading from backup piece bk_dGENCPRD_umqsusqfp_s44762_p1_t971926009
channel s3: restored backup piece 1
piece handle=bk_dGENCPRD_umssusqfq_s44764_p1_t971926010 tag=TAG20180328T032253
channel s3: restore complete, elapsed time: 00:00:38
channel s3: starting incremental datafile backupset restore
channel s3: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /databases/GENCPRD/GENCPRD/system01.dbf
destination for restore of datafile 00003: /databases/GENCPRD/GENCPRD/sysaux01.dbf
destination for restore of datafile 00005: /databases/GENCPRD/GENCPRD/tools01.dbf
channel s3: reading from backup piece bk_dGENCPRD_uolsuvfa1_s44821_p1_t972012865
channel s1: restored backup piece 1
piece handle=bk_dGENCPRD_umpsusqfp_s44761_p1_t971926009 tag=TAG20180328T032253
channel s1: restore complete, elapsed time: 00:00:44
channel s1: starting incremental datafile backupset restore
channel s1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00004: /databases/GENCPRD/GENCPRD/users01.dbf
destination for restore of datafile 00007: /databases/GENCPRD/GENCPRD/genesys_data01.dbf
destination for restore of datafile 00012: /databases/GENCPRD/GENCPRD/genesys_index03.dbf
channel s1: reading from backup piece bk_dGENCPRD_uoisuvfa1_s44818_p1_t972012865
channel s2: restored backup piece 1
piece handle=bk_dGENCPRD_umqsusqfp_s44762_p1_t971926009 tag=TAG20180328T032253
channel s2: restore complete, elapsed time: 00:00:42
channel s3: restored backup piece 1
piece handle=bk_dGENCPRD_uolsuvfa1_s44821_p1_t972012865 tag=TAG20180329T033400
channel s3: restore complete, elapsed time: 00:00:42
channel s3: starting incremental datafile backupset restore
channel s3: specifying datafile(s) to restore from backup set
destination for restore of datafile 00002: /databases/GENCPRD/GENCPRD/undotbs01.dbf
destination for restore of datafile 00009: /databases/GENCPRD/GENCPRD/genesys_index02.dbf
destination for restore of datafile 00011: /databases/GENCPRD/GENCPRD/genesys_data03.dbf
channel s3: reading from backup piece bk_dGENCPRD_uojsuvfa1_s44819_p1_t972012865
channel s2: starting incremental datafile backupset restore
channel s2: specifying datafile(s) to restore from backup set
destination for restore of datafile 00006: /databases/GENCPRD/GENCPRD/genuser01.dbf
destination for restore of datafile 00008: /databases/GENCPRD/GENCPRD/genesys_index01.dbf
destination for restore of datafile 00010: /databases/GENCPRD/GENCPRD/genesys_data02.dbf
channel s2: reading from backup piece bk_dGENCPRD_uoksuvfa1_s44820_p1_t972012865
channel s1: restored backup piece 1
piece handle=bk_dGENCPRD_uoisuvfa1_s44818_p1_t972012865 tag=TAG20180329T033400
channel s1: restore complete, elapsed time: 00:00:36
channel s1: starting incremental datafile backupset restore
channel s1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /databases/GENCPRD/GENCPRD/system01.dbf
destination for restore of datafile 00003: /databases/GENCPRD/GENCPRD/sysaux01.dbf
destination for restore of datafile 00005: /databases/GENCPRD/GENCPRD/tools01.dbf
channel s1: reading from backup piece bk_dGENCPRD_uqesv24he_s44878_p1_t972100142
channel s3: restored backup piece 1
piece handle=bk_dGENCPRD_uojsuvfa1_s44819_p1_t972012865 tag=TAG20180329T033400
channel s3: restore complete, elapsed time: 00:00:37
channel s3: starting incremental datafile backupset restore
channel s3: specifying datafile(s) to restore from backup set
destination for restore of datafile 00004: /databases/GENCPRD/GENCPRD/users01.dbf
destination for restore of datafile 00007: /databases/GENCPRD/GENCPRD/genesys_data01.dbf
destination for restore of datafile 00012: /databases/GENCPRD/GENCPRD/genesys_index03.dbf
channel s3: reading from backup piece bk_dGENCPRD_uqbsv24he_s44875_p1_t972100142
channel s2: restored backup piece 1
piece handle=bk_dGENCPRD_uoksuvfa1_s44820_p1_t972012865 tag=TAG20180329T033400
channel s2: restore complete, elapsed time: 00:00:38
channel s2: starting incremental datafile backupset restore
channel s2: specifying datafile(s) to restore from backup set
destination for restore of datafile 00006: /databases/GENCPRD/GENCPRD/genuser01.dbf
destination for restore of datafile 00008: /databases/GENCPRD/GENCPRD/genesys_index01.dbf
destination for restore of datafile 00010: /databases/GENCPRD/GENCPRD/genesys_data02.dbf
channel s2: reading from backup piece bk_dGENCPRD_uqdsv24he_s44877_p1_t972100142
channel s1: restored backup piece 1
piece handle=bk_dGENCPRD_uqesv24he_s44878_p1_t972100142 tag=TAG20180330T034853
channel s1: restore complete, elapsed time: 00:00:39
channel s1: starting incremental datafile backupset restore
channel s1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00002: /databases/GENCPRD/GENCPRD/undotbs01.dbf
destination for restore of datafile 00009: /databases/GENCPRD/GENCPRD/genesys_index02.dbf
destination for restore of datafile 00011: /databases/GENCPRD/GENCPRD/genesys_data03.dbf
channel s1: reading from backup piece bk_dGENCPRD_uqcsv24he_s44876_p1_t972100142
channel s1: restored backup piece 1
piece handle=bk_dGENCPRD_uqcsv24he_s44876_p1_t972100142 tag=TAG20180330T034853
channel s1: restore complete, elapsed time: 00:00:36
channel s2: restored backup piece 1
piece handle=bk_dGENCPRD_uqdsv24he_s44877_p1_t972100142 tag=TAG20180330T034853
channel s2: restore complete, elapsed time: 00:00:39
channel s3: restored backup piece 1
piece handle=bk_dGENCPRD_uqbsv24he_s44875_p1_t972100142 tag=TAG20180330T034853
channel s3: restore complete, elapsed time: 00:00:40
starting media recovery
channel s3: starting archive log restore to default destination
channel s1: starting archive log restore to default destination
channel s2: starting archive log restore to default destination
channel s3: restoring archive log
archive log thread=1 sequence=75301
channel s1: restoring archive log
archive log thread=1 sequence=75297
channel s1: restoring archive log
archive log thread=1 sequence=75298
channel s1: reading from backup piece arch_dGENCPRD_uqgsv25dj_s44880_p1_t972101043
channel s2: restoring archive log
archive log thread=1 sequence=75299
channel s2: restoring archive log
archive log thread=1 sequence=75300
channel s2: reading from backup piece arch_dGENCPRD_uqksv27om_s44884_p1_t972103446
channel s3: restoring archive log
archive log thread=1 sequence=75302
channel s3: reading from backup piece arch_dGENCPRD_uqosv2eqc_s44888_p1_t972110668
channel s1: restored backup piece 1
piece handle=arch_dGENCPRD_uqgsv25dj_s44880_p1_t972101043 tag=TAG20180330T040403
channel s1: restore complete, elapsed time: 00:01:15
archive log filename=/archive/GENCPRD/1_75297_688390917.dbf thread=1 sequence=75297
archive log filename=/archive/GENCPRD/1_75298_688390917.dbf thread=1 sequence=75298
channel s1: starting archive log restore to default destination
channel s2: restored backup piece 1
piece handle=arch_dGENCPRD_uqksv27om_s44884_p1_t972103446 tag=TAG20180330T044405
channel s2: restore complete, elapsed time: 00:01:17
archive log filename=/archive/GENCPRD/1_75299_688390917.dbf thread=1 sequence=75299
archive log filename=/archive/GENCPRD/1_75300_688390917.dbf thread=1 sequence=75300
channel s3: restored backup piece 1
piece handle=arch_dGENCPRD_uqosv2eqc_s44888_p1_t972110668 tag=TAG20180330T064427
channel s3: restore complete, elapsed time: 00:01:18
archive log filename=/archive/GENCPRD/1_75301_688390917.dbf thread=1 sequence=75301
archive log filename=/archive/GENCPRD/1_75302_688390917.dbf thread=1 sequence=75302
channel s1: restoring archive log
archive log thread=1 sequence=75303
channel s1: restoring archive log
archive log thread=1 sequence=75304
channel s1: reading from backup piece arch_dGENCPRD_uqssv2lrh_s44892_p1_t972117873
channel s2: starting archive log restore to default destination
channel s3: starting archive log restore to default destination
channel s2: restoring archive log
archive log thread=1 sequence=75305
channel s3: restoring archive log
archive log thread=1 sequence=75307
channel s3: reading from backup piece arch_dGENCPRD_ur4sv33uc_s44900_p1_t972132300
channel s2: restoring archive log
archive log thread=1 sequence=75306
channel s2: reading from backup piece arch_dGENCPRD_ur0sv2st4_s44896_p1_t972125092
channel s1: restored backup piece 1
piece handle=arch_dGENCPRD_uqssv2lrh_s44892_p1_t972117873 tag=TAG20180330T084432
channel s1: restore complete, elapsed time: 00:00:39
archive log filename=/archive/GENCPRD/1_75303_688390917.dbf thread=1 sequence=75303
archive log filename=/archive/GENCPRD/1_75304_688390917.dbf thread=1 sequence=75304
channel s2: restored backup piece 1
piece handle=arch_dGENCPRD_ur0sv2st4_s44896_p1_t972125092 tag=TAG20180330T104451
channel s2: restore complete, elapsed time: 00:00:37
archive log filename=/archive/GENCPRD/1_75305_688390917.dbf thread=1 sequence=75305
archive log filename=/archive/GENCPRD/1_75306_688390917.dbf thread=1 sequence=75306
channel s3: restored backup piece 1
piece handle=arch_dGENCPRD_ur4sv33uc_s44900_p1_t972132300 tag=TAG20180330T124500
channel s3: restore complete, elapsed time: 00:00:38
archive log filename=/archive/GENCPRD/1_75307_688390917.dbf thread=1 sequence=75307
media recovery complete, elapsed time: 00:00:01
Finished recover at 04-APR-18
released channel: s1
released channel: s2
released channel: s3
SQL>Alter database open resetlogs;
Ok, media recovery complete and open the database successfully.
Trying to check what backup this was coming from I queried the following:
select * from rc_backup_piece where handle ='bk_dGENCPRD_ugosui9d8_s44568_p5_t971580840'; 0 rows returned
What, how is this possible? Looking further I noticed the key here is “Proxy Copy”. So further research I check the table in the target database:
The reason there is no record for the handle as it’s stored in a different table in the target database called V$PROXY_DATAFILE so I queried this table
select * from V$PROXY_DATAFILE where handle='bk_dGENCPRD_ugosui9d8_s44568_p5_t971580840';
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’s 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’t included for my 10.2.0.4 version:
select incremental_level FROM GV$PROXY_DATAFILE where handle='bk_dGENCPRD_ugosui9d8_s44568_p5_t971580840'; 0
This has been resolved in 11g.