标签：状态 FORMAT 备份 START TIME Oracle OPERATION col 1024
col OPERATION FORMAT a20
col STATUS FORMAT a20
col MBYTES_PROCESSED FORMAT 999999.99
select OPERATION,STATUS,OBJECT_TYPE,MBYTES_PROCESSED,
to_char(START_TIME,'yyyy-mm-dd hh24:mi:ss') AS START_TIME,
to_char(END_TIME,'yyyy-mm-dd hh24:mi:ss') AS END_TIME ,
ROUND(INPUT_BYTES/1024/1024/1024,2) AS INPUT_G,
ROUND(OUTPUT_BYTES/1024/1024/1024,2) AS OUTPUT_G
from v$rman_status
WHERE OPERATION = 'BACKUP'
ORDER BY START_TIME DESC
标签：状态,
FORMAT,
备份,
START,
TIME,
Oracle,
OPERATION,
col,
1024
From： https://www.cnblogs.com/Miac/p/17482107.html