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级别备份。
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博客 ” ,链接:http://blog.itpub.net/24052272/viewspace-2137264/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24052272/viewspace-2137264/