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

I got ” RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due ”  error in Oracle database.

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

Details of error are as follows.

RMAN> DELETE NOPROMPT OBSOLETE DEVICE TYPE DISK;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 31 days
released channel: ORA_DISK_1
released channel: ORA_DISK_2
released channel: ORA_DISK_3
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1569 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=1475 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=1467 device type=DISK
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy 195 25-APR-11 /<DIR>/<DB_NAME>/dbs/<FILE_NAME>.f

RMAN-06207: WARNING: 1 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 /<DIR>/<DB_NAME>/dbs/<FILE_NAME>.f

WARNING: 1 objects could not be deleted for DISK channel(s) due

This ORA-00900 error is related with the objects could not be deleted for DISK channel(s) due to mismatched status. Use CROSSCHECK command to fix status.

If CROSSCHECK command is used:

RMAN> connect target /;

connected to target database: <DATABASE_NAME> (DBID=xxxxxxxx)

RMAN> connect catalog <USER>/xxxxx@<ALIAS>;

connected to recovery catalog database

RMAN> CROSSCHECK BACKUPPIECE '/<FILE_NAME>/<DATABASE_NAME>/dbs/<FILE_NAME>.f';

starting full resync of recovery catalog
full resync complete
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1475 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=1498 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=1504 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 06/14/2011 08:18:06
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20260: backup piece not found in the recovery catalog
RMAN-06092: error while looking up backup piece

RMAN> DELETE FORCE NOPROMPT OBSOLETE DEVICE TYPE DISK;


If RMAN-06214 still occurs, then try

RMAN> CROSSCHECK COPY OF CONTROLFILE;

Use the FORCE option with the DELETE command.

Example:
===========
DELETE FORCE NOPROMPT BACKUPSET ;


The FORCE command tells RMAN to clean the information out of the catalog regardless whether it
can find it on the media or not.

rman> report obsolete;

rman> crosscheck backups;

rman > delete obsolete;

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )