Re: RMAN tape backups

From: Rich J <>
Date: Mon, 05 Feb 2018 15:14:44 -0600
Message-ID: <>

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,

    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
    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

Received on Mon Feb 05 2018 - 22:14:44 CET

Original text of this message