RMAN BACKUP SCRIPTS - FOR CHECKING BACKUP DETAILS

DISPLAYS BACKUP DETAILS 

(FULL,INCREMENTAL, DATAFILE & ARCHIVELOG)

select session_key,input_type,status,

to_char(start_time,'yyyy-mm-dd hh24:mi') start_time,
to_char(end_time,'yyyy-mm-dd hh24:mi')   end_time,
output_bytes_display,time_taken_display
from v$rman_backup_job_details
order by session_key asc;
*****************************************************************
DISPLAYS ALL THE BACKUP PIECE  THAT CONTAINS THE BACKUP OF ARCHIVE LOG, DATAFILES IN THE DISK OR SBT TAPE:
selectrecid,set_stamp,sequence#,first_change#,next_change# from  v$backup_redolog;

*****************************************************************

DISPLAYS BACKUP DETAILS OF A PARTICULAR ARCIVELOG:

select br.sequence#, bp.handle from v$backup_piece bp, v$backup_redolog br

where br.set_stamp = bp.set_stamp and br.set_count = bp.set_count

and br.sequence# = 1066;

*****************************************************************

DISPLAYS BACKUP DETAILS OF A PARTICULAR DATAFILE:
select bd.file#, bp.handle 
from v$backup_piece bp, v$backup_datafile bd  
where bd.set_stamp = bp.set_stamp  
and bd.set_count = bp.set_count and bd.file# = 41;

*****************************************************************