[Oracle] RMAN 백업 현황 확인 쿼리

HYEOB KIM·2023년 1월 14일
0

Oracle

목록 보기
32/58
post-custom-banner
SQL> set lines 132 pages 100
col KEY          for 9,999
col INPUT_TYPE   for a12
col STATUS       for a10
col JOB_TIME     for a8
col RATIO        for 999
col INPUT_SEC    for a10
col OUTPUT_SEC   for a10
 
select SESSION_KEY 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, TIME_TAKEN_DISPLAY                     job_time, OPTIMIZED, round(COMPRESSION_RATIO, 0) Ratio, INPUT_BYTES_PER_SEC_DISPLAY Input_Sec, OUTPUT_BYTES_PER_SEC_DISPLAY Output_Sec
from V_$RMAN_BACKUP_JOB_DETAILS
order by 1
/
 
   KEY INPUT_TYPE   STATUS     START_TIME     END_TIME         JOB_TIME OPT RATIO INPUT_SEC  OUTPUT_SEC
------ ------------ ---------- -------------- -------------- -------- --- ----- ---------- ----------
     3 DB FULL        COMPLETED  12/13/19 00:49 12/13/19 00:49 00:00:10 NO      1    85.63M     72.28M
profile
Devops Engineer
post-custom-banner

0개의 댓글