prompt RMAN Backup Information
prompt _______________________________________________________
prompt
col CONF# for 999999
col name for a40
col value for a10
select * from GV$RMAN_CONFIGURATION
/
prompt
prompt

prompt RMAN Backup Information (30 Days)
prompt _______________________________________________________
prompt
col SESSION_KEY  for 9,99999
col INPUT_TYPE   for a15
col STATUS       for a10
col JOB_TIME     for a8
col COMP_RATIO        for 999
col INPUT_SEC    for a10
col OUTPUT_SEC   for a10
col start_time for a15
col end_time for a15
select SESSION_KEY,
       INPUT_TYPE, 
       STATUS,
       to_char(START_TIME,'yy/mm/dd hh24:mi') start_time,
       to_char(END_TIME,'yy/mm/dd hh24:mi')   end_time,
       TIME_TAKEN_DISPLAY                     job_time,
       OPTIMIZED, 
       round(COMPRESSION_RATIO, 0) COMP_RATIO,
       INPUT_BYTES_PER_SEC_DISPLAY Input_Sec,
       OUTPUT_BYTES_PER_SEC_DISPLAY Output_Sec
from V$RMAN_BACKUP_JOB_DETAILS
where start_time >= trunc(sysdate-31)
order by 1
/

By haisins

오라클 DBA 박용석 입니다. haisins@gmail.com 으로 문의 주세요.

답글 남기기

이메일 주소를 발행하지 않을 것입니다. 필수 항목은 *(으)로 표시합니다