Oracle备份状态 

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
posted @ 2023-06-15 10:04  Coye  阅读(9)  评论(0)  编辑  收藏  举报