RMAN 信息查询

--查看RMAN配置

SELECT name "PARAMETERS", value "RMAN CONFIGURATION"
  FROM v$rman_configuration
 ORDER BY name;

--查看RMAN备份集
SELECT bs.recid,
       DECODE(bp.status, 'A', 'Available', 'D', 'Deleted', 'X', 'Expired') status,
       bp.handle handle,
       TO_CHAR(bp.start_time, 'dd/mm/yyyy HH24:MI:SS') start_time,
       TO_CHAR(bp.completion_time, 'dd/mm/yyyy HH24:MI:SS') completion_time,
       bp.elapsed_seconds "ELAPSED"
  FROM v$backup_set bs
  JOIN v$backup_piece bp
 USING (set_stamp, set_count)
 WHERE bp.status IN ('A', 'X')
   AND bp.completion_time > sysdate - 1
 ORDER BY bp.completion_time desc, bs.recid, bp.piece#;

--查看RMAN备份集
SELECT bs.recid,
       DECODE(backup_type,
              'L',
              'Archived Logs',
              'D',
              'Datafile Full',
              'I',
              'Incremental'