ZDLRA Backup Status 확인

ZDLRA Backup Status 확인

rasys로 접속 후

SELECT
    (select rd.POLICY_NAME "POLICY_NAME" from ra_database rd where rd.db_key=jd.db_key) "POLICY_NAME",
    (select rd. db_unique_name "DB_NAME" from ra_database rd where rd.db_key=jd.db_key) "DB_NAME",
    CASE WHEN INPUT_TYPE = 'DB INCR' THEN 'INCR'
    WHEN INPUT_TYPE = 'DB FULL' THEN 'FULL'
    WHEN INPUT_TYPE = 'ARCHIVELOG' THEN 'ARCHIVE'
    ELSE '' END "Schedule_Type",
    TO_CHAR(start_time,'yy-mm-dd hh24:mi:ss') "Backup Started Time",
    TO_CHAR(end_time,'yy-mm-dd hh24:mi:ss') "Backup Finished Time",
    round(INPUT_BYTES/1024/1024/1024,2) "Total Backup Size(GB)",
    CASE WHEN STATUS = 'COMPLETED' THEN 'C004' ELSE 'C005' END "Backup Result"
FROM RC_RMAN_BACKUP_JOB_DETAILS jd
WHERE INPUT_TYPE in ('DB INCR','DB FULL','ARCHIVELOG')
and start_time >= sysdate - 2
ORDER BY start_time, command_id
/

정책, 백업시간, 백업 용량, 결과 를 확인할 수 있습니다.