This discussion is archived
4 Replies Latest reply: Oct 29, 2013 7:28 PM by Hemant K Chitale RSS

Can't delete backuppiece

Jackie.KH Newbie
Currently Being Moderated

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 Oracle ACE
    Currently Being Moderated

    Do a CROSSCHECK BACKUP before the LIST EXPIRED BACKUP.

     

     

    Hemant K Chitale


  • 2. Re: Can't delete backuppiece
    Jackie.KH Newbie
    Currently Being Moderated

    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 Oracle ACE
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    Thank you so much

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points