RMAN --- deleteobsolete cannot delete control file copy

RMAN --- deleteobsolete cannot delete control file copy description tmpcontrlfiletmpcontrolfilebkphomeoraclecontrol01ctl has been deleted through the OS command the question is how to delete these obsolete records: the following is a copy description of the control file/tmp/contrlfile/tmp/controlfile that cannot be deleted during the test of RMAN --- delete obsolete. bkp/home/oracle/control01.ctl has been deleted through the OS command. Now the question is how to delete these obsolete records: The following is the test result: RMAN> report obsolete; RMAN retention policy will be applied to the commandRMAN retention policy is set to redundancy 1 Repor T of obsolete backups and copiesType Key Completion Time Filename/Handle -------------------- ------------------ -------------------- Control File Copy 2 22-APR-13/tmp/contrlfile. control File Copy 3 22-APR-13/tmp/controlfile. bkpControl File Copy 4 23-JUL-13/home/oracle/control01.ctl RMAN> delete obsolete; RMAN retention policy will be applied to the commandRMAN retention policy is set to re Dundancy 1 Deleting the following obsolete backups and copies: Type Key Completion Time Filename/Handle Completion ------ ------------------ Control File Copy 2 22-APR-13/tmp/contrlfile. control File Copy 3 22-APR-13/tmp/controlfile. bkpControl File Copy 4 23-JUL-13/home/oracle/control01.ctldyou really want to delete the above objects (enter YES or NO )? YesRMAN-06207: WARNING: 3 objects cocould not be deleted for DISK channel (s) dueRMAN-06208: to mismatched status. use CROSSCHECK command to fix statusRMAN-06210: List of Mismatched objectsRMAN-06211: ========================== RMAN-06212: object Type Filename/HandleRMAN-06213: --------------------------------------------------------------- RMAN-06214: Datafile Copy/tmp/contrlfile. RMAN-06214 File Copy/tmp/controlfile. bkpRMAN-06214: Datafile Copy/home/oracle/control01.ctl ---- use crosscheck to detect RMAN> crosscheck backup of database as prompted above; specification does not match any backup in the repository RMAN> crosscheck backup of controlfile; specification does not match any backup in the repository RMAN> delete expired backup; specification does not match any backup in the repository RMAN> list B Ackup summary; list of Backups ================== Key ty lv s Device Type Completion Time # Pieces # Copies Compressed Tag ---------------------------------------------------- ---------- --- 40 B F A DISK 19-NOV-13 1 1 NO TAG20131119T072057RMAN> ask everyone how to delete the above obsolete records! Solution: RMAN> crosscheck copy; specification does not match any datafile copy in the repositoryspecification does not match any archived log in the repositoryvalidation failed for control file copycontrol file copy file name =/home/oracle/control01.ctl RECID = 4 STAMP = 821523959 validation failed for control file copycontrol file copy file name =/tmp/controlfile. bkp RECID = 3 STAMP = 813384451 validation failed For control file copycontrol file copy file name =/tmp/contrlfile. RECID = 2 STAMP = 813384351 Crosschecked 3 objects RMAN> report obsolete; RMAN retention policy will be applied to the commandRMAN retention policy is set to redundancy 1 Report of obsolete backups and copiesType Key Completion Time Filename/Handle Completion ------ ---------------- invalid Control File Copy 2 22-A PR-13/tmp/contrlfile. control File Copy 3 22-APR-13/tmp/controlfile. bkpControl File Copy 4 23-JUL-13/home/oracle/control01.ctl RMAN> delete expired copy; specification does not match any datafile copy in the repositoryspecification does not match any archived log in the repositoryList of Control File Copies ========== ========== Key S Completion Time Ckp SCN Ckp Time --------------------- -- ---------- --------------- 4X23-JUL-13 2243850 23-JUL-13 Name:/home/oracle/control01.ctl Tag: TAG20130723T090559 3X22-APR-13 1495438 22-APR-13 Name:/tmp/controlfile. bkp Tag: TAG20130422T040730 2X22-APR-13 1490032 22-APR-13 Name:/tmp/contrlfile. tag: TAG20130422T040550 Do you really want to delete the above objects (enter YES or NO )? Yesdeleted control file copycontrol file copy file name =/home/oracle/control01.ctl RECID = 4 STAMP = 821523959 deleted control file copycontrol file copy file name =/tmp/controlfile. bkp RECID = 3 STAMP = 813384451 deleted control file copycontrol file copy file name =/tmp/contrlfile. RECID = 2 STAMP = 813384351 Deleted 3 EXPIRED objects RMAN> report expired; RMAN-00571: ========================================================== ==== ==================== RMAN-00569: ================ error message stack follows ============================ RMAN-00571: ========================================================== ============================== RMAN-00558: error encountered while parsing input commandsRMAN-01009: syntax error: found "expired": expecting one of: "device, need, obsolete, schema, unrecoverable" RMAN-01007: at line 1 column 8 file: standard input RMAN> report obsolete; RM AN retention policy will be applied to the commandRMAN retention policy is set to redundancy 1no obsolete backups found RMAN> summary: crosschecking BackupsThe CROSSCHECK command checks whether RMAN backups and copies in the repository are still readable by RMAN. assuming that you have configured automatic channels, you can run these commands: RMAN> crosscheck backup; # checks RMAN backups on configured DevicesRMAN> crosscheck copy; # checks RMAN image copies on configured devices commands are a little different, but the backup type must be clearly recognized. If backups are stored with a media manager and sbt channels are not configured, then you must allocate a maintenance channel before CROSSCHECK and DELETE commands on sbt devices: RMAN> allocate channel for maintenance device type sbt; --- if a tape library is used FOR backup, a dedicated maintenance channel is required. RMAN> crosscheck backup;