4 Replies Latest reply: Oct 29, 2013 9:28 PM by Hemant K Chitale RSS

    Can't delete backuppiece

    Jackie.KH

      Hi All,

       

      After I lost some backuppiece then I can't delete it with delete obsolete command in RMAN

       

      RMAN> delete obsolete;

       

      RMAN retention policy will be applied to the command

      RMAN retention policy is set to redundancy 1

      using channel ORA_SBT_TAPE_1

      using channel ORA_DISK_1

      Deleting the following obsolete backups and copies:

      Type                 Key    Completion Time    Filename/Handle

      -------------------- ------ ------------------ --------------------

      Datafile Copy        1      18-AUG-13          /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-SYSTEM_FNO-5_2sohim96

      Datafile Copy        2      18-AUG-13          /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-UNDOTBS1_FNO-6_2tohimrp

      Datafile Copy        5      24-AUG-13          /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-SYSTEM_FNO-1_3boi2hf0

      Datafile Copy        6      06-SEP-13          /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-FCCDATALAR_FNO-8_70oj4r5i

      Datafile Copy        7      06-SEP-13          /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-SYSAUX_FNO-7_72oj4t7r

      Datafile Copy        8      06-SEP-13          /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-UNDOTBS1_FNO-3_73oj4tib

      Datafile Copy        9      06-SEP-13          /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-SYSAUX_FNO-2_74oj4tpm

      Datafile Copy        10     06-SEP-13          /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-FCCINDXMED_FNO-11_75oj4tt9

      Datafile Copy        11     06-SEP-13          /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-FCCDATASML_FNO-9_76oj4tvk

       

      Do you really want to delete the above objects (enter YES or NO)? YES

       

      RMAN-06207: WARNING: 9 objects could not be deleted for DISK channel(s) due

      RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix status

      RMAN-06210: List of Mismatched objects

      RMAN-06211: ==========================

      RMAN-06212:   Object Type   Filename/Handle

      RMAN-06213: --------------- ---------------------------------------------------

      RMAN-06214: Datafile Copy   /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-SYSTEM_FNO-5_2sohim96

      RMAN-06214: Datafile Copy   /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-UNDOTBS1_FNO-6_2tohimrp

      RMAN-06214: Datafile Copy   /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-SYSTEM_FNO-1_3boi2hf0

      RMAN-06214: Datafile Copy   /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-FCCDATALAR_FNO-8_70oj4r5i

      RMAN-06214: Datafile Copy   /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-SYSAUX_FNO-7_72oj4t7r

      RMAN-06214: Datafile Copy   /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-UNDOTBS1_FNO-3_73oj4tib

      RMAN-06214: Datafile Copy   /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-SYSAUX_FNO-2_74oj4tpm

      RMAN-06214: Datafile Copy   /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-FCCINDXMED_FNO-11_75oj4tt9

      RMAN-06214: Datafile Copy   /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-FCCDATASML_FNO-9_76oj4tvk

       

       

      RMAN> list expired backup;

       

      specification does not match any backup in the repository

       

      RMAN>

       

      What should I do to force delete them?

       

      Thank in advance

        • 1. Re: Can't delete backuppiece
          Hemant K Chitale

          Do a CROSSCHECK BACKUP before the LIST EXPIRED BACKUP.

           

           

          Hemant K Chitale


          • 2. Re: Can't delete backuppiece
            Jackie.KH

            Hello HemantKChitale,

             

            RMAN> crosscheck backup;

             

            using channel ORA_DISK_1

            specification does not match any backup in the repository

             

            RMAN> list expired backup;

             

            specification does not match any backup in the repository

             

            RMAN> delete obsolete;

             

            RMAN retention policy will be applied to the command

            RMAN retention policy is set to redundancy 1

            using channel ORA_DISK_1

            Deleting the following obsolete backups and copies:

            Type                 Key    Completion Time    Filename/Handle

            -------------------- ------ ------------------ --------------------

            Datafile Copy        1      18-AUG-13          /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-SYSTEM_FNO-5_2sohim96

            Datafile Copy        2      18-AUG-13          /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-UNDOTBS1_FNO-6_2tohimrp

            Datafile Copy        5      24-AUG-13          /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-SYSTEM_FNO-1_3boi2hf0

            Datafile Copy        6      06-SEP-13          /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-FCCDATALAR_FNO-8_70oj4r5i

            Datafile Copy        7      06-SEP-13          /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-SYSAUX_FNO-7_72oj4t7r

            Datafile Copy        8      06-SEP-13          /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-UNDOTBS1_FNO-3_73oj4tib

            Datafile Copy        9      06-SEP-13          /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-SYSAUX_FNO-2_74oj4tpm

            Datafile Copy        10     06-SEP-13          /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-FCCINDXMED_FNO-11_75oj4tt9

            Datafile Copy        11     06-SEP-13          /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-FCCDATASML_FNO-9_76oj4tvk

             

            Do you really want to delete the above objects (enter YES or NO)? YES

             

            RMAN-06207: WARNING: 9 objects could not be deleted for DISK channel(s) due

            RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix status

            RMAN-06210: List of Mismatched objects

            RMAN-06211: ==========================

            RMAN-06212:   Object Type   Filename/Handle

            RMAN-06213: --------------- ---------------------------------------------------

            RMAN-06214: Datafile Copy   /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-SYSTEM_FNO-5_2sohim96

            RMAN-06214: Datafile Copy   /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-UNDOTBS1_FNO-6_2tohimrp

            RMAN-06214: Datafile Copy   /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-SYSTEM_FNO-1_3boi2hf0

            RMAN-06214: Datafile Copy   /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-FCCDATALAR_FNO-8_70oj4r5i

            RMAN-06214: Datafile Copy   /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-SYSAUX_FNO-7_72oj4t7r

            RMAN-06214: Datafile Copy   /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-UNDOTBS1_FNO-3_73oj4tib

            RMAN-06214: Datafile Copy   /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-SYSAUX_FNO-2_74oj4tpm

            RMAN-06214: Datafile Copy   /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-FCCINDXMED_FNO-11_75oj4tt9

            RMAN-06214: Datafile Copy   /u01/app/oracle/product/11.2.0/db_1/dbs/data_D-KRDTRN_I-3243774756_TS-FCCDATASML_FNO-9_76oj4tvk

             

             

            RMAN>

            • 3. Re: Can't delete backuppiece
              Hemant K Chitale

              So, you don't have any BackupPieces  (because the CROSSCHECK BACKUP reports none).

              All you have are Datafile copies.

               

              Then you should run

              CROSSCHECK COPY

              or

              CROSSCHECK COPY OF DATAFILE 1  (and so on for all the datafiles).

               

              Then, if it reports the datafile copies as Expired, you can run

              DELETE EXPIRED COPY OF DATAFILE 1 (and so on for all the datafiles).

               

              But you need to confirm why you don't have any backup pieces -- apparently you haven't been taking backups as backupsets but only as datafile copies.

               

              Hemant K Chitale


              • 4. Re: Can't delete backuppiece
                Jackie.KH

                Thank you so much