Re: RMAN tape backups
From: Rich J <rjoralist3_at_society.servebeer.com>
Date: Mon, 05 Feb 2018 15:14:44 -0600
Message-ID: <92b48b46cdaf23ab0f449b12e647f3b7_at_society.servebeer.com>
WHERE
OPERATION = 'BACKUP'
AND object_type IN ('ARCHIVELOG','DB FULL','DB INCR') ORDER BY START_TIME DESC; YMMV. You'll want to make sure the "object_type" list in the WHERE clause works for you. Also look up BUG 14078947 in MOS to determine if V$RMAN_STATUS queries will benefit from a RULE hint workaround.
Date: Mon, 05 Feb 2018 15:14:44 -0600
Message-ID: <92b48b46cdaf23ab0f449b12e647f3b7_at_society.servebeer.com>
On 2018/02/05 14:56, Terrian, Thomas J CTR DLA INFO OPERATIONS (US) wrote:
> Does anyone have any scripts to monitor the current throughput of RMAN tape backups.
Hey Tom,
This is what I've been using on 11.2 to view backup times:
SELECT /*+ RULE BUG14078947_WORKAROUND */
command_id,
object_type,
status,
mbytes_processed,
start_time,
end_time,
ROUND((end_time - start_time)*24*60*60,1) elapsed_secs, ROUND(input_bytes/1024/1024,1) input_mb, ROUND(output_bytes/1024/1024,1) output_mb,CASE WHEN output_bytes = 0 THEN 0 ELSE ROUND(((input_bytes/output_bytes)-1)*100,1) END compress_ratio FROM v$rman_status
WHERE
OPERATION = 'BACKUP'
AND object_type IN ('ARCHIVELOG','DB FULL','DB INCR') ORDER BY START_TIME DESC; YMMV. You'll want to make sure the "object_type" list in the WHERE clause works for you. Also look up BUG 14078947 in MOS to determine if V$RMAN_STATUS queries will benefit from a RULE hint workaround.
HTH. GL! Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Feb 05 2018 - 22:14:44 CET