RE: RMAN tape backups
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-lReceived on Mon Feb 05 2018 - 22:42:09 CET