col INPUT_BYTES_PER_SEC_DISPLAY format a15;
col OUTPUT_BYTES_PER_SEC_DISPLAY format a15;
col TIME_TAKEN_DISPLAY format a17;
col status format a10;
COL hours FORMAT 999.999
COL out_size FORMAT a10

select session_key,AUTOBACKUP_DONE,OUTPUT_DEVICE_TYPE, INPUT_TYPE,status,ELAPSED_SECONDS/3600 hours, TO_CHAR(START_TIME,'yyyy-mm-dd hh24:mi') start_time, OUTPUT_BYTES_DISPLAY out_size,OUTPUT_BYTES_PER_SEC_DISPLAY,INPUT_BYTES_PER_SEC_DISPLAY from v$RMAN_BACKUP_JOB_DETAILS order by start_time ;

SESSION_KEY AUT OUTPUT_DEVICE_TYP INPUT_TYPE    STATUS        HOURS START_TIME       OUT_SIZE   OUTPUT_BYTES_PE INPUT_BYTES_PER
----------- --- ----------------- ------------- ---------- -------- ---------------- ---------- --------------- ---------------
         27 NO  DISK              DB INCR       FAILED         .001 2017-04-14 10:48     9.36M      1.87M           1.86M
         29 NO  DISK              DB FULL       FAILED         .011 2017-04-14 10:49   406.94M     10.43M          21.35M

v$v$RMAN_BACKUP_JOB_DETAILS 的OUTPUT_DEVICE_TYP 是DB INCR 并不表示不是全备，有可能是0级别备份。

ITPub博客

v$v$RMAN_BACKUP_JOB_DETAILS 的OUTPUT_DEVICE_TYP 是DB INCR

最新文章