set lines 300
col start_time form a16
col end_time form a16
col time_taken form a5
col compress_ratio form a5
select status,
input_type,
output_device_type,
round(to_number(input_bytes)/1024/1024/1024) input_bytes,
to_char(round(compression_ratio,1),'99D9') compress_ratio,
to_char(start_time,'DD-MM-YYYY HH24:MI') start_time,
to_char(end_time,'DD-MM-YYYY HH24:MI') end_time,
substr(time_taken_display,1,5) time_taken
from V$RMAN_BACKUP_JOB_DETAILS;

RMAN-08137 While Deleting Archived Logs from Standby

    
select x.ksppinm name,y.ksppstvl value
  from sys.x$ksppi x,sys.x$ksppcv y
where x.inst_id=userenv('Instance')
   and y.inst_id=userenv('Instance')
   and x.indx=y.indx
   and x.ksppinm='_deferred_log_dest_is_valid';
 
alter system set log_archive_dest_state_2 = defer scope=both;
alter system set log_archive_dest_state_3 = defer scope=both;
alter system set "_deferred_log_dest_is_valid" = FALSE scope=both;

rman > delete archivelog all;

   
    SELECT FILE#, INCREMENTAL_LEVEL, COMPLETION_TIME
  -- , BLOCKS, DATAFILE_BLOCKS
FROM V$BACKUP_DATAFILE@rd_fcsprd01.world
 WHERE INCREMENTAL_LEVEL > 0
   AND BLOCKS/DATAFILE_BLOCKS > .5
ORDER BY COMPLETION_TIME;
HOME