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

There are two options to remove the snapshot controlfile:

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.
OR
Firstly report Obsolete backups, then crosscheck them and delete obsolete backups as follows.
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 )

 

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

Your email address will not be published. Required fields are marked *