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>

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

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