3 Replies Latest reply: May 9, 2008 1:59 PM by ebrian RSS

    Expired Backups

    Daljit
      When I run DELETE OBSOLETE for sbt it gave me mismatch error for some of the archivelog backups and ask to run CROSSCHECK them. After running crosscheck for each mismatched backup piece the status of those has been changed to EXPIRED, so far so good. Now I want a way to show all the expired pieces with one command instead of running LIST command for every backup piece. Means when I say list expired backup it doesn't return anything but if I way list expired backuppiece 'piecename', it shows it as expired. There are more than 100 pieces and ran 100 crosscheck commands for each piece but now when its expired shouldn't there be a way to list all of them together? Here is what i am saying:

      RMAN> list expired backup;


      RMAN> list expired backup of archivelog all;


      RMAN> list expired backup;


      RMAN> list expired backup of archivelog all;

      RMAN> list expired copy of archivelog all;

      specification does not match any archive log in the recovery catalog

      RMAN> list expired archivelog all;

      specification does not match any archive log in the recovery catalog

      RMAN> list backuppiece 'hrjemeg6_1_1';


      List of Backup Pieces
      BP Key BS Key Pc# Cp# Status Device Type Piece Name
      ------- ------- --- --- ----------- ----------- ----------
      5697 5697 1 1 EXPIRED SBT_TAPE hrjemeg6_1_1

      RMAN>

      There are more than 100 expired archivelog backup pieces and I want to see the whole list with one LIST command, is it possible?

      Thanks
      Daljit Singh