List expired backups in RMAN

List expired backup in the repository


RMAN> list expired backup;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
99      Full    9.61M      DISK        00:00:01     15-MAY-2014 07:01:14
        BP Key: 150   Status: EXPIRED  Compressed: NO  Tag: KEEP_180
        Piece Name: /SHARED/backup1/5ep8avdp_1_1_copy
        Keep: BACKUP_LOGS        Until: 11-NOV-2014 07:01:12
  Control File Included: Ckp SCN: 1133189      Ckp time: 15-MAY-2014 07:01:13