Hi,
How can i crosscheck and validate backups from TAPE? Below is the query i m using to list all backuppiece for a particular HOT FULL DB RMAN BACKUP
SELECT MEDIA,HANDLE,TAG,START_TIME,COMPLETION_TIME,ELAPSED_SECONDS FROM GV$BACKUP_PIECE
WHERE HANDLE LIKE 'PROLCR1%'
and to_char(start_time,'dd.mm.yyyy hh24:mi:ss') > to_date('23.05.2012 14:30:00','dd.mm.yyyy hh24:mi:ss')
and to_char(completion_time,'dd.mm.yyyy hh24:mi:ss') < to_date('23.05.2012 15:15:48','dd.mm.yyyy hh24:mi:ss')
order by start_time ;
MEDIA HANDLE TAG START_TIME COMPLETION_TIME ELAPSED_SECONDS
A00722 PROLCR1_cntrl_2pnbn8bd_1_1 PRIMARY_HOT_DB_BK_LEVEL0 05-23-2012 15:14:53 05-23-2012 15:15:44 51
A00722 PROLCR1_al_2onbn89g_1_1 PRIMARY_HOT_DB_BK_LEVEL0 05-23-2012 15:13:54 05-23-2012 15:14:45 51
A00722 PROLCR1_al_2knbn86h_1_1 PRIMARY_HOT_DB_BK_LEVEL0 05-23-2012 15:12:17 05-23-2012 15:14:27 130
A00722 PROLCR1_al_2lnbn86h_1_1 PRIMARY_HOT_DB_BK_LEVEL0 05-23-2012 15:12:17 05-23-2012 15:14:26 129
A00722 PROLCR1_al_2mnbn86h_1_1 PRIMARY_HOT_DB_BK_LEVEL0 05-23-2012 15:12:17 05-23-2012 15:14:10 113
A01108 PROLCR1_al_2gnbn86h_1_1 PRIMARY_HOT_DB_BK_LEVEL0 05-23-2012 15:12:17 05-23-2012 15:14:02 105
A00722 PROLCR1_al_2hnbn86h_1_1 PRIMARY_HOT_DB_BK_LEVEL0 05-23-2012 15:12:17 05-23-2012 15:14:33 136
A00722 PROLCR1_al_2jnbn86h_1_1 PRIMARY_HOT_DB_BK_LEVEL0 05-23-2012 15:12:17 05-23-2012 15:13:56 99
A00722 PROLCR1_al_2inbn86h_1_1 PRIMARY_HOT_DB_BK_LEVEL0 05-23-2012 15:12:17 05-23-2012 15:14:36 139
A01108 PROLCR1_al_2nnbn86h_1_1 PRIMARY_HOT_DB_BK_LEVEL0 05-23-2012 15:12:17 05-23-2012 15:13:43 86
A00791 PROLCR1_df_2fnbn7d5_1_1 PRIMARY_HOT_DB_BK_LEVEL0 05-23-2012 14:58:45 05-23-2012 14:59:25 40
A00722 PROLCR1_df_2enbn7bd_1_1 PRIMARY_HOT_DB_BK_LEVEL0 05-23-2012 14:57:50 05-23-2012 14:58:41 51
A00722 PROLCR1_df_2dnbn78e_1_1 PRIMARY_HOT_DB_BK_LEVEL0 05-23-2012 14:56:14 05-23-2012 14:57:47 93
A00791 PROLCR1_df_2cnbn770_1_1 PRIMARY_HOT_DB_BK_LEVEL0 05-23-2012 14:55:28 05-23-2012 14:58:37 189
A00791 PROLCR1_df_2bnbn76h_1_1 PRIMARY_HOT_DB_BK_LEVEL0 05-23-2012 14:55:13 05-23-2012 15:00:37 324
A00791 PROLCR1_df_2anbn6sm_1_1 PRIMARY_HOT_DB_BK_LEVEL0 05-23-2012 14:49:58 05-23-2012 15:08:42 1,124
A00722 PROLCR1_df_29nbn6la_1_1 PRIMARY_HOT_DB_BK_LEVEL0 05-23-2012 14:46:02 05-23-2012 14:56:12 610
A00722 PROLCR1_df_26nbn5ne_1_1 PRIMARY_HOT_DB_BK_LEVEL0 05-23-2012 14:30:06 05-23-2012 15:12:14 2,528
A00791 PROLCR1_df_22nbn5ne_1_1 PRIMARY_HOT_DB_BK_LEVEL0 05-23-2012 14:30:06 05-23-2012 15:03:10 1,984
A00791 PROLCR1_df_28nbn5ne_1_1 PRIMARY_HOT_DB_BK_LEVEL0 05-23-2012 14:30:06 05-23-2012 15:01:14 1,868
A00791 PROLCR1_df_23nbn5ne_1_1 PRIMARY_HOT_DB_BK_LEVEL0 05-23-2012 14:30:06 05-23-2012 15:00:38 1,832
A00791 PROLCR1_df_24nbn5ne_1_1 PRIMARY_HOT_DB_BK_LEVEL0 05-23-2012 14:30:06 05-23-2012 14:55:22 1,516
A00791 PROLCR1_df_21nbn5ne_1_1 PRIMARY_HOT_DB_BK_LEVEL0 05-23-2012 14:30:06 05-23-2012 14:55:05 1,499
A00722 PROLCR1_df_27nbn5ne_1_1 PRIMARY_HOT_DB_BK_LEVEL0 05-23-2012 14:30:06 05-23-2012 14:45:58 952
A00791 PROLCR1_df_25nbn5ne_1_1 PRIMARY_HOT_DB_BK_LEVEL0 05-23-2012 14:30:06 05-23-2012 14:49:52 1,186