RE: RMAN tape backups

From: Matt Adams <MAdams_at_equian.com>
Date: Mon, 5 Feb 2018 21:42:09 +0000
Message-ID: <c35921a3f1b34a3988701e8e9fac06b1_at_wpvl1dag04.hcrec.com>



This is what I use to estimate completion time for running backups. Doesn't have a 'throughput' column, but you could probably add one.

Only looks at currently running backups

    select recid

, output_device_type
, dbsize_mbytes
, input_bytes/1024/1024 input_mbytes
, output_bytes/1024/1024 output_mbytes
, (output_bytes/input_bytes*100) compression
, (mbytes_processed/dbsize_mbytes*100) complete
, to_char(start_time + (sysdate-start_time)/(mbytes_processed/dbsize_mbytes),'DD-MON-YYYY HH24:MI:SS') est_complete

      from v$rman_status rs
       , (select sum(bytes)/1024/1024 dbsize_mbytes from v$datafile)
   where status='RUNNING'
    and output_device_type is not null

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Terrian, Thomas J CTR DLA INFO OPERATIONS (US) Sent: Monday, February 05, 2018 3:57 PM
To: 'oracle-l_at_freelists.org'
Subject: RMAN tape backups

Does anyone have any scripts to monitor the current throughput of RMAN tape backups.

  • This communication may contain privileged and/or confidential information. If you are not the intended recipient, you are hereby notified that disclosing, copying, or distributing of the contents is strictly prohibited. If you have received this message in error, please contact the sender immediately and destroy any copies of this document. ****
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 05 2018 - 22:42:09 CET

Original text of this message