--Backup RMAN vs01 - agendamento: domingo(full) - quarta(increm) - sexta(dif) (iniício: 18h)
SELECT  'vs01',a.command_id, a.start_time, a.end_time, a.output_device_type, a.status, a.input_type, 
        round(a.compression_ratio,2) as compression_ratio, a.input_bytes_display, a.output_bytes_display, a.time_taken_display
FROM V$RMAN_BACKUP_JOB_DETAILS a order by start_time desc;

--Backup RMAN vs03 - agendamento: sábado(full) - terça(increm) (inicío: 19h)
SELECT  'vs03',a.command_id, a.start_time, a.end_time, a.output_device_type, a.status, a.input_type, 
        round(a.compression_ratio,2) as compression_ratio, a.input_bytes_display, a.output_bytes_display, a.time_taken_display
FROM V$RMAN_BACKUP_JOB_DETAILS@admin_vs03 a order by start_time desc;

--Backup RMAN vs05 - agendamento: sábado(full) - terça(increm) (inicío: 22h)
SELECT  'vs05',a.command_id, a.start_time, a.end_time, a.output_device_type, a.status, a.input_type, 
        round(a.compression_ratio,2) as compression_ratio, a.input_bytes_display, a.output_bytes_display, a.time_taken_display
FROM V$RMAN_BACKUP_JOB_DETAILS@admin_vs05 a order by start_time desc;

--Backup RMAN vs07 - agendamento: sábado(full) - terça(increm) (inicío: 22h)
--SELECT  'vs11',a.command_id, a.start_time, a.end_time, a.output_device_type, a.status, a.input_type, 
--        round(a.compression_ratio,2) as compression_ratio, a.input_bytes_display, a.output_bytes_display, a.time_taken_display
--FROM V$RMAN_BACKUP_JOB_DETAILS@admin_vs07 a order by start_time desc;

--Backup RMAN vs11 - agendamento: sábado(full) - terça(increm) (inicío: 22h)
SELECT  'vs11',a.command_id, a.start_time, a.end_time, a.output_device_type, a.status, a.input_type, 
        round(a.compression_ratio,2) as compression_ratio, a.input_bytes_display, a.output_bytes_display, a.time_taken_display
FROM V$RMAN_BACKUP_JOB_DETAILS@admin_vs11 a order by start_time desc;

--Backup RMAN vs15 - agendamento: sábado(full) - terça(increm) (inicío: 18h)
SELECT  'vs15',a.command_id, a.start_time, a.end_time, a.output_device_type, a.status, a.input_type, 
        round(a.compression_ratio,2) as compression_ratio, a.input_bytes_display, a.output_bytes_display, a.time_taken_display
FROM V$RMAN_BACKUP_JOB_DETAILS@admin_vs15 a order by start_time desc;

hostgator