Report RMAN JOB Process

（一）查看备份进度

相关视图V$RMAN_BACKUP_JOB_DETAILS 与V$RMAN_BACKUP_SUBJOB_DETAILS

SESSION_KEY: Session identifier

TIME_TAKEN_DISPLAY: Time taken

查看任务起始结束及耗时：

COL STATUS FORMAT a9

COL hrs    FORMAT 999.99

SELECT SESSION_KEY, INPUT_TYPE, STATUS,

       TO_CHAR(START_TIME,'mm/dd/yy hh24:mi') start_time,

       TO_CHAR(END_TIME,'mm/dd/yy hh24:mi')  end_time,

       ELAPSED_SECONDS/3600                 hrs

FROM V$RMAN_BACKUP_JOB_DETAILS

ORDER BY SESSION_KEY;

查看任务完成速度

COL in_sec FORMAT a10

COL out_sec FORMAT a10

COL TIME_TAKEN_DISPLAY FORMAT a10

SELECT SESSION_KEY,

       OPTIMIZED,

       COMPRESSION_RATIO,

       INPUT_BYTES_PER_SEC_DISPLAY in_sec,

       OUTPUT_BYTES_PER_SEC_DISPLAY out_sec,

       TIME_TAKEN_DISPLAY

FROM   V$RMAN_BACKUP_JOB_DETAILS

ORDER BY SESSION_KEY;

查看完成量

COL in_size  FORMAT a10

COL out_size FORMAT a10

SELECT SESSION_KEY,

       INPUT_TYPE,

       COMPRESSION_RATIO,

       INPUT_BYTES_DISPLAY in_size,

       OUTPUT_BYTES_DISPLAY out_size

FROM   V$RMAN_BACKUP_JOB_DETAILS

ORDER BY SESSION_KEY;

通过v$session_longops查看

SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,

       ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE"

FROM   V$SESSION_LONGOPS

WHERE  OPNAME LIKE 'RMAN%'

AND    OPNAME NOT LIKE '%aggregate%'

AND    TOTALWORK != 0

AND    SOFAR <> TOTALWORK;

（二）DEBUG模式

1. 使用10046事件跟踪

$ rman target / debug trace=/oracle/rman.trc log=/oracle/rman.log

RMAN> set echo on;

RMAN> sql "alter system set max_dump_file_size=UNLIMITED";

RMAN> sql "alter session set events ''10046 trace name context forever, level 12''";

执行备份

RMAN> backup current controlfile tag='bak_ctlfile' format='/oracle/ctl_file_%U_%T';

$ tail -100f /oracle/rman.trc

1. 使用RMAN debug

使用debug启动RMAN

$ rman target / debug trace=/oracle/rman.trc log=/oracle/rman.log

备份时打开debug

RMAN> RUN {DEBUG ON;

           backup current controlfile tag='bak_ctlfile' format='/oracle/ctl_file_%U_%T';

           DEBUG OFF;}