Anuroop Challa

scripts to check RMAN back up information - script2 =============================================== in this scripts -2 you get OUPUT rate write to tape ================================================ SELECT (SELECT instance_name FROM v$instance) || ' ' || (SELECT instance_number FROM v$instance) instance,rs.sid, rj.COMMAND_ID,rj.STATUS,max(rj.START_TIME) STARTED_TIME, rj.END_TIME,trunc(rj.ELAPSED_SECONDS/60) as "Elapsed_Minutes",rj.INPUT_TYPE,rj.OUTPUT_DEVICE_TYPE, rj.INPUT_BYTES/1024/1024/1024 "DB_SIZE(GB)", rj.OUTPUT_BYTES/1024/1024/1024 "Backup_Size", rj.OUTPUT_BYTES_PER_SEC_DISPLAY "Output_rate(p/s)" from v$rman_backup_job_details rj, v$rman_status rs where rj.COMMAND_ID=rs.COMMAND_ID group by rs.sid,rj.COMMAND_ID,rj.STATUS,rj.START_TIME,rj.END_TIME,rj.ELAPSED_SECONDS,rj.INPUT_TYPE,rj.OUTPUT_DEVICE_TYPE,rj.INPUT_BYTES,rj.OUTPUT_BYTES,rj.OUTPUT_BYTES_PER_SEC_DISPLAY having max(rj.START_TIME) > sysdate-10 order by rj.STAR...

scripts to check RMAN back up  information. =================================================================== Below script will provide you clear details enter number days to get output as per your need. =================================================================== set lines 220 set pages 1000 col cf for 9,999 col df for 9,999 col elapsed_seconds heading "ELAPSED|SECONDS" col i0 for 9,999 col i1 for 9,999 col l for 9,999 col output_mbytes for 9,999,999 heading "OUTPUT|MBYTES" col session_recid for 999999 heading "SESSION|RECID" col session_stamp for 99999999999 heading "SESSION|STAMP" col status for a10 trunc col time_taken_display for a10 heading "TIME|TAKEN" col output_instance for 9999 heading "OUT|INST" select   j.session_recid, j.session_stamp,   to_char(j.start_time, 'yyyy-mm-dd hh24:mi:ss') start_time,   to_char(j.end_time, 'yyyy-mm-dd hh24:mi:ss') end_time,   (j.output_by...